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 |