Page Comparison

This domain is used to show hours charged, the billing rate and amount. Examples:

...

The domains consists of the following columns (NOTE: Column names could be renamed so you might see different names based on your side configuration, so the following names are the base names of the system)

(NOTE: Version 5.1.x MUST select: - Convert Bill to Currency, default USD)

Column ID	Column Name (From DBLabels.properties)	Data Type	Description

LAST

BATCH_TYPE_

FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

LEVEL1_CODE

Level1 Code

String

WBS Level1 Code

LEVEL2_CODE

Level2 Code

String

WBS Level2 Code

LEVEL3_CODE

Level3 Code

String

WBS Level3 Code

LEVEL4_CODE

Level4 Code

String

WBS Level4 Code

LEVEL1_NAME

Level1

String

WBS Level1 Name

LEVEL2_NAME

Level2

String

WBS Level2 Name

LEVEL3_NAME

Level3

String

WBS Level3 Name

LEVEL4_NAME

Level4

String

WBS Level4 name

LOCK_BY

Locked By

String

Locked by if the timesheet is in Status: Open or Closed

LOCK_DT

Locked Datetime Stamp

Datetime

Locked Datetime if the timesheet is in Status: Open or Closed

HDR_WK_END

Period End

Date

Timesheet Period End

T_LINE_NO

Line ID

Integer

Timesheet Line Id

EVENT_DATE

Event Date

Date

Timesheet Column Date

VALUE
(HOURS)

Hours

Decimal

Hours

PAY_CODE
(TC_CODE)

Time Code

String

Time Code

PC_NAME
(TC_NAME)

Time Code Name

String

Time Code Name

PREV_STATUS
(TM_PREV_STATUS)

Timesheet Previous Status

String

Previous Status could be one of the following:
On Hold
Released
In Approval Status
Rejected
Approved

TM_STATUS

Timesheet Status

String

Timesheet status:
On Hold
Open
Released
Closed
In Approval Status
Rejected
Approved

TM_VALID_STATUS

Timesheet Validation Status

String

Timesheet Validation Status could be one of the following:
*Failed
*Warnings
*Passed
*No Action

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

FUNCTCODE
(HOME_FUNC_CODE)

Home Function Code

String

Home Function Code

EMPLY_TYPE

Employee Type ID

String

Employee Type ID

LOCATION_CODE
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

1	Databasics Extract Batch Type	String	Databasics Extract Batch Type
BATCH_TYPE_2	DATABASICS ACH	String	DATABASICS ACH
BATCH_TYPE_3	Batch type 3	String	Used for additional batch types
BATCH_TYPE_4	Batch type 4	String	Used for additional batch types
BATCH_TYPE_5	Batch type 5	String	Used for additional batch types
bill_amount (CONV_BILL_AMOUNT)	Converted Bill Amount	Decimal
BILL_CONVERT_CURR	Convert to Currency	String
BILL_CONV_OPTION	Currency Conversion Option	String
BILL_FLAG (TM_BILL_FLAG)	Billable flag	String	Billable Flag
CONV_TM_BILL_RATE (CONV_BILL_RATE)	Converted Bill Rate	Decimal
CONV_TM_COST_RATE_STAND	Hourly/Standard Hours based rate	Decimal
CONV_TM_COST_RATE_TOTAL	Hourly/Total Hours based rate	Decimal
COST_AMOUNT_BASED_ON_STAND	Cost Amount based on Hourly/Standard based rate	Decimal
COST_AMOUNT_BASED_ON_TOTAL	Cost Amount based on Hourly/Total Hours based rate	Decimal
DEPT_CODE (WORK_DEPT_CODE)	Worked Department Code	String	Worked Department Code
DEPT_CODE (HOME_DEPT_CODE)	Home Department Code	String	Home Department Code
EMP_ACTIVE	Active Employee	String	Employee Active Yes or No
EMPLY_CURR_ID	Employee Currency	String	Employee Currency
EMPLY_ID	Employee ID	String	Employee Id
EMPLY_TYPE	Employee Type Code	String	Employee Type ID
EMPLY_TYPE_NAME	Employee Type	String	Employee Type Name
FUNCTCODE (WORK_FUNC_CODE)	Worked Function Code	String	Worked Function Code
FUNCTCODE (HOME_FUNC_CODE)	Home Function Code	String	Home Function Code
FUNCTION_NAME (WORK_FUNC_NAME)	Worked Function	String	Worked Function Name
HOME_DEPT_NAME	Home Department	String	Home Department Name
HOME_FUNC_NAME	Home Function	String	Home Function Name
HOME_LOC_NAME	Home Location	String	Home Location Name
HOME_OPT_NAME	Home Operating Unit	String	Home Operating Unit Name

