Previous Topic: Survey TableNext Topic: Survey_Answer_Template Table


Survey_Answer Table

Customer Survey Answer.

Field

Data Type

Reference

Remarks

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.

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.

own_srvy_ question

INTEGER

Survey_Question ::id

Unique (to the table) numeric ID.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

selected

INTEGER

 

Identifies the selected value for this Survey_Answer.

sequence

INTEGER

 

Specifies the display order of the survey answers.

txt

nvarchar(400)

 

Specifies the question text.