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 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 Department Code | String | Home Department Code |
EMPLY_ID | Employee ID | String | Employee Id |
EMPLY_TYPE | Employee Type Code | String | Employee Type ID |
FUNCTCODE | Home Function Code | String | Home Function Code |
LOCATION_CODE | Home Location Code | String | Home Location Code |
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