EMPLY_TYPE

Employee Type ID

String

Employee Type ID

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

OPT_CODE
(WORK_OPT_CODE)

Worked Operating Unit Code

String

Worked Operating Unit Code

OPT_NAME
(WORK_OPT_NAME)

Worked Operating Unit

String

Worked Operating Unit Name

DEPT_CODE
(WORK_DEPT_CODE)

Worked Department Code

String

Worked Department Code

DEPT_CODE
(WORK_DEPT_NAME)

Worked Department

String

Worded Department Name

FUNCTCODE
(WORK_FUNC_CODE)

Worked Function Code

String

Worked Function Code

FUNCTION_NAME
(WORK_FUNC_NAME)

Worked Function

String

Worked Function Name

LOCATION_CODE
(WORK_LOC_CODE)

Worked Location Code

String

Work


L1_END_DATE	Level1 End Date	Date	Level 1 End Date
L1_START_DATE	Level1 Start Date	Date	Level 1 Start Date
LAST_DOC_NUMBER	Document Number	Integer	Document Number
LAST_FIRST	Full Name (Last, First)	String	Employee/User Last Name, First Name
LEVEL1_CODE	Level1 Code	String	WBS Level1 Code
LEVEL1_FLAG	Level1 Flag	String	WBS Level1 Flag
LEVEL1_NAME	Level 1	String	WBS Level1 Name
LEVEL1_TYPE	Level1 Type	String	WBS Level1 Type
LEVEL2_CODE	Level2 Code	String	WBS Level2 Code
LEVEL2_FLAG	Level2 Flag	String	WBS Level2 Flag
LEVEL2_NAME	Level 2	String	WBS Level2 Name
LEVEL2_TYPE	Level2 Type	String	WBS Level2 Type
LEVEL3_CODE	Level3 Code	String	WBS Level3 Code
LEVEL3_NAME	Level 3	String	WBS Level3 Name
LEVEL4_CODE	Level4 Code	String	WBS Level4 Code
LEVEL4_NAME	Level 4	String	WBS Level4 name
LOCATION_CODE (WORK_LOC_CODE)	Worked Location Code	String	Work Location Code
LOCATION_CODE (HOME_LOC_CODE)	Home Location Code	String	Home Location Code
LOCATION_NAME (WORK_LOC_NAME)	Worked Location	String	Worked Location Name

CONV_TM_BILL_RATE
(CONV_BILL_RATE)

Converted Bill Rate

Decimal

bill_amount
(CONV_BILL_AMOUNT)

Converted Bill Amount

Decimal

BILL_CONVERT_CURR

Convert to Currency

String

BILL_CONV_OPTION

Currency Conversion Option

String

BILL_FLAG
(TM_BILL_FLAG)

Billable flag

String

Billable Flag

LAST_DOC_NUMBER

Document Number

Integer

Document Number

PROCESS_STATUS
(TM_PROCESS_STATUS)

Process Status

String

Process Status could be one of the following:
*Posted
*Not Posted

VENDOR_ID

Vendor ID

String

Vendor ID

BATCH_TYPE_1

Databasics Extract Batch Type

String

Databasics Extract Batch Type

BATCH_TYPE_2

DATABASICS ACH

String

DATABASICS ACH

BATCH_TYPE_3

Batch type 3

String

Used for additional batch types

BATCH_TYPE_4

Batch type 4

String

Used for additional batch types

BATCH_TYPE_5

Batch type 5

String

Used for additional batch types

TIME_IN

Time In

DateTime

First Time In on Timesheet

TIME_IN1

Time In 1

DateTime

Second Time In on Timesheet

TIME_OUT

Time Out

DateTime

First Time Out on Timesheet

TIME_OUT1

Time Out 1

DateTime

Second Time Out on Timesheet

LEVEL1_FLAG

