survey_qtpl

Customer Survey Question Template.

Column Name Column Datatype Column Null Option Column Comment
id integer not null Primary key of this table
persid nvarchar(30) with null Persistent ID (SystemObjectName:id)
del integer not null Deleted flag (0=active 1=inactive/marked as deleted)
txt nvarchar(400) with null question text
sequence integer not null Display order
owning_survey integer with null Unique (to the table) Numeric ID
last_mod_dt integer with null Timestamp of when this record was last modified
last_mod_by byte(16) with null Specifies the UUID of the contact who last modified this record
resp_required integer with null 1=respondents must answer the question
include_qcomment integer with null 1=include comment box for this question
mult_resp_flag integer with null 0=choose 1 response (radio) 1=choose "n" (checkboxes)
qcomment_label nvarchar(80) with null Label for Comment

Product Name: Unicenter Service Desk

Table Type: Table


Copyright © 2006 CA. All rights reserved.