Time Missing Domain

Use this domain to create a missing timesheet report. 

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

LAST_FIRST

Full Name (Last, First)

String

Employee/User Last Name, First 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

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

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

EMP_HIRE_DATE

Employee Hire Date

Date

Employee Start Date

EMP_TERM_DATE

Employee Termination Date

Date

Employee Termination Date

2024 DATABASICS, Inc