Previous Topic: Survey_Question TableNext Topic: Survey_Stats Table


Survey_Question_Template Table

Customer Survey Question Template.

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.

include_
qcomment

INTEGER

 

Specifies the Include Question Comment flag, as follows:
1—Include comment box for this question

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.

mult_resp_flag

INTEGER

 

Specifies the Multiple Response flag, as follows:
0—Choose 1 response (radio)
1—Choose "N" (check boxes)

owning_survey

INTEGER

Survey_Template
::id

Specifies the unique (to the table) numeric ID.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

qcomment_ label

nvarchar(80)

 

Specifies the label for the comment.

resp_required

INTEGER

 

Specifies the Required Response flag, as follows:
1—Respondents must answer the question

sequence

INTEGER

 

Specifies the display order of the survey questions.

txt

nvarchar(400)

 

Identifies the question text.