Contains the information for managing calendar hours
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cale_id | INT | Calendar ID, table reference, ASMS_CALENDAR. CALENDAR_ID |
| end_date | DATETIME | End date |
| end_time | TIME | End time |
| hour_id* | INT | Unique identifier for calendar times |
| start_date | DATETIME | Start Date |
| start_time | TIME | Start time |
Primary Key
| PK_ASMS_CALENDAR_HOURS |
|---|
| hour_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cale_id | dbo.ASMS_CALENDAR | calendar_id | FK01_ASMS_CALENDAR_HOURS |