Employee
| Attribute name | Source column | Source table | 
|---|---|---|
| Employee History ID | EMPHIST_ID | EMPLOYEE_HISTORY | 
| Employee ID | EMP_ID | EMPLOYEE_HISTORY | 
| Shift Pattern ID | SHFTPAT_ID | EMPLOYEE_HISTORY | 
| Calc Group ID | CALCGRP_ID | EMPLOYEE_HISTORY | 
| Pay Group ID | PAYGRP_ID | EMPLOYEE_HISTORY | 
| Time Zone ID | TZ_ID | EMPLOYEE_HISTORY | 
| Employment Type ID | EMPTYP_ID | EMPLOYEE_HISTORY | 
| Employee Work Type ID | EMPWRKTYP_ID | EMPLOYEE_HISTORY | 
| Employee History Start Date | EMPHIST_START_DATE | EMPLOYEE_HISTORY | 
| Employee History End Date | EMPHIST_END_DATE | EMPLOYEE_HISTORY | 
| Employee Name | EMP_NAME | EMPLOYEE_HISTORY | 
| Employee Last Name | EMP_LASTNAME | EMPLOYEE_HISTORY | 
| Employee First Name | EMP_FIRSTNAME | EMPLOYEE_HISTORY | 
| Employee Day Start Time | EMP_DAY_START_TIME | EMPLOYEE_HISTORY | 
| Employee Base Rate | EMP_BASE_RATE | EMPLOYEE_HISTORY | 
| Employee Effective Date | EMP_EFFECTIVE_DATE | EMPLOYEE_HISTORY | 
| Employee Hire Date | EMP_HIRE_DATE | EMPLOYEE_HISTORY | 
| Employee Seniority Date | EMP_SENIORITY_DATE | EMPLOYEE_HISTORY | 
| Employee Birth Date | EMP_BIRTH_DATE | EMPLOYEE_HISTORY | 
| Employee Termination Date | EMP_TERMINATION_DATE | EMPLOYEE_HISTORY | 
| Employee Status | EMP_STATUS | EMPLOYEE_HISTORY | 
| Employee Shift Pattern Offset | EMP_SHFTPAT_OFFSET | EMPLOYEE_HISTORY | 
| Employee Flag1 | EMP_FLAG1 | EMPLOYEE_HISTORY | 
| Employee Flag2 | EMP_FLAG2 | EMPLOYEE_HISTORY | 
| Employee Flag3 | EMP_FLAG3 | EMPLOYEE_HISTORY | 
| Employee Flag4 | EMP_FLAG4 | EMPLOYEE_HISTORY | 
| Employee Flag5 | EMP_FLAG5 | EMPLOYEE_HISTORY | 
| Employee Flag6 | EMP_FLAG6 | EMPLOYEE_HISTORY | 
| Employee Flag7 | EMP_FLAG7 | EMPLOYEE_HISTORY | 
| Employee Flag8 | EMP_FLAG8 | EMPLOYEE_HISTORY | 
| Employee Flag9 | EMP_FLAG9 | EMPLOYEE_HISTORY | 
| Employee Flag10 | EMP_FLAG10 | EMPLOYEE_HISTORY | 
| Employee Flag11 | EMP_FLAG11 | EMPLOYEE_HISTORY | 
| Employee Flag12 | EMP_FLAG12 | EMPLOYEE_HISTORY | 
| Employee Flag13 | EMP_FLAG13 | EMPLOYEE_HISTORY | 
| Employee Flag14 | EMP_FLAG14 | EMPLOYEE_HISTORY | 
| Employee Flag15 | EMP_FLAG15 | EMPLOYEE_HISTORY | 
| Employee Flag16 | EMP_FLAG16 | EMPLOYEE_HISTORY | 
| Employee Flag17 | EMP_FLAG17 | EMPLOYEE_HISTORY | 
| Employee Flag18 | EMP_FLAG18 | EMPLOYEE_HISTORY | 
| Employee Flag19 | EMP_FLAG19 | EMPLOYEE_HISTORY | 
| Employee Flag20 | EMP_FLAG20 | EMPLOYEE_HISTORY | 
| Employee Val1 | EMP_VAL1 | EMPLOYEE_HISTORY | 
| Employee Val2 | EMP_VAL2 | EMPLOYEE_HISTORY | 
| Employee Val3 | EMP_VAL3 | EMPLOYEE_HISTORY | 
| Employee Val4 | EMP_VAL4 | EMPLOYEE_HISTORY | 
| Employee Val5 | EMP_VAL5 | EMPLOYEE_HISTORY | 
| Employee Val6 | EMP_VAL6 | EMPLOYEE_HISTORY | 
| Employee Val7 | EMP_VAL7 | EMPLOYEE_HISTORY | 
| Employee Val8 | EMP_VAL8 | EMPLOYEE_HISTORY | 
| Employee Val9 | EMP_VAL9 | EMPLOYEE_HISTORY | 
| Employee Val10 | EMP_VAL10 | EMPLOYEE_HISTORY | 
| Employee Val11 | EMP_VAL11 | EMPLOYEE_HISTORY | 
| Employee Val12 | EMP_VAL12 | EMPLOYEE_HISTORY | 
| Employee Val13 | EMP_VAL13 | EMPLOYEE_HISTORY | 
| Employee Val14 | EMP_VAL14 | EMPLOYEE_HISTORY | 
| Employee Val15 | EMP_VAL15 | EMPLOYEE_HISTORY | 
| Employee Val16 | EMP_VAL16 | EMPLOYEE_HISTORY | 
| Employee Val17 | EMP_VAL17 | EMPLOYEE_HISTORY | 
| Employee Val18 | EMP_VAL18 | EMPLOYEE_HISTORY | 
| Employee Val19 | EMP_VAL19 | EMPLOYEE_HISTORY | 
| Employee Val20 | EMP_VAL20 | EMPLOYEE_HISTORY | 
| Employee Default Minutes | EMP_DEF_MINUTES | EMPLOYEE_HISTORY | 
| Employee Availability | EMP_RETAIL_AVAIL | EMPLOYEE_HISTORY | 
| Employee Full Time | EMP_FULLTIME | EMPLOYEE_HISTORY | 
| Employee Full Name | EMP_FULLNAME | EMPLOYEE_HISTORY | 
| Employee Seniority Number | EMP_SENIORITY_NUMBER | EMPLOYEE_HISTORY | 
| Employee FTE | EMP_FTE | EMPLOYEE_HISTORY | 
| Employee System Scheduled Enabled | EMP_SYSTEM_SCHEDULING_ENABLED | EMPLOYEE_HISTORY | 
| Employee History UTC InsertDate | EMPHIST_UTC_INSERT_DATE | EMPLOYEE_HISTORY | 
| Employee History UTC UpdateDate | EMPHIST_UTC_UPDATE_DATE | EMPLOYEE_HISTORY | 
| Employee Pending | EMP_PENDING | EMPLOYEE_HISTORY | 
| Deleted | deleted* | EMPLOYEE_HISTORY | 
| Variation | variation* | EMPLOYEE_HISTORY | 
| Data Lake Time Stamp | lastModified* | EMPLOYEE_HISTORY | 
| Employee Job ID | EMPJOB_ID | EMPLOYEE_JOB | 
| Employee ID | EMP_ID | EMPLOYEE_JOB | 
| Job ID | JOB_ID | EMPLOYEE_JOB | 
| Employee Job Rate Index | EMPJOB_RATE_INDEX | EMPLOYEE_JOB | 
| Employee Job Start Date | EMPJOB_START_DATE | EMPLOYEE_JOB | 
| Employee Job End Date | EMPJOB_END_DATE | EMPLOYEE_JOB | 
| Employee Job Rank | EMPJOB_RANK | EMPLOYEE_JOB | 
| Employee Job Flag1 | EMPJOB_FLAG1 | EMPLOYEE_JOB | 
| Employee Job Flag2 | EMPJOB_FLAG2 | EMPLOYEE_JOB | 
| Employee Job Flag3 | EMPJOB_FLAG3 | EMPLOYEE_JOB | 
| Employee Job Flag4 | EMPJOB_FLAG4 | EMPLOYEE_JOB | 
| Employee Job Flag5 | EMPJOB_FLAG5 | EMPLOYEE_JOB | 
| Employee Job Udf1 | EMPJOB_UDF1 | EMPLOYEE_JOB | 
| Employee Job Udf2 | EMPJOB_UDF2 | EMPLOYEE_JOB | 
| Employee Job Udf3 | EMPJOB_UDF3 | EMPLOYEE_JOB | 
| Employee Job Udf4 | EMPJOB_UDF4 | EMPLOYEE_JOB | 
| Employee Job Udf5 | EMPJOB_UDF5 | EMPLOYEE_JOB | 
| Employee Job Preferred | EMPJOB_PREFERRED | EMPLOYEE_JOB | 
| Employee Job UTC Insert Date | EMPJOB_UTC_INSERT_DATE | EMPLOYEE_JOB | 
| Employee Job UTC Update Date | EMPJOB_UTC_UPDATE_DATE | EMPLOYEE_JOB | 
| Deleted | deleted* | EMPLOYEE_JOB | 
| Variation | variation* | EMPLOYEE_JOB | 
| Data Lake Time Stamp | lastModified* | EMPLOYEE_JOB | 
| Employee Work Type ID | EMPWRKTYP_ID | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Name | EMPWRKTYP_NAME | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Description | EMPWRKTYP_DESC | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Full Time | EMPWRKTYP_FULLTIME | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Flag1 | EMPWRKTYP_FLAG1 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Flag2 | EMPWRKTYP_FLAG2 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Flag3 | EMPWRKTYP_FLAG3 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Flag4 | EMPWRKTYP_FLAG4 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Flag5 | EMPWRKTYP_FLAG5 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Udf1 | EMPWRKTYP_UDF1 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Udf2 | EMPWRKTYP_UDF2 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Udf3 | EMPWRKTYP_UDF3 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Udf4 | EMPWRKTYP_UDF4 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Udf5 | EMPWRKTYP_UDF5 | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Sort Order | EMPWRKTYP_SORTORDER | EMPLOYEE_WORK_TYPE | 
| Employee Work Type Pay Type Code | EMPWRKTYP_PBJ_PAY_TYPE_CODE | EMPLOYEE_WORK_TYPE | 
| Employee Work Type UTC Insert Date | EMPWRKTYP_UTC_INSERT_DATE | EMPLOYEE_WORK_TYPE | 
| Employee Work Type UTC Update Date | EMPWRKTYP_UTC_UPDATE_DATE | EMPLOYEE_WORK_TYPE | 
| Deleted | deleted* | EMPLOYEE_WORK_TYPE | 
| Variation | variation* | EMPLOYEE_WORK_TYPE | 
| Data Lake Time Stamp | lastModified* | EMPLOYEE_WORK_TYPE | 
| Employment Type ID | EMPTYP_ID | EMPLOYMENT_TYPE | 
| Employment Type Name | EMPTYP_NAME | EMPLOYMENT_TYPE | 
| Employment Type Description | EMPTYP_DESC | EMPLOYMENT_TYPE | 
| Employment Type Flag1 | EMPTYP_FLAG1 | EMPLOYMENT_TYPE | 
| Employment Type Flag2 | EMPTYP_FLAG2 | EMPLOYMENT_TYPE | 
| Employment Type Flag3 | EMPTYP_FLAG3 | EMPLOYMENT_TYPE | 
| Employment Type Flag4 | EMPTYP_FLAG4 | EMPLOYMENT_TYPE | 
| Employment Type Flag5 | EMPTYP_FLAG5 | EMPLOYMENT_TYPE | 
| Employment Type Udf1 | EMPTYP_UDF1 | EMPLOYMENT_TYPE | 
| Employment Type Udf2 | EMPTYP_UDF2 | EMPLOYMENT_TYPE | 
| Employment Type Udf3 | EMPTYP_UDF3 | EMPLOYMENT_TYPE | 
| Employment Type Udf4 | EMPTYP_UDF4 | EMPLOYMENT_TYPE | 
| Employment Type Udf5 | EMPTYP_UDF5 | EMPLOYMENT_TYPE | 
| Employment Type Sortorder | EMPTYP_SORTORDER | EMPLOYMENT_TYPE | 
| Employment Type UTC Insert Date | EMPTYP_UTC_INSERT_DATE | EMPLOYMENT_TYPE | 
| Employment Type UTC Update Date | EMPTYP_UTC_UPDATE_DATE | EMPLOYMENT_TYPE | 
| Deleted | deleted* | EMPLOYMENT_TYPE | 
| Variation | variation* | EMPLOYMENT_TYPE | 
| Data Lake Time Stamp | lastModified* | EMPLOYMENT_TYPE | 
| Job ID | JOB_ID | Job | 
| Labor Metric Security ID | LMS_ID | Job | 
| Job Name | JOB_NAME | Job | 
| Job Description | JOB_DESC | Job | 
| Job Start Date | JOB_START_DATE | Job | 
| Job End Date | JOB_END_DATE | Job | 
| Job Flag1 | JOB_FLAG1 | Job | 
| Job Flag2 | JOB_FLAG2 | Job | 
| Job Flag3 | JOB_FLAG3 | Job | 
| Job Flag4 | JOB_FLAG4 | Job | 
| Job Flag5 | JOB_FLAG5 | Job | 
| Job Reference Key1 | JOB_REFKEY1 | Job | 
| Job Reference Key2 | JOB_REFKEY2 | Job | 
| Job Reference Key3 | JOB_REFKEY3 | Job | 
| Job Reference Key4 | JOB_REFKEY4 | Job | 
| Job Reference Key5 | JOB_REFKEY5 | Job | 
| Job Val1 | JOB_VAL1 | Job | 
| Job Val2 | JOB_VAL2 | Job | 
| Job Val3 | JOB_VAL3 | Job | 
| Job Val4 | JOB_VAL4 | Job | 
| Job Val5 | JOB_VAL5 | Job | 
| Job Val6 | JOB_VAL6 | Job | 
| Job Val7 | JOB_VAL7 | Job | 
| Job Val8 | JOB_VAL8 | Job | 
| Job Val9 | JOB_VAL9 | Job | 
| Job Val10 | JOB_VAL10 | Job | 
| Job Preference Key Holder | JOB_PREFKEYHOLDER | Job | 
| Job Shift Offset | JOB_SHIFT_OFFSET | Job | 
| Job Tip | JOB_TIP | Job | 
| Job Tip Calculation | JOB_TIP_CALCULATN | Job | 
| Job Inferred Tip | JOB_INFERRED_TIP | Job | 
| Job Unauthorized | JOB_UNAUTH | Job | 
| Job Exclude From Qualify | JOB_EXC_FRM_QLFY | Job | 
| Job Report Health Care Type | JOB_RPT_HCTYPE | Job | 
| Job Code | JOB_CODE | Job | 
| Job Title Code | JOB_PBJ_TITLE_CODE | Job | 
| Job UTC Insert Date | JOB_UTC_INSERT_DATE | Job | 
| Job UTC Update Date | JOB_UTC_UPDATE_DATE | Job | 
| Deleted | deleted* | Job | 
| Variation | variation* | Job | 
| Data Lake Time Stamp | lastModified* | Job | 
| Employee Schedule ID | EMPSKD_ID | EMPLOYEE_SCHEDULE | 
| Employee ID | EMP_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift ID | EMPSKD_ACT_SHIFT_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift Pattern ID | EMPSKD_ACT_SHFTPAT_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default Shift ID | EMPSKD_DEF_SHIFT_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule LTA ID | EMPSKD_LTA_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default Shift Pattern ID | EMPSKD_DEF_SHFTPAT_ID | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift ID2 | EMPSKD_ACT_SHIFT_ID2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift ID3 | EMPSKD_ACT_SHIFT_ID3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift ID4 | EMPSKD_ACT_SHIFT_ID4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Shift ID5 | EMPSKD_ACT_SHIFT_ID5 | EMPLOYEE_SCHEDULE | 
| Work Date | WORK_DATE | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act StartTime | EMPSKD_ACT_START_TIME | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act EndTime | EMPSKD_ACT_END_TIME | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default StartTime | EMPSKD_DEF_START_TIME | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default EndTime | EMPSKD_DEF_END_TIME | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default Base Rate | EMPSKD_DEF_BASE_RATE | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Base Rate | EMPSKD_ACT_BASE_RATE | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act Minutes | EMPSKD_ACT_MINUTES | EMPLOYEE_SCHEDULE | 
| Employee Schedule Default Minutes | EMPSKD_DEF_MINUTES | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act StartTime2 | EMPSKD_ACT_START_TIME2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act EndTime2 | EMPSKD_ACT_END_TIME2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act StartTime3 | EMPSKD_ACT_START_TIME3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act EndTime3 | EMPSKD_ACT_END_TIME3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act StartTime4 | EMPSKD_ACT_START_TIME4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act EndTime4 | EMPSKD_ACT_END_TIME4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act StartTime5 | EMPSKD_ACT_START_TIME5 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Act EndTime5 | EMPSKD_ACT_END_TIME5 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag1 | EMPSKD_FLAG1 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag2 | EMPSKD_FLAG2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag3 | EMPSKD_FLAG3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag4 | EMPSKD_FLAG4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag5 | EMPSKD_FLAG5 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag6 | EMPSKD_FLAG6 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag7 | EMPSKD_FLAG7 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag8 | EMPSKD_FLAG8 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag9 | EMPSKD_FLAG9 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Flag10 | EMPSKD_FLAG10 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf1 | EMPSKD_UDF1 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf2 | EMPSKD_UDF2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf3 | EMPSKD_UDF3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf4 | EMPSKD_UDF4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf5 | EMPSKD_UDF5 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf6 | EMPSKD_UDF6 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf7 | EMPSKD_UDF7 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf8 | EMPSKD_UDF8 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf9 | EMPSKD_UDF9 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Udf10 | EMPSKD_UDF10 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Breaks | EMPSKD_BRKS | EMPLOYEE_SCHEDULE | 
| Employee Schedule Breaks2 | EMPSKD_BRKS2 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Breaks3 | EMPSKD_BRKS3 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Breaks4 | EMPSKD_BRKS4 | EMPLOYEE_SCHEDULE | 
| Employee Schedule Breaks5 | EMPSKD_BRKS5 | EMPLOYEE_SCHEDULE | 
| Employee Schedule UTC Insert Date | EMPSKD_UTC_INSERT_DATE | EMPLOYEE_SCHEDULE | 
| Employee Schedule UTC Update Date | EMPSKD_UTC_UPDATE_DATE | EMPLOYEE_SCHEDULE | 
| Archived | archived* | EMPLOYEE_SCHEDULE | 
| Deleted | deleted* | EMPLOYEE_SCHEDULE | 
| Variation | variation* | EMPLOYEE_SCHEDULE | 
| Data Lake Time Stamp | lastModified* | EMPLOYEE_SCHEDULE | 
| Employee Schedule Detail ID | ESCHD_ID | EMPLOYEE_SCHED_DTL | 
| Employee Schedule ID | EMPSKD_ID | EMPLOYEE_SCHED_DTL | 
| Employee ID | EMP_ID | EMPLOYEE_SCHED_DTL | 
| Dock ID | DOCK_ID | EMPLOYEE_SCHED_DTL | 
| Hour Type ID | HTYPE_ID | EMPLOYEE_SCHED_DTL | 
| Job ID | JOB_ID | EMPLOYEE_SCHED_DTL | 
| Time Code ID | TCODE_ID | EMPLOYEE_SCHED_DTL | 
| Project ID | PROJ_ID | EMPLOYEE_SCHED_DTL | 
| Department ID | DEPT_ID | EMPLOYEE_SCHED_DTL | 
| Workbrain Team ID | WBT_ID | EMPLOYEE_SCHED_DTL | 
| ST Skill ID | STSKL_ID | EMPLOYEE_SCHED_DTL | 
| Act ID | ACT_ID | EMPLOYEE_SCHED_DTL | 
| JA ID | JA_ID | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Start Time | ESCHD_START_TIME | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail End Time | ESCHD_END_TIME | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Work Date | ESCHD_WORK_DATE | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Minutes | ESCHD_MINUTES | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Rate | ESCHD_RATE | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Quantity | ESCHD_QUANTITY | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Messages | ESCHD_MESSAGES | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Comments | ESCHD_COMMENTS | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Overridden | ESCHD_OVERRIDDEN | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag1 | ESCHD_FLAG1 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag2 | ESCHD_FLAG2 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag3 | ESCHD_FLAG3 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag4 | ESCHD_FLAG4 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag5 | ESCHD_FLAG5 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag6 | ESCHD_FLAG6 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag7 | ESCHD_FLAG7 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag8 | ESCHD_FLAG8 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag9 | ESCHD_FLAG8 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Flag10 | ESCHD_FLAG10 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf1 | ESCHD_UDF1 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf2 | ESCHD_UDF2 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf3 | ESCHD_UDF3 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf4 | ESCHD_UDF4 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf5 | ESCHD_UDF5 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf6 | ESCHD_UDF6 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf7 | ESCHD_UDF7 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf8 | ESCHD_UDF8 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf9 | ESCHD_UDF9 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Udf10 | ESCHD_UDF10 | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Status | ESCHD_STATUS | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Type | ESCHD_TYPE | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail Edited | ESCHD_SCHED_EDITED | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail JT StartTime | ESCHD_JT_START_TIME | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail JT EndTime | ESCHD_JT_END_TIME | EMPLOYEE_SCHED_DTL | 
| Module Reference | MODULE_REF | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail UTC Insert Date | ESCHD_UTC_INSERT_DATE | EMPLOYEE_SCHED_DTL | 
| Employee Schedule Detail UTC Update Date | ESCHD_UTC_UPDATE_DATE | EMPLOYEE_SCHED_DTL | 
| Archived | archived* | EMPLOYEE_SCHED_DTL | 
| Deleted | deleted* | EMPLOYEE_SCHED_DTL | 
| Variation | variation* | EMPLOYEE_SCHED_DTL | 
| Data Lake Time Stamp | lastModified* | EMPLOYEE_SCHED_DTL | 
          Note: * - source columns are from Data Lake