ALEX_WORK_SCHEDULE (Staging table)

Your Concept

Column name Data type Required Default updateable Data target Comments
EXTERNAL_KEY** NVARCHAR (255) Yes* No ALCO_EXTERNAL_KEY.EXTERNAL_KEY External key - primary key
WORK_SCHED_NAME NVARCHAR (255) Yes* Yes ALTS_WORK_SCHEDULE.WORK_SCHED_NAME Stores work schedule name
REPORT_PERIOD_EKEY NVARCHAR(255) Yes* Yes ALTS_WORK_SCHEDULE.REPORT_PERIOD_ID Stores the report period external key
HOURS_DAY1 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY1 Stores every day hours information
HOURS_DAY2 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY2 Stores every day hours information
HOURS_DAY3 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY3 Stores every day hours information
HOURS_DAY4 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY4 Stores every day hours information
HOURS_DAY5 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY5 Stores every day hours information
HOURS_DAY6 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY6 Stores every day hours information
HOURS_DAY7 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY7 Stores every day hours information
HOURS_DAY8 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY8 Stores every day hours information
HOURS_DAY9 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY9 Stores every day hours information
HOURS_DAY10 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY10 Stores every day hours information
HOURS_DAY11 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY11 Stores every day hours information
HOURS_DAY12 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY12 Stores every day hours information
HOURS_DAY13 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY13 Stores every day hours information
HOURS_DAY14 NUMERIC(14,4) No Yes ALTS_WORK_SCHEDULE.HOURS_DAY14 Stores every day hours information
MIN_HOURS_PER_PERIOD NUMERIC(7,2) No Yes ALTS_WORK_SCHEDULE.MIN_HOURS_PER_PERIOD Number of minimum hours worked per reporting period.
MAX_HOURS_PER_PERIOD NUMERIC(7,2) No Yes ALTS_WORK_SCHEDULE.MAX_HOURS_PER_PERIOD Number of maximum hours worked per reporting period.
APPLY_CROSS_WORKDAY_TO INTEGER No Yes ALTS_WORK_SCHEDULE.APPLY_CROSS_WORKDAY_TO If a workday crosses midnight, where to apply hours of thisworkday to. 1 equals next day, 0 equals previous day.
DAY1_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY1_START_TIME Scheduled arrival time for day1
DAY1_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY1_END_TIME Scheduled departure time for day1
DAY2_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY2_START_TIME Scheduled arrival time for day2
DAY2_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY2_END_TIME Scheduled departure time for day2
DAY3_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY3_START_TIME Scheduled arrival time for day3
DAY3_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY3_END_TIME Scheduled departure time for day3
DAY4_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY4_START_TIME Scheduled arrival time for day4
DAY4_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY4_END_TIME Scheduled departure time for day4
DAY5_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY5_START_TIME Scheduled arrival time for day5
DAY5_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY5_END_TIME Scheduled departure time for day5
DAY6_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY6_START_TIME Scheduled arrival time for day6
DAY6_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY6_END_TIME Scheduled departure time for day6
DAY7_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY7_START_TIME Scheduled arrival time for day7
DAY7_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY7_END_TIME Scheduled departure time for day7
DAY8_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY8_START_TIME Scheduled arrival time for day8
DAY8_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY8_END_TIME Scheduled departure time for day8
DAY9_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY9_START_TIME Scheduled arrival time for day9
DAY9_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY9_END_TIME Scheduled departure time for day9
DAY10_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY10_START_TIME Scheduled arrival time for day10
DAY10_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY10_END_TIME Scheduled departure time for day10
DAY11_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY11_START_TIME Scheduled arrival time for day11
DAY11_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY11_END_TIME Scheduled departure time for day11
DAY12_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY12_START_TIME Scheduled arrival time for day12
DAY12_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY12_END_TIME Scheduled departure time for day12
DAY13_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY13_START_TIME Scheduled arrival time for day13
DAY13_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY13_END_TIME Scheduled departure time for day13
DAY14_START_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY14_START_TIME Scheduled arrival time for day14
DAY14_END_TIME DATETIME No Yes ALTS_WORK_SCHEDULE.DAY14_END_TIME Scheduled departure time for day14
WORK_SCHEDULE_ACTIVE_STATUS SMALLINT Yes Yes ALTS_WORK_SCHEDULE.WORK_SCHEDULE_ACTIVE_STATUS Wowkr schedule status

* System required field

** Value must be unique