Time Posted Transactions by Batch Domain

BATCH_ID

Batch ID

String

Batch Id

COST_RATE

Cost Rate

String

Cost Rate

DEPT_CODE
(WORK_DEPT_CODE)

Worked Department Code

String

Worked Department Code

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

FUNCTCODE
(WORK_FUNC_CODE)

Worked Function Code

String

Worked Function Code

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

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_NAME

Level 1

String

WBS Level1 Name

LEVEL2_CODE

Level2 Code

String

WBS Level2 Code

LEVEL2_NAME

Level 2

String

WBS Level2 Name

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

OPT_CODE
(WORK_OPT_CODE)

Worked Operating Unit Code

String

Worked Operating Unit Code

OTHER_EMPLY_ID
(OTHER_EMPLY_ID1)

Other Employee ID1

String

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

PAY_CODE
(TC_CODE)

Time Code

String

Time Code

POST_DOC_STATUS

Adjustment Status

String

POST_STATUS

Post Status

String

T_LINE_NO

Line ID

Integer

Timesheet Line Id

TC_NAME

Time Code Name

String

Time Code Name

TM_BILL_FLAG

Billable flag

String

Billable Flag

TM_PREV_STATUS

Timesheet Previous Status

String

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

TM_PROCESS_STATUS

Process Status

String

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

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

TOTAL_COST

Total Cost

Integer

VALUE
(HOURS)

Hours

Decimal

Hours

VENDOR_ID

Vendor ID

String

Vendor ID

WORK_DEPT_NAME

Worked Department

String

Worded Department Name

WORK_FUNC_NAME

Worked Function

String

Worked Function Name

WORK_LOC_NAME

Worked Location

String

Worked Location Name

WORK_OPT_NAME

Worked Operating Unit

String

Worked Operating Unit Name

COST_RATE_TYPE

Cost Rate Type

String

Cost Rate Type

LEVEL1_FLAG

Level1 Flag

String

WBS Level1 Flag

LEVEL1_TYPE

Level1 Type

String

WBS Level1 Type

MAIN_WBS_CODE

Main WBS Code

String

WBS Main WBS Code

MAIN_WBS_NAME

Main WBS

String

WBS Main WBS Name

LEVEL2_FLAG

Level2 Flag

String

WBS Level2 Flag

LEVEL2_TYPE

Level2 Type

String

WBS Level2 Type

OTHER_EMPLY_ID2

Other Employee ID2

String

Employee Other id2

SSN

SSN

String

Employee Other id that is mapped to SSN field.

L1_OPT_CODE

Level1 Operating Unit Code

String

Level 1 Operating Unit Code

L1_OPT_NAME

Level1 Operating Unit

String

Level 1 Operating Unit Name

TODAY_DATE

TODAY_DATE

Date

Today's Date - Used for Scheduling Report

EMP_ACTIVE

Active Employee

String

Employee Active Yes or No

EMPLY_ID

Employee ID

String

Employee Id

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_TYPE

Employee Type Code

String

Employee Type ID

FUNCTCODE
(HOME_FUNC_CODE)

Home Function Code

String

Home Function Code

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

DTSTAMP

DateTime Stamp

DateTime

DateTime Stamp

HDR_WK_END

Period End

Date

Timesheet Period End

POST_DT

Post Date

Sting

Post Date