Timesheet Summary Hours Domain

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

DEPT_CODE
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_TYPE

Employee Type Code

String

Employee Type ID

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

FUNCTCODE
(HOME_FUNC_CODE)

Home Function Code

String

Home 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

LOCATION_CODE
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

LOCK_BY

Locked By

String

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

OPT_CODE
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

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

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

PROCESS_STATUS
(TM_PROCESS_STATUS)

Process Status

String

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

SSN

SSN

String

Employee Other id that is mapped to SSN field.

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

VENDOR_ID

Vendor ID

String

Vendor ID

BILL_HOURS
(TM_TOTAL_BILL)

Total Billable Hours

String

Timesheet Total Billable Hours

LEAVE_HOURS
(TM_TOTAL_Leave)

Total Leave Hours

String

Timesheet Total Leave Hours

NON_BILL_HOURS
(TM_TOTAL_NON_BILL)

Total Non-Billable Hours

String

Timesheet Total Non-Billable Hours

TOTAL_HOURS
(TM_TOTAL_HOURS)

Total Hours

String

Timesheet Total Hours

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

FIRST_RELEASED_DATE

First Released date

String

Submitted Date

LAST_APPROVED_DATE

Last Approved Date

String

Last Approval Date

HDR_WK_END

Period End

Date

Timesheet Period End

LOCK_DT

Locked Datetime Stamp

Datetime

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