Time Approval Summary Domain

5.1.x to 5.4.4

Time Approval Summary 5.1.x

Domains

5.5 and higher

Time Approval Summary

DomainsV55

APP_ACTION

Approval Action

String

Approval Action - Approved or Rejected

APPROVAL_ID

Approver ID

String

Approval ID

APPROVAL_NAME

Approver

String

Approver Full Name

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

NOTES

Notes

String

Approver Notes

PROC_STATUS
(TM_REPORT_PROC_STATUS)

Process Status

String

Process Status could be one of the following:
*Fully Paid
*Partially Paid 
*Posted for Payment 
*No action (Default - Not posted) 

VENDOR_ID

Vendor ID

String

Vendor ID that is linked to the report that got requested

VENDOR_NAME

Vendor

String

Vendor Name

LAST_DOC_NUMBER

Document Number

Integer

Document Number

STD_HOURS

Standard Hours

String

LAST_FIRST

Full Name (First Last)

String

Employee/User Last Name, First Name

BILL_HOURS
(TM_TOTAL_BILL)

Total Billable Hours

String

Timesheet Total Billable Hours

TOTAL_HOURS
(TM_TOTAL_HOURS)

Total Hours

String

Timesheet Total Hours

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

COPY_DT_CHAR
(APPROVER_DT)

Approver Action DateTime

String

Converted DTSTAMP to string, if no action field is blank

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.

TODAY_DATE

Today

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 Operating Unit Code

String

Home Operating Unit Code

REF_TYPE

Approval Reference Type

String

Approval Reference Type

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start

Approval Group Status

String