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