Stores the definiotion of the 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) |
| description | nvarchar(400) | with null | Textual description of this managed survey |
| sym | nvarchar(12) | not null | Symbolic name for this managed survey |
| owner | byte(16) | with null | Owner. Foreign key to the contact_uuid field of the ca_contact table |
| group_id | byte(16) | with null | Group. Foreign key to the contact_uuid field of the ca_contact table. |
| tplid | integer | with null | Survey Template. Foreign key to the id field of the survey_tpl table |
| status | nvarchar(12) | with null | Status. Foreign key to the code field of the mgsstat table. |
| initial_msgbody | nvarchar(1000) | with null | Initial notification message body |
| initial_msgtitle | nvarchar(80) | with null | Initial notification message title |
| initial_method | integer | with null | Contact Method. Foreign key to the id field of the ct_mth table |
| reminder_msgbody | nvarchar(1000) | with null | Reminder notif message body |
| reminder_msgtitle | nvarchar(80) | with null | Reminder notif message title |
| reminder_method | integer | with null | Reminder Contact Method. Foreign key to the id field of the ct_mth table |
| start_date | integer | with null | Start of survey period |
| end_date | integer | with null | End of survey period |
| create_date | integer | with null | creation date |
| 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