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