ALEX_WEEKEND_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 |
| WEEKEND_SCHEDULE_NAME | NVARCHAR (255) | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.WEEKEND_SCHEDULE_NAME | Stores weekend schedule name |
| SUNDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.SUNDAY | 1 if Sunday is weekend; otherwise, 0. |
| MONDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.MONDAY | 1 if Monday is weekend; otherwise, 0. |
| TUESDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.TUESDAY | 1 if Tuesday is weekend; otherwise, 0. |
| WEDNESDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.WEDNESDAY | 1 if Wednesday is weekend; otherwise, 0. |
| THURSDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.THURSDAY | 1 if Thursday is weekend; otherwise, 0. |
| FRIDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.FRIDAY | 1 if Friday is weekend; otherwise, 0. |
| SATURDAY | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.SATURDAY | 1 if Saturday is weekend; otherwise, 0. |
| ACTIVE_STATUS | SMALLINT | Yes* | Yes | ALCO_WEEKEND_SCHEDULE.ACTIVE_STATUS | For checking the status |
* System required field
** Value must be unique