List of defined time-span elements used by applications to calculate hours-of-operation time calculations
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) numeric identifier. |
| sym | nvarchar(30) | not null | The sym value for this Timespan. |
| code | nvarchar(10) | not null | The code value for this Timespan. |
| start_year | nvarchar(5) | with null | The start year value for this Timespan. |
| start_month | nvarchar(5) | with null | The start month value for this Timespan. |
| start_day | nvarchar(5) | with null | The start day value for this Timespan. |
| start_hour | nvarchar(5) | with null | The start hour value for this Timespan. |
| start_minute | nvarchar(5) | with null | The start minute value for this Timespan. |
| end_year | nvarchar(5) | with null | The end year value for this Timespan. |
| end_month | nvarchar(5) | with null | The end month value for this Timespan. |
| end_day | nvarchar(5) | with null | The end day value for this Timespan. |
| end_hour | nvarchar(5) | with null | The end hour value for this Timespan. |
| end_minute | nvarchar(5) | with null | The end minute value for this Timespan. |
| trigger_year | nvarchar(5) | with null | The trigger year value for this Timespan. |
| trigger_month | nvarchar(5) | with null | The trigger month value for this Timespan. |
| trigger_day | nvarchar(5) | with null | The trigger day value for this Timespan. |
| trigger_hour | nvarchar(5) | with null | The trigger hour value for this Timespan. |
| trigger_minute | nvarchar(5) | with null | The trigger minute value for this Timespan. |
| nx_desc | nvarchar(240) | with null | The desc value for this Timespan. |
| last_mod_dt | integer | with null | Timestamp of when this record was last modified |
| last_mod_by | byte(16) | with null | Specifies the uuid of the contact who last modified this record |
Product Name: Unicenter Service Desk
Table Type: Table