Timezones used in Unicenter Service Desk applications.
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Unique (to the table) Numeric ID |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| sym | nvarchar(30) | not null | Name of service type |
| 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 |
| code | nvarchar(12) | not null | Primary key of this table |
| gmt_delta | integer | with null | Delta seconds from GMT |
| description | nvarchar(500) | with null | Text description of timezone |
| start_day | integer | with null | The following fields are used to calculated DST: 0-6 day of the week |
| start_mon | integer | with null | 0-11 month of the year |
| start_pos | integer | with null | 0-1 "First" or "Last" |
| start_abs_date | integer | with null | absolute start date |
| end_day | integer | with null | 0-6 day of the week |
| end_mon | integer | with null | 0-11 month of the year |
| end_pos | integer | with null | 0-1 "First" or "Last" |
| end_abs_date | integer | with null | absolute start date |
| dst_delta | integer | with null | Delta seconds for daylight saving time |
Product Name: Unicenter Service Desk
Table Type: Table