Workshift definition
| 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 | The symbolic value for this workshift |
| description | nvarchar(80) | with null | Textual description of this workshift |
| sched | nvarchar(1000) | with null | Describes the schedule of this workshift |
| 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