Previous Topic: SQL_Script TableNext Topic: Survey_Answer Table


Survey Table

Customer Survey.

Field

Data Type

Reference

Remarks

comment_label

nvarchar(80)

 

Specifies the comment label value for this Survey.

conclude_text

nvarchar(400)

 

Indicates the text to display after the survey is completed.

del

INTEGER

Active_Boolean_
Table::enum

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

description

nvarchar(400)

 

Specifies the textual description for this survey.

id

INTEGER

 

Specifies the primary key of this table.

include_ comment

INTEGER

 

Specifies the Include 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.

nx_comment

nvarchar(200)

 

Identifies the comment value for this Survey.

object_id

INTEGER

 

Identifies the ID of the object for this survey.

object_type

nvarchar(10)

 

Identifies the object type for this survey, for eample, CR, CHG, and so on.

persid

nvarchar(30)

 

Persistent ID (SystemObjectName:id).

sym

nvarchar(12)

 

Identifies the symbolic name of this survey.