Level1 Flag

String

WBS Level1 Flag

LEVEL2_FLAG

Level2 Flag

String

WBS Level2 Flag

LEVEL1_TYPE

Level1 Type

String

WBS Level1 Type

LEVEL2_TYPE

Level2 Type

String

WBS Level2 Type

MAIN_WBS_CODE

WBS Main WBS Code

String

WBS Main WBS Code

MAIN_WBS_NAME

WBS Main WBS Name

String

WBS Main WBS Name

OTHER_EMPLY_ID1

Other Employee ID1

String

Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table

OTHER_EMPLY_ID2

Other Employee ID2

String

Employee Other id2

SSN

String

Employee Other id that is mapped to SSN field.

TODAY_DATE

DATE

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

EMPLY_ID

Employee ID

String

Employee Id

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

L1_END_DATE

Level1 End Date

Date

LOCK_BY	Locked By	String	Locked by if the timesheet is in Status: Open or Closed
LOCK_DT	Locked Datetime Stamp	Datetime	Locked Datetime if the timesheet is in Status: Open or Closed
MAIN_WBS_CODE	Main WBS Code	String	WBS Main WBS Code
MAIN_WBS_NAME	Main WBS	String	WBS Main WBS Name
OPT_CODE (WORK_OPT_CODE)	Worked Operating Unit Code	String	Worked Operating Unit Code
OPT_CODE (HOME_OPT_CODE)	Home Operating Unit Code	String	Home Operating Unit Code
OPT_NAME (WORK_OPT_NAME)	Worked Operating Unit	String	Worked Operating Unit Name
OTHER_EMPLY_ID1	Other Employee ID1	String	Employee Other id1 that is mapped to OTHER_EMPLY_ID1 in the employee table
OTHER_EMPLY_ID2	Other Employee ID2	String	Employee Other id2
PAY_CODE (TC_CODE)	Time Code	String	Time Code
PC_NAME (TC_NAME)	Time Code Name	String	Time Code Name
PREV_STATUS (TM_PREV_STATUS)	Timesheet Previous Status	String	Previous Status could be one of the following: On Hold Released In Approval Status Rejected Approved
SSN	SSN	String	Employee Other id that is mapped to SSN field.
T_LINE_NO	Line ID	Integer	Timesheet Line Id
TM_STATUS	Timesheet Status	String	Timesheet status: On Hold Open Released Closed In Approval Status Rejected Approved
TM_VALID_STATUS	Timesheet Validation Status	String	Timesheet Validation Status could be one of the following: Failed Warnings Passed No Action
TODAY_DATE	Today	Date	Today's Date - Used for Scheduling Report
VALUE (HOURS)	Hours	Decimal	Hours
VENDOR_ID	Vendor ID	String	Vendor ID
L1_END_DATE	L1_END_DATE	Date	Level 1 End Date
L1_START_DATE

Level1 Start Date

L1_START_DATE

Date

Level 1 Start Date

L2

L1_

END

CLOSE_DATE

Level2 End

Level1 Close Date

Date

Level

2 End

1 Close Date

L2_

START

CLOSE_DATE

Level2

Start

Close Date

Date

Level 2

Start

Close Date
L1_OPEN_DATE	Level1 Open Date	Date	Level 1 Open Date

L1

L2_

CLOSE

END_DATE

Level1 Close

Level2 End Date

Date

Level

1 Close

2 End Date

L2

L1_

OPEN

OPT_

DATE

Level2 Open Date

Date

Level 2 Open Date

CODE	Level1 Operating Unit Code	String	Level 1 Operating Unit Code
L2_

CLOSE

OPEN_DATE

Level2

Close

Open Date

Date

Level 2

Close

Open Date

L1_OPT_

CODE

NAME	Level1 Operating Unit

Code

String

Level 1 Operating Unit

Code

Name

L1

L2_

OPT

START_

NAME

Level1 Operating Unit

String

Level 1 Operating Unit Name

DATE	Level2 Start Date	Date	Level 2 Start Date
HDR_WK_END	Period End	Date	Timesheet Period End
HDR_WK_START	Period Start	Date	Timesheet Period Start

Versions Compared

Old Version 1

New Version 2

Key

(NOTE: Version 5.1.x MUST select: - Convert Bill to Currency, default USD)