Time Approval Summary Domain

This domain displays the approval structure tied to a timesheet. Examples:

Timesheets waiting for Approval
Approval Queue by Approver
Timesheet Approval History

Supported Version	Domain Name	Domain Folder
5.1.x to 5.4.4	Time Approval Summary 5.1.x	Domains
5.5 and higher	Time Approval Summary	DomainsV55

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)

Column ID	Column Name (From DBLabels.properties)	Data Type	Description
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 Name	String	Vendor Name
HDR_WK_END	Period End	Date	Timesheet Period End
HDR_WK_START	Period Start	Date	Timesheet Period Start
LAST_DOC_NUMBER	Document Number	Integer	Document Number
STD_HOURS	Standard Hours	String
LAST_FIRST	Full Name (Last, First)	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
HDR_DATE (DTSTAMP)	DateTime Stamp	DateTime	Timesheet Header DateTime Stamp
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		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 ID	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