Page Comparison

HDR_STATUS_NAME
(TM_STATUS)

Timesheet Status

String

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

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

PROC_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

VENDOR_NAME

Vendor

String

Vendor Name

LAST_DOC_NUMBER

Document Number

Integer

Document Status

STD_HOURS

Standard Hours

String

FIRST_LAST

Full Name (Last, First)

String

Employee/User

First Name,

Last Name

HOME_DEPT_NAME

Home Department

String

Home Department Name

EMPLY_TYPE_NAME

Employee Type

String

Employee Type 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

FULL_PART_TIME
(FULL_PART)

Full/Part Time

String

Full or Part Time

EXEMPT

Exempt

String

Employee Exempt

BILL_HOURS
(TM_TOTAL_BILL)

Total Billable Hours

String

Timesheet Total Billable Hours

TOTAL_HOURS
(TM_TOTAL_HOURS)

Total Hours

String

Timesheet Total Hours

VALIDATION_TYPE_NAME
(VALIDATION_TYPE)

Validation Type

String

Validation Type Name:
Report contains advance request while other requests are still outstanding
Advance based on preathorization not paid yet
Trip and TA are not matching
Custom Validation
Report contains possible duplicate charges
Report contains possible duplicate across Approved reports
Report contains Future Charges (None TA Reports)
Report contains invalid expense type
Report is incomplete
Report has invalid OBS
Report has invalid WBS
Only one Lodging is allowed per day
Report contains modified lines different from preauthorized report
Reimbursement Policy
WBS Policy
Report contains no lines

WORK_DEPT_CODE

Worked Department Code

String

Worked Department Code

WORK_DEPT_NAME

Worked Department

String

Worded Department Name

ERROR_TYPE

Error Type

String

Validation Type:
*Error
*Warning
*Notes provided

WORK_FUNC_CODE

Worked Function Code

String

Worked Function Code

WORK_FUNC_NAME

Worked Function

String

Worked Function 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

WORK_LOC_CODE

Worked Location Code

String

Work Location Code

WORK_LOC_NAME

Worked Location

String

Worked Location Name

NOTE

Note

String

Approver Notes

WORK_OPT_CODE

Worked Operating Unit Code

String

Worked Operating Unit Code

WORK_OPT_NAME

Worked Operating Unit

String

Worked Operating Unit Name

PAY_CODE
(TC_CODE)

Time Code

String

Time Code

PC_NAME
(TC_NAME)

Time Code Name

String

Time Code Name

SECTION
(ERROR_SECTION)

Error Location

String

Section of error:
*Report
*Detail
*WBS
*Attendee
*Custom Field

T_LINE_NO

Line ID

Integer

Timesheet Line Id

VALIDATION_MSG

Validation Message

String

Validation Message

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

SSN

String

Employee Other id that is mapped to SSN field.

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

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start