cntid

byte(16)

ca_contact::uuid

Primary key of this table.

del

INTEGER

Active_Boolean_
Table::enum

Specifies the Deleted flag, as follows:
0—Active
1—Inactive/marked as deleted

id

INTEGER

Primary key of this table, this is a unique numeric ID.

notif_dt

INTEGER

Specifies the time of the last notification.

object_id

INTEGER

Identifies the ID of the object for this survey.

object_
type

nvarchar(10)

Indicates the object type for this survey, such as, CR, CHG, and so on.

persid

nvarchar(30)

Persistent ID (SystemObjectName:id).

recv_dt

INTEGER

Identifies the time the completed survey was received.

status

INTEGER

Identifies the Status flag, as follows:
1—Survey submitted

tplid

INTEGER

Survey_Template ::id

Unique (to the table) numeric ID.