Table for recording dates to calculate service agreement care time.
Data model
Fields
| Field | Type | Description |
|---|---|---|
| cale_id | INT | column than the calendar ID associated with the SLA configuration. |
| casc_day* | INT | column that contains information about the number of scheduled days associated with the calendar. |
| casc_hour_end* | DATETIME | column that contains Service Agreement Schedule End Date information. |
| casc_hour_start* | DATETIME | column that contains Service Agreement Schedule Start Date information. |
| casc_id* | INT | Primary Table Key |
Primary Key
| PK_AFLS_CALENDAR_SCHEDULE |
|---|
| casc_id |
References
| Column | Referenced Table | Referenced column | Name |
|---|---|---|---|
| cale_id | dbo.AFLS_CALENDAR | cale_id | FK01_AFLS_CALENDAR_SCHEDULE |