ALEX_HOLIDAYS (Staging Table)

Column name Data type Required Default updateable Data target Comments
external_key** VARCHAR (255) Yes* No alco_holidays.holiday id The external key -- Primary Key
holiday_sched_name_ekey VARCHAR (255) No Yes alco_holidays.holiday_sched_name_id Fk into alex_holiday_sched_name
holiday_name CHAR(40) No Yes alco_holidays.holiday_name Display name
holiday_date DATETIME No Yes alco_holidays.holiday_date Date of holiday
holiday active_status SMALLINT Yes Yes alco_holidays.holiday_active_status Active status