create_date

INTEGER

Identifies when the managed survey was created.

del

INTEGER

Boolean_
Table::enum

Specifies the Deleted flag, as follows:
0—Active

1—Inactive/marked as deleted

description

nvarchar(400)

Identifies the textual description of this managed survey.

end_date

INTEGER

Specifies the end of survey period.

group_id

byte(16)

Foreign key to the contact_uuid field of the ca_contact table, this is the Group.

id

INTEGER

Primary key of this table.

initial_method

INTEGER

Contact_
Method::
id

Foreign key to the id field of the ct_mth table, this specifies the Contact Method.

initial_msgbody

nvarchar(1000)

Identifies the message body of the initial notification message.

initial_msgtitle

nvarchar(80)

Identifies the message title of the initial notification message.

last_mod_by

byte(16)

ca_contact
::uuid

Specifies the UUID of the contact who last modified this record.

last_mod_dt

INTEGER

Indicates the timestamp of when this record was last modified.

owner

byte(16)

ca_contact
::uuid

Foreign key to the contact_uuid field of the ca_contact table, this specifies the Owner.

persid

nvarchar(30)

Persistent ID (SystemObjectName:id)

reminder_method

INTEGER

Contact_
Method::id

Foreign key to the id field of the ct_mth table, this is the Reminder Contact Method.

reminder_msgbody

nvarchar(1000)

Identifies the reminder message body of the initial notification message.

reminder_msgtitle

nvarchar(80)

Identifies the message title of the initial notification message.

start_date

INTEGER

Specifies the start of the survey period.

status

nvarchar(12)

Mgs_
Status::
code

Foreign key to the code field of the mgsstat table, this is the Status.

sym

nvarchar(12)

Identifies the symbolic name for this Managed Survey.

tplid

INTEGER

Survey_
Template
::id

Foreign key to the id field of the survey_tpl table, this is the Survey Template.