Table used to tack status of managed surveys
| Column Name | Column Datatype | Column Null Option | Column Comment |
| id | integer | not null | Primary key of this table |
| persid | nvarchar(30) | with null | Persistent ID (SystemObjectName:id) |
| del | integer | not null | Deleted flag (0=active 1=inactive/marked as deleted) |
| tplid | integer | with null | Unique (to the table) Numeric ID |
| cntid | byte(16) | with null | Primary key of this table |
| object_type | nvarchar(10) | with null | object type for this survey, ie CR, CHG, etc |
| object_id | integer | with null | Id of object for this survey |
| status | integer | with null | 1=survey submitted |
| notif_dt | integer | with null | Time of last notification |
| recv_dt | integer | with null | Time we received a completed survey |
Product Name: Unicenter Service Desk
Table Type: Table