Time Missing Domain

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First Name

VENDOR_ID

Vendor ID

String

Vendor ID

VENDOR_NAME

Vendor Name

String

Vendor Name

FIRST_LAST

Full Name (Last, First)

String

Employee/User Last Name, First Name

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

EMPLY_TYPE_NAME

Employee Type

String

Employee Type Name

FULL_PART_TIME 
(FULL_PART)

Full/Part Time

String

Full or Part Time

HDR_WK_END

Period End

Date

Timesheet Period End

HDR_WK_START

Period Start

Date

Timesheet Period Start

STD_HOURS

Standard Hours

String

REPORTING_TYPE

Reporting Type

String

Reporting Type

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

DEPT_CODE 
(HOME_DEPT_CODE)

Home Department Code

String

Home Department Code

EMPLY_ID

Employee ID

String

Employee Id

FUNCTCODE 
(HOME_FUNC_CODE)

Home Function Code

String

Home Function Code

EMPLY_TYPE

Employee Type ID

String

Employee Type ID

OPT_CODE 
(HOME_OPT_CODE)

Home Operating Unit Code

String

Home Operating Unit Code

LOCATION_CODE 
(HOME_LOC_CODE)

Home Location Code

String

Home Location Code

EMP_TERM_DATE

Employee Termination Date

Date

Employee Termination Date

EMP_HIRE_DATE

Employee Hire Date

Date

Employee Start Date

EMP_TIME_ZONE

Employee Time Zone

String

Employee Time Zone

LANG_NAME

Language

String

Language