Previous Topic: Survey_Stats TableNext Topic: Survey_Tracking Table


Survey_Template Table

Customer Survey Template.

Field

Data Type

Reference

Remarks

comment_label

nvarchar(80)

 

Identifies the comment label value for this Survey_Template.

conclude_text

nvarchar(400)

 

Specifies the text to display after the survey has been completed.

cycle_counter

INTEGER

 

Indicates to keep a running count for Submit Cycle.

del

INTEGER

Active_Boolean_
Table::enum

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

description

nvarchar(400)

 

Indicates the textual description for this template.

id

INTEGER

 

Primary key of this table.

include_
comment

INTEGER

 

Specifies the Include Question Comment flag, as follows:
0—No comment allowed

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.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

submit_cycle

INTEGER

 

Indicates to send the survey every 'nth' time.

sym

nvarchar(12)

 

Identifies the symbolic name of the survey template.

tracking_flag

INTEGER

 

Specifies the flag to track responses.