Timesheet
| Attribute name | Source column | Source table |
|---|---|---|
| Calculation Group ID | CALCGRP_ID | CALC_GROUP |
| Calculation Group Name | CALCGRP_NAME | CALC_GROUP |
| Calculation Group Description | CALCGRP_DESC | CALC_GROUP |
| Calculation Group Flag1 | CALCGRP_FLAG1 | CALC_GROUP |
| Calculation Group Flag2 | CALCGRP_FLAG2 | CALC_GROUP |
| Calculation Group Flag3 | CALCGRP_FLAG3 | CALC_GROUP |
| Calculation Group Flag4 | CALCGRP_FLAG4 | CALC_GROUP |
| Calculation Group Flag5 | CALCGRP_FLAG5 | CALC_GROUP |
| Calculation Group Flag6 | CALCGRP_FLAG6 | CALC_GROUP |
| Calculation Group Flag7 | CALCGRP_FLAG7 | CALC_GROUP |
| Calculation Group Flag8 | CALCGRP_FLAG8 | CALC_GROUP |
| Calculation Group Flag9 | CALCGRP_FLAG9 | CALC_GROUP |
| Calculation Group Flag10 | CALCGRP_FLAG10 | CALC_GROUP |
| Calculation Group Udf1 | CALCGRP_UDF1 | CALC_GROUP |
| Calculation Group Udf2 | CALCGRP_UDF2 | CALC_GROUP |
| Calculation Group Udf3 | CALCGRP_UDF3 | CALC_GROUP |
| Calculation Group Udf4 | CALCGRP_UDF4 | CALC_GROUP |
| Calculation Group Udf5 | CALCGRP_UDF5 | CALC_GROUP |
| Calculation Group Udf6 | CALCGRP_UDF6 | CALC_GROUP |
| Calculation Group Udf7 | CALCGRP_UDF7 | CALC_GROUP |
| Calculation Group Udf8 | CALCGRP_UDF8 | CALC_GROUP |
| Calculation Group Udf9 | CALCGRP_UDF9 | CALC_GROUP |
| Calculation Group Udf10 | CALCGRP_UDF10 | CALC_GROUP |
| Calculation Group UTC Insert Date | CALCGRP_UTC_INSERT_DATE | CALC_GROUP |
| Calculation Group UTC Update Date | CALCGRP_UTC_UPDATE_DATE | CALC_GROUP |
| Meal Confirm Required | CALCGRP_MEAL_CONFIRM_REQUIRED | CALC_GROUP |
| Deleted | deleted* | CALC_GROUP |
| Variation | variation* | CALC_GROUP |
| Data Lake Time Stamp | lastModified* | CALC_GROUP |
| Hour Type ID | HTYPE_ID | HOUR_TYPE |
| Labor Metric Security ID | LMS_ID | HOUR_TYPE |
| Hour Type Name | HTYPE_NAME | HOUR_TYPE |
| Hour Type Multiple | HTYPE_MULTIPLE | HOUR_TYPE |
| Hour Type Description | HTYPE_DESC | HOUR_TYPE |
| Hour Type Unauthorized | HTYPE_UNAUTHORIZE | HOUR_TYPE |
| Hour Type Flag1 | HTYPE_FLAG1 | HOUR_TYPE |
| Hour Type Flag2 | HTYPE_FLAG2 | HOUR_TYPE |
| Hour Type Flag3 | HTYPE_FLAG3 | HOUR_TYPE |
| Hour Type Flag4 | HTYPE_FLAG4 | HOUR_TYPE |
| Hour Type Flag5 | HTYPE_FLAG5 | HOUR_TYPE |
| Hour Type Udf1 | HTYPE_UDF1 | HOUR_TYPE |
| Hour Type Udf2 | HTYPE_UDF2 | HOUR_TYPE |
| Hour Type Udf3 | HTYPE_UDF3 | HOUR_TYPE |
| Hour Type Udf4 | HTYPE_UDF4 | HOUR_TYPE |
| Hour Type Udf5 | HTYPE_UDF5 | HOUR_TYPE |
| Hour Type Sort Order | HTYPE_SORTORDER | HOUR_TYPE |
| Hour Type Year At Glance | HTYPE_YAG | HOUR_TYPE |
| Hour Type Summarize | HTYPE_SUMMARIZE | HOUR_TYPE |
| Hour Type Is OT | HTYPE_RPT_ISOT | HOUR_TYPE |
| Hour Type UTC Insert Date | HTYPE_UTC_INSERT_DATE | HOUR_TYPE |
| Hour Type UTC Update Date | HTYPE_UTC_UPDATE_DATE | HOUR_TYPE |
| Deleted | deleted* | HOUR_TYPE |
| Variation | variation* | HOUR_TYPE |
| Data Lake Time Stamp | lastModified* | HOUR_TYPE |
| Override ID | OVR_ID | OVERRIDE |
| Override Type ID | OVRTYP_ID | OVERRIDE |
| Employee ID | EMP_ID | OVERRIDE |
| Override Create Date | OVR_CREATE_DATE | OVERRIDE |
| Override Start Date | OVR_START_DATE | OVERRIDE |
| Override End Date | OVR_END_DATE | OVERRIDE |
| Override Start Time | OVR_START_TIME | OVERRIDE |
| Override End Time | OVR_END_TIME | OVERRIDE |
| Override Old Value | OVR_OLD_VALUE | OVERRIDE |
| Override New Value | OVR_NEW_VALUE | OVERRIDE |
| Override Status | OVR_STATUS | OVERRIDE |
| Override Comment | OVR_COMMENT | OVERRIDE |
| Override Message | OVR_MESSAGE | OVERRIDE |
| Workbrain User Name | WBU_NAME | OVERRIDE |
| Override Flag1 | OVR_FLAG1 | OVERRIDE |
| Override Flag2 | OVR_FLAG2 | OVERRIDE |
| Override Flag3 | OVR_FLAG3 | OVERRIDE |
| Override Flag4 | OVR_FLAG4 | OVERRIDE |
| Override Flag5 | OVR_FLAG5 | OVERRIDE |
| Override Flag6 | OVR_FLAG6 | OVERRIDE |
| Override Flag7 | OVR_FLAG7 | OVERRIDE |
| Override Flag8 | OVR_FLAG8 | OVERRIDE |
| Override Flag9 | OVR_FLAG9 | OVERRIDE |
| Override Flag10 | OVR_FLAG10 | OVERRIDE |
| Override Udf1 | OVR_UDF1 | OVERRIDE |
| Override Udf2 | OVR_UDF2 | OVERRIDE |
| Override Udf3 | OVR_UDF3 | OVERRIDE |
| Override Udf4 | OVR_UDF4 | OVERRIDE |
| Override Udf5 | OVR_UDF5 | OVERRIDE |
| Override Udf6 | OVR_UDF6 | OVERRIDE |
| Override Udf7 | OVR_UDF7 | OVERRIDE |
| Override Udf8 | OVR_UDF8 | OVERRIDE |
| Override Udf9 | OVR_UDF9 | OVERRIDE |
| Override Udf10 | OVR_UDF10 | OVERRIDE |
| Override Order | OVR_ORDER | OVERRIDE |
| Override Cancelled Date | OVR_CANCELLED_DATE | OVERRIDE |
| Workbrain User Name Actual | WBU_NAME_ACTUAL | OVERRIDE |
| Override CancelledBy | OVR_CANCELLED_BY | OVERRIDE |
| Override CancelledByA | OVR_CANCELLED_BY_A | OVERRIDE |
| Override UTC Insert Date | OVR_UTC_INSERT_DATE | OVERRIDE |
| Override UTC Update Date | OVR_UTC_UPDATE_DATE | OVERRIDE |
| Archived | archived* | OVERRIDE |
| Deleted | deleted* | OVERRIDE |
| Variation | variation* | OVERRIDE |
| Data Lake Time Stamp | lastModified* | OVERRIDE |
| Override Type ID | OVRTYP_ID | OVERRIDE_TYPE |
| Override Type Name | OVRTYP_NAME | OVERRIDE_TYPE |
| Override Type Description | OVRTYP_DESC | OVERRIDE_TYPE |
| Override Type Order | OVRTYP_ORDER | OVERRIDE_TYPE |
| Override Type Active | OVRTYP_ACTIVE | OVERRIDE_TYPE |
| Override Type Show | OVRTYP_SHOW | OVERRIDE_TYPE |
| Override Type Prefix | OVRTYP_PREFIX | OVERRIDE_TYPE |
| Override Type Employee | OVRTYP_EMPLOYEE | OVERRIDE_TYPE |
| Override Type Schedule | OVRTYP_SCHEDULE | OVERRIDE_TYPE |
| Override Type Timesheet | OVRTYP_TIMESHEET | OVERRIDE_TYPE |
| Override Type Link | OVRTYP_LINK | OVERRIDE_TYPE |
| Override Type Flag1 | OVRTYP_FLAG1 | OVERRIDE_TYPE |
| Override Type Flag2 | OVRTYP_FLAG2 | OVERRIDE_TYPE |
| Override Type Flag3 | OVRTYP_FLAG3 | OVERRIDE_TYPE |
| Override Type Flag4 | OVRTYP_FLAG4 | OVERRIDE_TYPE |
| Override Type Flag5 | OVRTYP_FLAG5 | OVERRIDE_TYPE |
| Override Type Udf1 | OVRTYP_UDF1 | OVERRIDE_TYPE |
| Override Type Udf2 | OVRTYP_UDF2 | OVERRIDE_TYPE |
| Override Type Udf3 | OVRTYP_UDF3 | OVERRIDE_TYPE |
| Override Type Udf4 | OVRTYP_UDF4 | OVERRIDE_TYPE |
| Override Type Udf5 | OVRTYP_UDF5 | OVERRIDE_TYPE |
| Override Type Wktimesheet | OVRTYP_WKTIMESHEET | OVERRIDE_TYPE |
| Override Type Lang1 | OVRTYP_LANG1 | OVERRIDE_TYPE |
| Override Type Lang2 | OVRTYP_LANG2 | OVERRIDE_TYPE |
| Override Type Lang3 | OVRTYP_LANG3 | OVERRIDE_TYPE |
| Override Type Lang4 | OVRTYP_LANG4 | OVERRIDE_TYPE |
| Override Type Lang5 | OVRTYP_LANG5 | OVERRIDE_TYPE |
| Override Type Max Duration | .OVRTYP_MAX_DURATN | OVERRIDE_TYPE |
| Override Type Mass Entry | OVRTYP_MASSENTRY | OVERRIDE_TYPE |
| Override Type UTC Insert Date | OVRTYP_UTC_INSERT_DATE | OVERRIDE_TYPE |
| Override Type UTC Update Date | OVRTYP_UTC_UPDATE_DATE | OVERRIDE_TYPE |
| Deleted | deleted* | OVERRIDE_TYPE |
| Variation | variation* | OVERRIDE_TYPE |
| Data Lake Time Stamp | lastModified* | OVERRIDE_TYPE |
| Pay Group ID | PAYGRP_ID | PAY_GROUP |
| Pay Group Type ID | PAYGRPTYP_ID | PAY_GROUP |
| Payroll System ID | PAYSYS_ID | PAY_GROUP |
| Pay Group Calender ID | PGC_ID | PAY_GROUP |
| Payroll Export Type ID | PET_ID | PAY_GROUP |
| Payroll Export Unauth Type ID | PREUT_ID | PAY_GROUP |
| Pay Group Name | PAYGRP_NAME | PAY_GROUP |
| Pay Group Description | PAYGRP_DESC | PAY_GROUP |
| Pay Group Start Date | PAYGRP_START_DATE | PAY_GROUP |
| Pay Group End Date | PAYGRP_END_DATE | PAY_GROUP |
| Pay Group Adjust Date | PAYGRP_ADJUST_DATE | PAY_GROUP |
| Pay Group Supervisor Date | PAYGRP_SUPERVISOR_DATE | PAY_GROUP |
| Pay Group HandsOff Date | PAYGRP_HANDS_OFF_DATE | PAY_GROUP |
| Pay Group Year First Date | PAYGRP_YEAR_FIRST_DATE | PAY_GROUP |
| Pay Group Day Start Time | PAYGRP_DAY_START_TIME | PAY_GROUP |
| Pay Group Udf1 | PAYGRP_UDF1 | PAY_GROUP |
| Pay Group Udf2 | PAYGRP_UDF2 | PAY_GROUP |
| Pay Group Udf3 | PAYGRP_UDF3 | PAY_GROUP |
| Pay Group Udf4 | PAYGRP_UDF4 | PAY_GROUP |
| Pay Group Udf5 | PAYGRP_UDF5 | PAY_GROUP |
| Pay Group Udf6 | PAYGRP_UDF6 | PAY_GROUP |
| Pay Group Udf7 | PAYGRP_UDF7 | PAY_GROUP |
| Pay Group Udf8 | PAYGRP_UDF8 | PAY_GROUP |
| Pay Group Udf9 | PAYGRP_UDF9 | PAY_GROUP |
| Pay Group Udf10 | PAYGRP_UDF10 | PAY_GROUP |
| Pay Group Flag1 | PAYGRP_FLAG1 | PAY_GROUP |
| Pay Group Flag2 | PAYGRP_FLAG2 | PAY_GROUP |
| Pay Group Flag3 | PAYGRP_FLAG3 | PAY_GROUP |
| Pay Group Flag4 | PAYGRP_FLAG4 | PAY_GROUP |
| Pay Group Flag5 | PAYGRP_FLAG5 | PAY_GROUP |
| Pay Group Flag6 | PAYGRP_FLAG6 | PAY_GROUP |
| Pay Group Flag7 | PAYGRP_FLAG7 | PAY_GROUP |
| Pay Group Flag8 | PAYGRP_FLAG8 | PAY_GROUP |
| Pay Group Flag9 | PAYGRP_FLAG9 | PAY_GROUP |
| Pay Group Flag10 | PAYGRP_FLAG10 | PAY_GROUP |
| Pay Group Date1 | PAYGRP_DATE1 | PAY_GROUP |
| Pay Group Date2 | PAYGRP_DATE2 | PAY_GROUP |
| Pay Group Date3 | PAYGRP_DATE3 | PAY_GROUP |
| Pay Group Date4 | PAYGRP_DATE4 | PAY_GROUP |
| Pay Group Date5 | PAYGRP_DATE5 | PAY_GROUP |
| Pay Group Offset | PAYGRP_OFFSET | PAY_GROUP |
| Pay Group Adjust Flag | PAYGRP_ADJUST_FLAG | PAY_GROUP |
| Pay Group Timesheet Lockout Date | PAYGRP_TS_LOCKOUT_DATE | PAY_GROUP |
| Pay Group Timesheet Lockout Offset | PAYGRP_TS_LOCKOUT_OFFSET | PAY_GROUP |
| Pay Group Lockdown Offset | PAYGRP_LOCKDOWN_OFFSET | PAY_GROUP |
| Pay Group Roll Lockdown Flag | PAYGRP_ROLL_LOCKDOWN_FLAG | PAY_GROUP |
| Pay Group Roll Lockout Flag | PAYGRP_ROLL_LOCKOUT_FLAG | PAY_GROUP |
| Pay Group Roll Handsoff Flag | PAYGRP_ROLL_HANDSOFF_FLAG | PAY_GROUP |
| Pay Group Future Window | PAYGRP_FUTURE_WINDOW | PAY_GROUP |
| Pay Group Timesheet Lockout Time | PAYGRP_TS_LOCKOUT_TIME | PAY_GROUP |
| Pay Group UTC Insert Date | PAYGRP_UTC_INSERT_DATE | PAY_GROUP |
| Pay Group UTC Update Date | PAYGRP_UTC_UPDATE_DATE | PAY_GROUP |
| Deleted | deleted* | PAY_GROUP |
| Variation | variation* | PAY_GROUP |
| Data Lake Time Stamp | lastModified* | PAY_GROUP |
| Pay Period ID | PAYPD_ID | PAY_PERIOD |
| Pay Group ID | PAYGRP_ID | PAY_PERIOD |
| Pay Period Start | PAYPD_START | PAY_PERIOD |
| Pay Period End | PAYPD_END | PAY_PERIOD |
| Pay Period Lockdown | PAYPD_LOCKDOWN | PAY_PERIOD |
| Pay Period TsLockout | PAYPD_TS_LOCKOUT | PAY_PERIOD |
| Pay Period Export Started | PAYPD_EXPORT_STARTED | PAY_PERIOD |
| Pay Period Export Status | PAYPD_EXPORT_STATUS | PAY_PERIOD |
| Pay Period Udf1 | PAYPD_UDF1 | PAY_PERIOD |
| Pay Period Udf2 | PAYPD_UDF2 | PAY_PERIOD |
| Pay Period Udf3 | PAYPD_UDF3 | PAY_PERIOD |
| Pay Period Udf4 | PAYPD_UDF4 | PAY_PERIOD |
| Pay Period Udf5 | PAYPD_UDF5 | PAY_PERIOD |
| Pay Period Flag1 | PAYPD_FLAG1 | PAY_PERIOD |
| Pay Period Flag2 | PAYPD_FLAG2 | PAY_PERIOD |
| Pay Period Flag3 | PAYPD_FLAG3 | PAY_PERIOD |
| Pay Period Flag4 | PAYPD_FLAG4 | PAY_PERIOD |
| Pay Period Flag5 | PAYPD_FLAG5 | PAY_PERIOD |
| Pay Period Date1 | PAYPD_DATE1 | PAY_PERIOD |
| Pay Period Date2 | PAYPD_DATE2 | PAY_PERIOD |
| Pay Period Date3 | PAYPD_DATE3 | PAY_PERIOD |
| Pay Period Date4 | PAYPD_DATE4 | PAY_PERIOD |
| Pay Period Date5 | PAYPD_DATE5 | PAY_PERIOD |
| Pay Period UTC Insert Date | PAYPD_UTC_INSERT_DATE | PAY_PERIOD |
| Pay Period UTC Update Date | PAYPD_UTC_UPDATE_DATE | PAY_PERIOD |
| Deleted | deleted* | PAY_PERIOD |
| Variation | variation* | PAY_PERIOD |
| Data Lake Time Stamp | lastModified* | PAY_PERIOD |
| Time Code ID | TCODE_ID | TIME_CODE |
| Color ID | COLR_ID | TIME_CODE |
| Hour Type ID | HTYPE_ID | TIME_CODE |
| Labor Metric Security ID | LMS_ID | TIME_CODE |
| Time Code Name | TCODE_NAME | TIME_CODE |
| Time Code Description | TCODE_DESC | TIME_CODE |
| Time Code Default Hours | TCODE_DEF_HOURS | TIME_CODE |
| Time Code Day of Week | TCODE_DOW | TIME_CODE |
| Time Code Only When Scheduled | TCODE_OWS | TIME_CODE |
| Time Code Unauthorize | TCODE_UNAUTHORIZE | TIME_CODE |
| Time Code Flag1 | TCODE_FLAG1 | TIME_CODE |
| Time Code Flag2 | TCODE_FLAG2 | TIME_CODE |
| Time Code Flag3 | TCODE_FLAG3 | TIME_CODE |
| Time Code Flag4 | TCODE_FLAG4 | TIME_CODE |
| Time Code Flag5 | TCODE_FLAG5 | TIME_CODE |
| Time Code Flag6 | TCODE_FLAG6 | TIME_CODE |
| Time Code Flag7 | TCODE_FLAG7 | TIME_CODE |
| Time Code Flag8 | TCODE_FLAG8 | TIME_CODE |
| Time Code Flag9 | TCODE_FLAG9 | TIME_CODE |
| Time Code Flag10 | TCODE_FLAG10 | TIME_CODE |
| Time Code Sort Order | TCODE_SORTORDER | TIME_CODE |
| Time Code Year At Glance | TCODE_YAG | TIME_CODE |
| Time Code Affects Balances | TCODE_AFFECTS_BALANCES | TIME_CODE |
| Time Code Irregular | TCODE_IRREGULAR | TIME_CODE |
| Time Code Default Rate | TCODE_DEFAULT_RATE | TIME_CODE |
| Time Code Summarize | TCODE_SUMMARIZE | TIME_CODE |
| Time Code Etm Work Detail Hide | TCODE_ETM_WD_HIDE | TIME_CODE |
| Time Code Is Long-term Absence | TCODE_IS_LTA | TIME_CODE |
| Time Code Udf1 | TCODE_UDF1 | TIME_CODE |
| Time Code Udf2 | TCODE_UDF2 | TIME_CODE |
| Time Code Udf3 | TCODE_UDF3 | TIME_CODE |
| Time Code Udf4 | TCODE_UDF4 | TIME_CODE |
| Time Code Udf5 | TCODE_UDF5 | TIME_CODE |
| Time Code Udf6 | TCODE_UDF6 | TIME_CODE |
| Time Code Udf7 | TCODE_UDF7 | TIME_CODE |
| Time Code Udf8 | TCODE_UDF8 | TIME_CODE |
| Time Code Udf9 | TCODE_UDF9 | TIME_CODE |
| Time Code Udf10 | TCODE_UDF10 | TIME_CODE |
| Time Code Report Is Productive | TCODE_RPT_ISPRDCTV | TIME_CODE |
| Time Code Is Excluded Totals | TCODE_IS_EXCLD_TTL | TIME_CODE |
| Time Code Is Break | TCODE_IS_BRK | TIME_CODE |
| Time Code Qualify FTE | TCODE_QUALIFY_FTE | TIME_CODE |
| Time Code UTC Insert Date | TCODE_UTC_INSERT_DATE | TIME_CODE |
| Time Code UTC Update Date | TCODE_UTC_UPDATE_DATE | TIME_CODE |
| Deleted | deleted* | TIME_CODE |
| Variation | variation* | TIME_CODE |
| Data Lake Time Stamp | lastModified* | TIME_CODE |
| Workbrain Team ID | WBT_ID | WORKBRAIN_TEAM |
| Workbrain Team Type ID | WBTT_ID | WORKBRAIN_TEAM |
| Workbrain Team Parent ID | WBT_PARENT_ID | WORKBRAIN_TEAM |
| Hours Of Operation ID | HRSOP_ID | WORKBRAIN_TEAM |
| Workbrain Team Name | WBT_NAME | WORKBRAIN_TEAM |
| Workbrain Team Description | WBT_DESC | WORKBRAIN_TEAM |
| Workbrain Team Flag1 | WBT_FLAG1 | WORKBRAIN_TEAM |
| Workbrain Team Flag2 | WBT_FLAG2 | WORKBRAIN_TEAM |
| Workbrain Team Flag3 | WBT_FLAG3 | WORKBRAIN_TEAM |
| Workbrain Team Flag4 | WBT_FLAG4 | WORKBRAIN_TEAM |
| Workbrain Team Flag5 | WBT_FLAG5 | WORKBRAIN_TEAM |
| Workbrain Team Udf1 | WBT_UDF1 | WORKBRAIN_TEAM |
| Workbrain Team Udf2 | WBT_UDF2 | WORKBRAIN_TEAM |
| Workbrain Team Udf3 | WBT_UDF3 | WORKBRAIN_TEAM |
| Workbrain Team Udf4 | WBT_UDF4 | WORKBRAIN_TEAM |
| Workbrain Team Udf5 | WBT_UDF5 | WORKBRAIN_TEAM |
| Workbrain Team Left | WBT_LFT | WORKBRAIN_TEAM |
| Workbrain Team Right | WBT_RGT | WORKBRAIN_TEAM |
| Workbrain Team Level | WBT_LEVEL | WORKBRAIN_TEAM |
| Workbrain Team Code | WBT_CODE | WORKBRAIN_TEAM |
| Workbrain Team Label | WBT_LABEL | WORKBRAIN_TEAM |
| Workbrain Team UTC Insert Date | WBT_UTC_INSERT_DATE | WORKBRAIN_TEAM |
| Workbrain Team UTC Update Date | WBT_UTC_UPDATE_DATE | WORKBRAIN_TEAM |
| Deleted | deleted* | WORKBRAIN_TEAM |
| Variation | variation* | WORKBRAIN_TEAM |
| Data Lake Time Stamp | lastModified* | WORKBRAIN_TEAM |
| Employee Team ID | EMPT_ID | EMPLOYEE_TEAM |
| Employee ID | EMP_ID | EMPLOYEE_TEAM |
| Workbrain Team ID | WBT_ID | EMPLOYEE_TEAM |
| Employee Team StartDate | EMPT_START_DATE | EMPLOYEE_TEAM |
| Employee Team EndDate | EMPT_END_DATE | EMPLOYEE_TEAM |
| Employee Team Home Team | EMPT_HOME_TEAM | EMPLOYEE_TEAM |
| Employee Team Flag1 | EMPT_FLAG1 | EMPLOYEE_TEAM |
| Employee Team Flag2 | EMPT_FLAG2 | EMPLOYEE_TEAM |
| Employee Team Flag3 | EMPT_FLAG3 | EMPLOYEE_TEAM |
| Employee Team Flag4 | EMPT_FLAG4 | EMPLOYEE_TEAM |
| Employee Team Flag5 | EMPT_FLAG5 | EMPLOYEE_TEAM |
| Employee Team Udf1 | EMPT_UDF1 | EMPLOYEE_TEAM |
| Employee Team Udf2 | EMPT_UDF2 | EMPLOYEE_TEAM |
| Employee Team Udf3 | EMPT_UDF3 | EMPLOYEE_TEAM |
| Employee Team Udf4 | EMPT_UDF4 | EMPLOYEE_TEAM |
| Employee Team Udf5 | EMPT_UDF5 | EMPLOYEE_TEAM |
| Employee Team Sysgenerated | EMPT_SYSGENERATED | EMPLOYEE_TEAM |
| Employee Team UTC InsertDate | EMPT_UTC_INSERT_DATE | EMPLOYEE_TEAM |
| Employee Team UTC UpdateDate | EMPT_UTC_UPDATE_DATE | EMPLOYEE_TEAM |
| Archived | archived* | EMPLOYEE_TEAM |
| Deleted | deleted* | EMPLOYEE_TEAM |
| Variation | variation* | EMPLOYEE_TEAM |
| Data Lake Time Stamp | lastModified* | EMPLOYEE_TEAM |
| Work Detail Adjust ID | WRKDA_ID | WORK_DETAIL_ADJUST |
| Employee ID | EMP_ID | WORK_DETAIL_ADJUST |
| Docket ID | DOCK_ID | WORK_DETAIL_ADJUST |
| Hour Type ID | HTYPE_ID | WORK_DETAIL_ADJUST |
| Job ID | JOB_ID | WORK_DETAIL_ADJUST |
| Time Code ID | TCODE_ID | WORK_DETAIL_ADJUST |
| Project ID | PROJ_ID | WORK_DETAIL_ADJUST |
| Pay Group ID | PAYGRP_ID | WORK_DETAIL_ADJUST |
| Shift ID | SHFT_ID | WORK_DETAIL_ADJUST |
| Calc Group ID | CALCGRP_ID | WORK_DETAIL_ADJUST |
| Department ID | DEPT_ID | WORK_DETAIL_ADJUST |
| Workbrain Team ID | WBT_ID | WORK_DETAIL_ADJUST |
| Work Detail Adjust Payroll Export Type ID | PETYP_ID | WORK_DETAIL_ADJUST |
| Work Detail ID | WRKDA_WRKD_ID | WORK_DETAIL_ADJUST |
| Work Detail Adjust Bad Quantity Reason Code ID | WRKDA_BAD_QTY_RSNCD_ID | WORK_DETAIL_ADJUST |
| Work Detail Adjust Adjust Date | WRKDA_ADJUST_DATE | WORK_DETAIL_ADJUST |
| Work Detail Adjust Start Time | WRKDA_START_TIME | WORK_DETAIL_ADJUST |
| Work Detail Adjust End Time | WRKDA_END_TIME | WORK_DETAIL_ADJUST |
| Work Detail Adjust Minutes | WRKDA_MINUTES | WORK_DETAIL_ADJUST |
| Work Detail Adjust Rate | WRKDA_RATE | WORK_DETAIL_ADJUST |
| Work Detail Adjust Work Date | WRKDA_WORK_DATE | WORK_DETAIL_ADJUST |
| Work Detail Adjust Quantity | WRKDA_QUANTITY | WORK_DETAIL_ADJUST |
| Work Detail Adjust Type | WRKDA_TYPE | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag1 | WRKDA_FLAG1 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag2 | WRKDA_FLAG2 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag3 | WRKDA_FLAG3 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag4 | WRKDA_FLAG4 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag5 | WRKDA_FLAG5 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf1 | WRKDA_UDF1 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf2 | WRKDA_UDF2 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf3 | WRKDA_UDF3 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf4 | WRKDA_UDF4 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf5 | WRKDA_UDF5 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Start Time | WRKSA_START_TIME | WORK_DETAIL_ADJUST |
| Work Summary Adjust End Time | WRKSA_END_TIME | WORK_DETAIL_ADJUST |
| Work Summary Adjust Manual Calculation | WRKSA_MANUAL_CALC | WORK_DETAIL_ADJUST |
| Work Summary Adjust Authorized | WRKSA_AUTHORIZED | WORK_DETAIL_ADJUST |
| Work Summary Adjust Authorized By | WRKSA_AUTH_BY | WORK_DETAIL_ADJUST |
| Work Summary Adjust Authorized Date | WRKSA_AUTH_DATE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag Break | WRKSA_FLAG_BRK | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag Recall | WRKSA_FLAG_RECALL | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag1 | WRKSA_FLAG1 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag2 | WRKSA_FLAG2 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag3 | WRKSA_FLAG3 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag4 | WRKSA_FLAG4 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Flag5 | WRKSA_FLAG5 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf1 | WRKSA_UDF1 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf2 | WRKSA_UDF2 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf3 | WRKSA_UDF3 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf4 | WRKSA_UDF4 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf5 | WRKSA_UDF5 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf6 | WRKSA_UDF6 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf7 | WRKSA_UDF7 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf8 | WRKSA_UDF8 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf9 | WRKSA_UDF9 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Udf10 | WRKSA_UDF10 | WORK_DETAIL_ADJUST |
| Work Summary Adjust Description | WRKSA_DESC | WORK_DETAIL_ADJUST |
| Work Summary Adjust Clocks | WRKSA_CLOCKS | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag6 | WRKDA_FLAG6 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag7 | WRKDA_FLAG7 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag8 | WRKDA_FLAG8 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag9 | WRKDA_FLAG9 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Flag10 | WRKDA_FLAG10 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf6 | WRKDA_UDF6 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf7 | WRKDA_UDF7 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf8 | WRKDA_UDF8 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf9 | WRKDA_UDF9 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Udf10 | WRKDA_UDF10 | WORK_DETAIL_ADJUST |
| Work Detail Adjust Messages | WRKDA_MESSAGES | WORK_DETAIL_ADJUST |
| Work Detail Adjust Comments | WRKDA_COMMENTS | WORK_DETAIL_ADJUST |
| Work Detail Adjust Overridden | WRKDA_OVERRIDDEN | WORK_DETAIL_ADJUST |
| Work Summary Adjust Work Date | WRKSA_WORK_DATE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Comments | WRKSA_COMMENTS | WORK_DETAIL_ADJUST |
| Work Summary Adjust Error | WRKSA_ERROR | WORK_DETAIL_ADJUST |
| Work Summary Adjust Error Status | WRKSA_ERROR_STATUS | WORK_DETAIL_ADJUST |
| Work Summary Adjust Rules Applied | WRKSA_RULES_APPLIED | WORK_DETAIL_ADJUST |
| Work Summary Adjust Time Code Summary | WRKSA_TCODE_SUM | WORK_DETAIL_ADJUST |
| Work Summary Adjust Hour Type Summary | WRKSA_HTYPE_SUM | WORK_DETAIL_ADJUST |
| Work Summary Adjust Original Clocks | WRKSA_ORIG_CLOCKS | WORK_DETAIL_ADJUST |
| Work Summary Adjust Messages | WRKSA_MESSAGES | WORK_DETAIL_ADJUST |
| Work Summary Adjust In Code | WRKSA_IN_CODE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Out Code | WRKSA_OUT_CODE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Full Day Code | WRKSA_FULL_DAY_CODE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Full Day Minutes | WRKSA_FULL_DAY_MINUTES | WORK_DETAIL_ADJUST |
| Work Summary Adjust Submitted | WRKSA_SUBMITTED | WORK_DETAIL_ADJUST |
| Work Summary Adjust Use Default Settings | WRKSA_USE_DEF_SETTINGS | WORK_DETAIL_ADJUST |
| Work Detail Adjust Authorized | WRKDA_AUTH | WORK_DETAIL_ADJUST |
| Work Detail Adjust Authorized By | WRKDA_AUTH_BY | WORK_DETAIL_ADJUST |
| Work Detail Adjust Authorized Date | WRKDA_AUTH_DATE | WORK_DETAIL_ADJUST |
| Work Summary Adjust Work Detail Authorized | WRKSA_WRKD_AUTH | WORK_DETAIL_ADJUST |
| Work Detail Previous Update | WRKDA_WRKD_PREV_UPDATE | WORK_DETAIL_ADJUST |
| Work Detail Adjust Bad Quantity | WRKDA_BAD_QUANTITY | WORK_DETAIL_ADJUST |
| Work Detail Adjust UTC Insert Date | WRKDA_UTC_INSERT_DATE | WORK_DETAIL_ADJUST |
| Work Detail Adjust UTC Update Date | WRKDA_UTC_UPDATE_DATE | WORK_DETAIL_ADJUST |
| Archived | archived* | WORK_DETAIL_ADJUST |
| Deleted | deleted* | WORK_DETAIL_ADJUST |
| Variation | variation* | WORK_DETAIL_ADJUST |
| Data Lake Time Stamp | lastModified* | WORK_DETAIL_ADJUST |
| Work Summary ID | WRKS_ID | WORK_SUMMARY |
| Employee ID | EMP_ID | WORK_SUMMARY |
| Shift ID | SHFT_ID | WORK_SUMMARY |
| Calculation Group ID | CALCGRP_ID | WORK_SUMMARY |
| Pay Group ID | PAYGRP_ID | WORK_SUMMARY |
| Payroll Export Type ID | PETYP_ID | WORK_SUMMARY |
| EA Time Approval Status ID | EATSTS_ID | WORK_SUMMARY |
| Work Summary Work Date | WRKS_WORK_DATE | WORK_SUMMARY |
| Work Summary Start Time | WRKS_START_TIME | WORK_SUMMARY |
| Work Summary End Time | WRKS_END_TIME | WORK_SUMMARY |
| Work Summary Manual Calculation | WRKS_MANUAL_CALC | WORK_SUMMARY |
| Work Summary Authorized | WRKS_AUTHORIZED | WORK_SUMMARY |
| Work Summary Authorized By | WRKS_AUTH_BY | WORK_SUMMARY |
| Work Summary Authorized Date | WRKS_AUTH_DATE | WORK_SUMMARY |
| Work Summary Error Status | WRKS_ERROR_STATUS | WORK_SUMMARY |
| Work Summary Flag Break | WRKS_FLAG_BRK | WORK_SUMMARY |
| Work Summary Flag Recall | WRKS_FLAG_RECALL | WORK_SUMMARY |
| Work Summary Flag1 | WRKS_FLAG1 | WORK_SUMMARY |
| Work Summary Flag2 | WRKS_FLAG2 | WORK_SUMMARY |
| Work Summary Flag3 | WRKS_FLAG3 | WORK_SUMMARY |
| Work Summary Flag4 | WRKS_FLAG4 | WORK_SUMMARY |
| Work Summary Flag5 | WRKS_FLAG5 | WORK_SUMMARY |
| Work Summary Udf1 | WRKS_UDF1 | WORK_SUMMARY |
| Work Summary Udf2 | WRKS_UDF2 | WORK_SUMMARY |
| Work Summary Udf3 | WRKS_UDF3 | WORK_SUMMARY |
| Work Summary Udf4 | WRKS_UDF4 | WORK_SUMMARY |
| Work Summary Udf5 | WRKS_UDF5 | WORK_SUMMARY |
| Work Summary Udf6 | WRKS_UDF6 | WORK_SUMMARY |
| Work Summary Udf7 | WRKS_UDF7 | WORK_SUMMARY |
| Work Summary Udf8 | WRKS_UDF8 | WORK_SUMMARY |
| Work Summary Udf9 | WRKS_UDF9 | WORK_SUMMARY |
| Work Summary Udf10 | WRKS_UDF10 | WORK_SUMMARY |
| Work Summary Description | WRKS_DESC | WORK_SUMMARY |
| Work Summary Comments | WRKS_COMMENTS | WORK_SUMMARY |
| Work Summary Clocks | WRKS_CLOCKS | WORK_SUMMARY |
| Work Summary Error | WRKS_ERROR | WORK_SUMMARY |
| Time Code Summary | WRKS_TCODE_SUM | WORK_SUMMARY |
| Hour Type Summary | WRKS_HTYPE_SUM | WORK_SUMMARY |
| Work Summary Original Clocks | WRKS_ORIG_CLOCKS | WORK_SUMMARY |
| Work Summary Messages | WRKS_MESSAGES | WORK_SUMMARY |
| Work Summary In Code | WRKS_IN_CODE | WORK_SUMMARY |
| Work Summary Out Code | WRKS_OUT_CODE | WORK_SUMMARY |
| Work Summary Full Day Code | WRKS_FULL_DAY_CODE | WORK_SUMMARY |
| Work Summary Full Day Minutes | WRKS_FULL_DAY_MINUTES | WORK_SUMMARY |
| Work Summary Submitted | WRKS_SUBMITTED | WORK_SUMMARY |
| Work Summary Default Settings | WRKS_USE_DEF_SETTINGS | WORK_SUMMARY |
| Work Summary Work Detail Authorized | WRKS_WRKD_AUTH | WORK_SUMMARY |
| Work Summary Clocks Authorized | WRKS_CLKS_AUTHORIZED | WORK_SUMMARY |
| Work Summary UTC Insert Date | WRKS_UTC_INSERT_DATE | WORK_SUMMARY |
| Work Summary UTC Update Date | WRKS_UTC_UPDATE_DATE | WORK_SUMMARY |
| Archived | archived* | WORK_SUMMARY |
| Deleted | deleted* | WORK_SUMMARY |
| Variation | variation* | WORK_SUMMARY |
| Data Lake Time Stamp | lastModified* | WORK_SUMMARY |
| Balance Description | BAL_DESC | WFM_Balance |
| Balance Hidden | BAL_HIDDEN | WFM_Balance |
| Balance ID | BAL_ID | WFM_Balance |
| Balance Name | BAL_NAME | WFM_Balance |
| Balance UTC Insert Date | BAL_UTC_INSERT_DATE | WFM_Balance |
| Balance UTC Update Date | BAL_UTC_UPDATE_DATE | WFM_Balance |
| Data Lake Time Stamp | lastModified | WFM_Balance |
| Is Deleted | DELETED | WFM_BalanceType |
| Balance Type Description | BAL_TYP_DESC | WFM_BalanceType |
| Balance Type ID | BAL_TYP_ID | WFM_BalanceType |
| Balance Type Name | BAL_TYP_NAME | WFM_BalanceType |
| Balance Type UTC Insert Date | BAL_TYP_UTC_INSERT_DATE | WFM_BalanceType |
| Balance Type UTC Update Date | BAL_TYP_UTC_UPDATE_DATE | WFM_BalanceType |
| Data Lake Time Stamp | LastModified | WFM_BalanceType |
| Is Deleted | DELETED | WFM_BalanceType |
| Duration Format Description | DUR_FMT_DESC | WFM_DurationFormat |
| Duration Format ID | DUR_FMT_ID | WFM_DurationFormat |
| Duration Format Name | DUR_FMT_NAME | WFM_DurationFormat |
| Is Deleted | DELETED | WFM_DurationFormat |
| Is Deleted | DELETED | WFM_EmployeeBalance |
| Archived | ARCHIVED | WFM_EmployeeBalance |
| Data Lake Time Stamp | lastModified | WFM_EmployeeBalance |
| Employee Balance Log Comment | EBLOG_COMMENT | WFM_EmployeeBalanceLog |
| Employee Balance Log ID | EBLOG LOG_ID | WFM_EmployeeBalanceLog |
| Employee Balance Log Message | EBLOG_MESSAGE | WFM_EmployeeBalanceLog |
| Employee Balance Log UTC Insert Date | EBLOG_UTC_INSERT_DATE | WFM_EmployeeBalanceLog |
| Employee Balance Log UTC Update Date | E_B_L_OG_UTC_UPDATE_DATE | WFM_EmployeeBalanceLog |
| Is Deleted | DELETED | WFM_EmployeeBalanceLog |
| Work Summary Work Date | WRKS_WORK_DATE | WFM_EmployeeBalanceLog |
| Data Lake Time Stamp | lastModified | WFM_EmployeeBalanceLog |
| Is Deleted | DELETED | WFM_EmployeeDefaultLabor |
| Time Off Approval Comment | TOA_COMMENT | WFM_TimeOffApproval |
| Time Off Approval Date | TOA_APPROVAL_DATE | WFM_TimeOffApproval |
| Time Off Approval ID | TOA_ID | WFM_TimeOffApproval |
| Time Off Approval Is Approved | TOA_IS_APPROVED | WFM_TimeOffApproval |
| Time Off Approval UTC Insert Date | TOA_UTC_INSERT_DATE | WFM_TimeOffApproval |
| Time Off Approval UTC Update Date | TOA_UTC_UPDATE_DATE | WFM_TimeOffApproval |
| Time Off Approval Flag1 | TOA_FLAG1 | WFM_TimeOffApproval |
| Time Off Approval Flag2 | TOA_FLAG2 | WFM_TimeOffApproval |
| Time Off Approval Flag3 | TOA_FLAG3 | WFM_TimeOffApproval |
| Time Off Approval Flag4 | TOA_FLAG4 | WFM_TimeOffApproval |
| Time Off Approval Flag5 | TOA_FLAG5 | WFM_TimeOffApproval |
| Time Off Approval Udf1 | TOA_UDF1 | WFM_TimeOffApproval |
| Time Off Approval Udf2 | TOA_UDF2 | WFM_TimeOffApproval |
| Time Off Approval Udf3 | TOA_UDF3 | WFM_TimeOffApproval |
| Time Off Approval Udf4 | TOA_UDF4 | WFM_TimeOffApproval |
| Time Off Approval Udf5 | TOA_UDF5 | WFM_TimeOffApproval |
| Data Lake Time Stamp | lastModified | WFM_TimeOffApproval |
| Is Deleted | DELETED | WFM_TimeOffApproval |
| Time Off Approval Cancelled ID | TOA_CANCEL_ID | WFM_TimeOffApproval |
| Time Off Approval Date | TOA_APPROVAL_DATE | WFM_TimeOffApproval |
| Time Off Approval Is Approved | TOA_IS_APPROVED | WFM_TimeOffApproval |
| Time Off Day Date | TOD_DATE | WFM_TimeOffDay |
| Time Off Day Employee Comment | TOD_EMP_COMMENT | WFM_TimeOffDay |
| Time Off Day ID | TOTOFF_TYP_ID | WFM_TimeOffDay |
| Time Off Day Pay In Advance | TOD_todPayInAdv | WFM_TimeOffDay |
| Time Off Day UTC Insert Date | TOD_UtcInsertDate | WFM_TimeOffDay |
| Time Off Day UTC Update Date | TOD_UtcUpdateDate | WFM_TimeOffDay |
| Time Off Request Cancelled ID | TOR_CANCEL_ID | WFM_TimeOffDay |
| Time Off Type End Time | TOD_END_TIME | WFM_TimeOffDay |
| Time Off Type Start Time | TOD_START_TIME | WFM_TimeOffDay |
| Time Off Day Flag1 | TOD_FLAG1 | WFM_TimeOffDay |
| Time Off Day Flag2 | TOD_FLAG2 | WFM_TimeOffDay |
| Time Off Day Flag3 | TOD_FLAG3 | WFM_TimeOffDay |
| Time Off Day Flag4 | TOD_FLAG4 | WFM_TimeOffDay |
| Time Off Day Flag5 | TOD_FLAG5 | WFM_TimeOffDay |
| Time Off Day Udf1 | TOD_UDF1 | WFM_TimeOffDay |
| Time Off Day Udf2 | TOD_UDF2 | WFM_TimeOffDay |
| Time Off Day Udf3 | TOD_UDF3 | WFM_TimeOffDay |
| Time Off Day Udf4 | TOD_UDF4 | WFM_TimeOffDay |
| Time Off Day Udf5 | TOD_UDF5 | WFM_TimeOffDay |
| Data Lake Time Stamp | lastModified | WFM_TimeOffDay |
| Is Deleted | DELETED | WFM_TimeOffDay |
| Time Off Reason Description | TOFF_RSN_DESC | WFM_TimeOffReason |
| Time Off Reason ID | TOFF_RSN_ID | WFM_TimeOffReason |
| Time Off Reason Name | TOFF_RSN_NAME | WFM_TimeOffReason |
| Time Off Reason UTC Insert Date | TOFF_RSN_UTC_INSERT_DATE | WFM_TimeOffReason |
| Time Off Reason UTC Update Date | TOFF_RSN_UTC_UPDATE_DATE | WFM_TimeOffReason |
| Data Lake Time Stamp | lastModified | WFM_TimeOffReason |
| Is Deleted | DELETED | WFM_TimeOffReason |
| Time Off Request Comment | TOR_COMMENT | WFM_TimeOffRequest |
| Time Off Request Create Date | TOR_CREATE_DATE | WFM_TimeOffRequest |
| Time Off Request ID | TOR_ID | WFM_TimeOffRequest |
| Time Off Request Is Cancelled | TOR_IS_CANCEL | WFM_TimeOffRequest |
| Time Off Request UTC Insert Date | TOR_UTC_INSERT_DATE | WFM_TimeOffRequest |
| Time Off Request UTC Update Date | TOR_UTC_UPDATE_DATE | WFM_TimeOffRequest |
| Time Off Request Flag1 | TOR_FLAG1 | WFM_TimeOffRequest |
| Time Off Request Flag2 | TOR_FLAG2 | WFM_TimeOffRequest |
| Time Off Request Flag3 | TOR_FLAG3 | WFM_TimeOffRequest |
| Time Off Request Flag4 | TOR_FLAG4 | WFM_TimeOffRequest |
| Time Off Request Flag5 | TOR_FLAG5 | WFM_TimeOffRequest |
| Time Off Request Udf1 | TOR_UDF1 | WFM_TimeOffRequest |
| Time Off Request Udf2 | TOR_UDF2 | WFM_TimeOffRequest |
| Time Off Request Udf3 | TOR_UDF3 | WFM_TimeOffRequest |
| Time Off Request Udf4 | TOR_UDF4 | WFM_TimeOffRequest |
| Time Off Request Udf5 | TOR_UDF5 | WFM_TimeOffRequest |
| Data Lake Time Stamp | lastModified | WFM_TimeOffRequest |
| Is Deleted | DELETED | WFM_TimeOffRequest |
| Time Off Type Allow In Past | TOFF_TYP_ALLOW_IN_PAST | WFM_TimeOffType |
| Time Off Type Allow On Blackout | TOFF_TYP_ALLOW_ON_BLACKOUT | WFM_TimeOffType |
| Time Off Type Allow On Holiday | TOFF_TYP_ALLOW_ON_HOLIDAY | WFM_TimeOffType |
| Time Off Type Apply On Unscheduled Days | TOFF_TYP_APPLY_ON_UNSCHED_DAYS | WFM_TimeOffType |
| Time Off Type Auto Approve | TOFF_TYP_AUTO_APPROVE | WFM_TimeOffType |
| Time Off Type Auto Approve Cancel | TOFF_TYP_AUTO_APPROVE_CANCEL | WFM_TimeOffType |
| Time Off Type Auto Approve Scheduled | TOFF_TYP_AUTO_APPROVE_SCHED | WFM_TimeOffType |
| Time Off Type Bad Timecodes | TOFF_TYP_BAD_T_CODES | WFM_TimeOffType |
| Time Off Type Comment Required | TOFF_TYP_COMMENT_REQD | WFM_TimeOffType |
| Time Off Type Current Timecode ID | TOFF_TYP_CUR_T_CODE_ID | WFM_TimeOffType |
| Time Off Type Description | TOFF_TYP_DESC | WFM_TimeOffType |
| Time Off Type Employee Type | TOFF_TYP_EMP_TYPE | WFM_TimeOffType |
| Time Off Type Full Day | TOFF_TYP_FULL_DAY | WFM_TimeOffType |
| Time Off Type Future Timecode ID | TOFF_TYP_FUT_T_COD_EID | WFM_TimeOffType |
| Time Off Type ID | TOFF_TYP_ID | WFM_TimeOffType |
| Time Off Type Maximum Days | TOFF_TYP_MAX_DAYS | WFM_TimeOffType |
| Time Off Type Maximum Days in Advance | TOFF_TYP_MAX_DAYS_ADV | WFM_TimeOffType |
| Time Off Type Minimum Days Employee | TOFF_TYP_MIN_DAYS_EMP | WFM_TimeOffType |
| Time Off Type Minimum Days in Advance | TOFF_TYP_MIN_DAYS_ADV | WFM_TimeOffType |
| Time Off Type Minimum Interval | TOFF_TYP_MIN_INTERVAL | WFM_TimeOffType |
| Time Off Type Name | TOFF_TYP_NAME | WFM_TimeOffType |
| Time Off Type Pay Current | TOFF_TYP_PAY_CURRENT | WFM_TimeOffType |
| Time Off Type Reason Required | TOFF_TYP_REASON_REQD | WFM_TimeOffType |
| Time Off Type Recallable | TOFF_TYP_RECALLABLE | WFM_TimeOffType |
| Time Off Type Skip Public Holidays | TOFF_TYP_SKIP_PUBLIC_HOLIDAYS | WFM_TimeOffType |
| Time Off Type Unpaid Timecode ID | TOFF_TYP_RUP_T_CODE_ID | WFM_TimeOffType |
| Time Off Type UTC Insert Date | TOFF_TYP_UTC_INSERT_DATE | WFM_TimeOffType |
| Time Off Type UTC Update Date | TOFF_TYP_UTC_UPDATE_DATE | WFM_TimeOffType |
| Time Off Type Flag1 | TOFF_TYP_FLAG1 | WFM_TimeOffType |
| Time Off Type Flag2 | TOFF_TYP_FLAG2 | WFM_TimeOffType |
| Time Off Type Flag3 | TOFF_TYP_FLAG3 | WFM_TimeOffType |
| Time Off Type Flag4 | TOFF_TYP_FLAG4 | WFM_TimeOffType |
| Time Off Type Flag5 | TOFF_TYP_FLAG5 | WFM_TimeOffType |
| Time Off Type Flag6 | TOFF_TYP_FLAG6 | WFM_TimeOffType |
| Time Off Type Flag7 | TOFF_TYP_FLAG7 | WFM_TimeOffType |
| Time Off Type Flag8 | TOFF_TYP_FLAG8 | WFM_TimeOffType |
| Time Off Type Flag9 | TOFF_TYP_FLAG9 | WFM_TimeOffType |
| Time Off Type Flag10 | TOFF_TYP_FLAG10 | WFM_TimeOffType |
| Time Off Type Udf1 | TOFF_TYP_UDF1 | WFM_TimeOffType |
| Time Off Type Udf2 | TOFF_TYP_UDF2 | WFM_TimeOffType |
| Time Off Type Udf3 | TOFF_TYP_UDF3 | WFM_TimeOffType |
| Time Off Type Udf4 | TOFF_TYP_UDF4 | WFM_TimeOffType |
| Time Off Type Udf5 | TOFF_TYP_UDF5 | WFM_TimeOffType |
| Time Off Type Udf6 | TOFF_TYP_UDF6 | WFM_TimeOffType |
| Time Off Type Udf7 | TOFF_TYP_UDF7 | WFM_TimeOffType |
| Time Off Type Udf8 | TOFF_TYP_UDF8 | WFM_TimeOffType |
| Time Off Type Udf9 | TOFF_TYP_UDF9 | WFM_TimeOffType |
| Time Off Type Udf10 | TOFF_TYP_UDF10 | WFM_TimeOffType |
| Event Apply Sub Team | ACEVT_APPLY_SUB_TM | WFM_AcEvent |
| Event Calculation Group Names | ACEVT_CALC_GRP_NAMES | WFM_AcEvent |
| Event Description | ACEVT_DESC | WFM_AcEvent |
| Event Employee Names | ACEVT_EMP_NAMES | WFM_AcEvent |
| Event ID | ACEVT_ID | WFM_AcEvent |
| Event Name | ACEVT_NAME | WFM_AcEvent |
| Event Pay Group Names | ACEVT_PAY_GRP_NAMES | WFM_AcEvent |
| Event Points | ACEVT_POINTS | WFM_AcEvent |
| Workbrain Team Names | ACEVT_WB_T_NAMES | WFM_AcEvent |
| Event Employee Value1s | ACEVT_EMP_VAL1 | WFM_AcEvent |
| Event Employee Value2s | ACEVT_EMP_VAL2 | WFM_AcEvent |
| Event Employee Value3s | ACEVT_EMP_VAL3 | WFM_AcEvent |
| Event Employee Value4s | ACEVT_EMP_VAL4 | WFM_AcEvent |
| Event Employee Value5s | ACEVT_EMP_VAL5 | WFM_AcEvent |
| Event Employee Value6s | ACEVT_EMP_VAL6 | WFM_AcEvent |
| Event Employee Value7s | ACEVT_EMP_VAL7 | WFM_AcEvent |
| Event Employee Value8s | ACEVT_EMP_VAL8 | WFM_AcEvent |
| Event Employee Value9s | ACEVT_EMP_VAL9 | WFM_AcEvent |
| Event Employee Value10s | ACEVT_EMP_VAL10 | WFM_AcEvent |
| Event Flag1 | ACEVT_FLAG1 | WFM_AcEvent |
| Event Flag2 | ACEVT_FLAG2 | WFM_AcEvent |
| Event Flag3 | ACEVT_FLAG3 | WFM_AcEvent |
| Event Flag4 | ACEVT_FLAG4 | WFM_AcEvent |
| Event Flag5 | ACEVT_FLAG5 | WFM_AcEvent |
| Event Flag6 | ACEVT_FLAG6 | WFM_AcEvent |
| Event Flag7 | ACEVT_FLAG7 | WFM_AcEvent |
| Event Flag8 | ACEVT_FLAG8 | WFM_AcEvent |
| Event Flag9 | ACEVT_FLAG9 | WFM_AcEvent |
| Event Flag10 | ACEVT_FLAG10 | WFM_AcEvent |
| Archived | ARCHIVED | WFM_AcEvent |
| Data Lake Time Stamp | lastModified | WFM_AcEvent |
| Event ID | ACEVTLOG_ ID | WFM_AcEventLog |
| Event Log Authorized By | ACEVTLOG_ AUTH_BY | WFM_AcEventLog |
| Event Log Authorized Date | ACEVTLOG_AUTH_DATE | WFM_AcEventLog |
| Event Log Date | ACEVTLOG_DATE | WFM_AcEventLog |
| Event Log Employee Reason | ACEVTLOG_EMPREASON | WFM_AcEventLog |
| Event Log ID | ACEVTLOG_ID | WFM_AcEventLog |
| Event Log Status | ACEVTLOG_STATUS | WFM_AcEventLog |
| Event Log Supervisor Notes | ACEVTLOG_SUPER_NOTES | WFM_AcEventLog |
| Event Log UTC Insert Date | ACEVTLOG_UTC_INSERT_DATE | WFM_AcEventLog |
| Event Log UTC Update Date | ACEVTLOG_UTC_UPDATE_DATE | WFM_AcEventLog |
| Event Log Work Date | ACEVTLOG_LOG_WORK_DATE | WFM_AcEventLog |
| Is Deleted | DELETED | WFM_AcEventLog |
| AC Event Log Flag1 | ACEVTLOG_FLAG1 | WFM_AcEventLog |
| AC Event Log Flag2 | ACEVTLOG_FLAG2 | WFM_AcEventLog |
| AC Event Log Flag3 | ACEVTLOG_FLAG3 | WFM_AcEventLog |
| AC Event Log Flag4 | ACEVTLOG_FLAG4 | WFM_AcEventLog |
| AC Event Log Flag5 | ACEVTLOG_FLAG5 | WFM_AcEventLog |
| AC Event Log Udf1 | ACEVTLOG_UDF1 | WFM_AcEventLog |
| AC Event Log Udf2 | ACEVTLOG_UDF2 | WFM_AcEventLog |
| AC Event Log Udf3 | ACEVTLOG_UDF3 | WFM_AcEventLog |
| AC Event Log Udf4 | ACEVTLOG_UDF4 | WFM_AcEventLog |
| AC Event Log Udf5 | ACEVTLOG_UDF5 | WFM_AcEventLog |
| Archived | ARCHIVED | WFM_AcEventLog |
| Data Lake Time Stamp | lastModified | WFM_AcEventLog |
| Event Violation Log ID | ACVIO_LOG_ID | WFM_AcViolationLog |
| Event Violation Log UTC Insert Date | ACVIOLOG_UTC_INSERT_DATE | WFM_AcViolationLog |
| Event Violation Log UTC Update Date | ACVIOLOG_UTC_UPDATE_DATE | WFM_AcViolationLog |
| Is Deleted | DELETED | WFM_AcViolationLog |
| Data Lake Time Stamp | lastModified | WFM_AcViolationLog |
| AC Period Type ID | AC_PER_TYP_ID | WFM_AcViolation |
| Violation Action | ACVIOL_ACTION | WFM_AcViolation |
| Violation Apply Sub Team Eligibility | ACVIOL_APPLY_SUB_TM | WFM_AcViolation |
| Violation Calculation Group Names | ACVIOL_CALC_GRP_NAMES | WFM_AcViolation |
| Violation Condition | ACVIOL_CONDITION | WFM_AcViolation |
| Violation Description | ACVIOL_DESC | WFM_AcViolation |
| Violation Employee Names | ACVIOL_EMP_NAMES | WFM_AcViolation |
| Violation Event Names | ACVIOL_ACEVT_NAMES | WFM_AcViolation |
| Violation Exclude Counted Events | ACVIOL_EXCLUDE | WFM_AcViolation |
| Violation ID | ACVIOL_ID | WFM_AcViolation |
| Violation Ignore Authorized | ACVIOL_IGNORE | WFM_AcViolation |
| Violation Name | ACVIOL_NAME | WFM_AcViolation |
| Violation Pay Group Names | ACVIOL_PAY_GRP_NAMES | WFM_AcViolation |
| Violation UTC Insert Date | ACVIOL_UTC_INSERT_DATE | WFM_AcViolation |
| Violation UTC Update Date | ACVIOL_UTC_UPDATE_DATE | WFM_AcViolation |
| Workbrain Team Names | WBT_NAMES | WFM_AcViolation |
| AC Violation Employee Value1s | ACVIOL_EMP_VAL1 | WFM_AcViolation |
| AC Violation Employee Value2s | ACVIOL_EMP_VAL2 | WFM_AcViolation |
| AC Violation Employee Value3s | ACVIOL_EMP_VAL3 | WFM_AcViolation |
| AC Violation Employee Value4s | ACVIOL_EMP_VAL4 | WFM_AcViolation |
| AC Violation Employee Value5s | ACVIOL_EMP_VAL5 | WFM_AcViolation |
| AC Violation Employee Value6s | ACVIOL_EMP_VAL6 | WFM_AcViolation |
| AC Violation Employee Value7s | ACVIOL_EMP_VAL7 | WFM_AcViolation |
| AC Violation Employee Value8s | ACVIOL_EMP_VAL8 | WFM_AcViolation |
| AC Violation Employee Value9s | ACVIOL_EMP_VAL9 | WFM_AcViolation |
| AC Violation Employee Value10s | ACVIOL_EMP_VAL10 | WFM_AcViolation |
| AC Violation Flag1 | ACVIOL_FLAG1 | WFM_AcViolation |
| AC Violation Flag2 | ACVIOL_FLAG2 | WFM_AcViolation |
| AC Violation Flag3 | ACVIOL_FLAG3 | WFM_AcViolation |
| AC Violation Flag4 | ACVIOL_FLAG4 | WFM_AcViolation |
| AC Violation Flag5 | ACVIOL_FLAG5 | WFM_AcViolation |
| AC Violation Flag6 | ACVIOL_FLAG6 | WFM_AcViolation |
| AC Violation Flag7 | ACVIOL_FLAG7 | WFM_AcViolation |
| AC Violation Flag8 | ACVIOL_FLAG8 | WFM_AcViolation |
| AC Violation Flag9 | ACVIOL_FLAG9 | WFM_AcViolation |
| AC Violation Flag10 | ACVIOL_FLAG10 | WFM_AcViolation |
| AC Violation Udf1 | ACVIOL_UDF1 | WFM_AcViolation |
| AC Violation Udf2 | ACVIOL_UDF2 | WFM_AcViolation |
| AC Violation Udf3 | ACVIOL_UDF3 | WFM_AcViolation |
| AC Violation Udf4 | ACVIOL_UDF4 | WFM_AcViolation |
| AC Violation Udf5 | ACVIOL_UDF5 | WFM_AcViolation |
| AC Violation Udf6 | ACVIOL_UDF6 | WFM_AcViolation |
| AC Violation Udf7 | ACVIOL_UDF7 | WFM_AcViolation |
| AC Violation Udf8 | ACVIOL_UDF8 | WFM_AcViolation |
| AC Violation Udf9 | ACVIOL_UDF9 | WFM_AcViolation |
| AC Violation Udf10 | ACVIOL_UDF10 | WFM_AcViolation |
| Archived | ARCHIVED | WFM_AcViolation |
| Data Lake Time Stamp | lastModified | WFM_AcViolation |
| Is Deleted | DELETED | WFM_AcViolation |
| Violation Log Authorized By | ACVIOLOG_AUTH_BY | WFM_AcViolationLog |
| Violation Log Authorized Date | ACVIOLOG_AUTH_DATE | WFM_AcViolationLog |
| Violation Log Comments | ACVIOLOG_COMMENTS | WFM_AcViolationLog |
| Violation Log Date | ACVIOLOG_DATE | WFM_AcViolationLog |
| Violation Log Employee Reason | ACVIOLOG_EMP_REASON | WFM_AcViolationLog |
| Violation Log ID | ACVIOL_ID | WFM_AcViolationLog |
| Violation Log Notified By | ACVIOLOG_NOTIFIED_BY | WFM_AcViolationLog |
| Violation Log Status | ACVIOLOG_STATUS | WFM_AcViolationLog |
| Violation Log Supervisor Notes | ACVIOLOG_SUPER_NOTES | WFM_AcViolationLog |
| Violation Log Work Date | ACVIOLOG_WORK_DATE | WFM_AcViolationLog |
| AC Violation Log Flag1 | ACVIOLOG_FLAG1 | WFM_AcViolationLog |
| AC Violation Log Flag2 | ACVIOLOG_FLAG2 | WFM_AcViolationLog |
| AC Violation Log Flag3 | ACVIOLOG_FLAG3 | WFM_AcViolationLog |
| AC Violation Log Flag4 | ACVIOLOG_FLAG4 | WFM_AcViolationLog |
| AC Violation Log Flag5 | ACVIOLOG_FLAG5 | WFM_AcViolationLog |
| AC Violation Log Udf1 | ACVIOLOG_UDF1 | WFM_AcViolationLog |
| AC Violation Log Udf2 | ACVIOLOG_UDF2 | WFM_AcViolationLog |
| AC Violation Log Udf3 | ACVIOLOG_UDF3 | WFM_AcViolationLog |
| AC Violation Log Udf4 | ACVIOLOG_UDF4 | WFM_AcViolationLog |
| AC Violation Log Udf5 | ACVIOLOG_UDF5 | WFM_AcViolationLog |
Note: * - source columns are from Data Lake