Versions Compared

Old Version 2

changes.mady.by.user Young White (Deactivated)

Saved on

compared with

New Version Current

changes.mady.by.user Young White (Deactivated)

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

...

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

String

Vendor Name

LAST_DOC_NUMBER

Document Number

Integer

Document Number

STD_HOURS

Standard Hours

String


FIRST_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_DATE

DateTime Stamp

Datetime

When Approver approved/rejected, if no action – it's 01/01/2100

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start

APP_READY_STATUS

Approval Group Status

String

Group Approval Action either Ready or Approved or Waiting