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
Note: * - source columns are from Data Lake