Expand All Collapse All
Survey Question

SurveyQuestion Table

Survey Question

The SurveyQuestion table contains the definition of questions in a survey or questions that are available to be added to a survey.

  • Table Type - Lookup
  • Last Changed Version - 4.0.106.453
  • Last Changed Reason - 4.0 Release

SQL Column Definitions

Column Data Type (Size) Is Nullable Contains PII Description Last Change Version Last Change Reason CX Insights Name CX Insights Type CX Insights Folder Name
SurveyQuestionID varchar (32) False No

ID of the survey question.

 4.0.106.453 4.0 Release Survey Question ID Attribute CSSurvey
SurveyID varchar (32) True No

ID of the survey that this question belongs to. Null if this question does not belong to a survey because it is in the library.

 4.0.106.453 4.0 Release Survey ID Attribute CSSurvey
QuestionParentId varchar (32) True No

ID of the parent question.

 4.0.106.453 4.0 Release Question Parent Id Attribute CSSurvey
QuestionName nvarchar (255) False Depends on customer usage

Name of the question.

 4.0.106.453 4.0 Release Question Name Attribute CSSurvey
QuestionText nvarchar (255) True Depends on customer usage

Description of the question.

 4.0.106.453 4.0 Release Question Text Attribute CSSurvey
MinScore numeric False No

Minimum score that can be given to the question.

 4.0.106.453 4.0 Release Minimum Score Fact CSSurvey
MaxScore numeric False No

Maximum score that can be given to the question.

 4.0.106.453 4.0 Release Maximum Score Fact CSSurvey
IsOptional int False No

1 if the question is optional else 0. Other values are not defined.

 4.0.106.453 4.0 Release Is Optional Fact CSSurvey
IsTemplate int False No

1 if the question is a template else 0. Other values are not defined. Template questions are stored in the library and won't have any survey associated with them.

 4.0.106.453 4.0 Release Is Template Fact CSSurvey
QuestionType int False No

The type of question.

  • 0 - None.
  • 1 - True / False
  • 2 - Multiple Choice
  • 3 - Numeric Range
  • 4 - Free-form (recording)
  • 5 - information
 4.0.106.453 4.0 Release Question Type Fact CSSurvey
Weight numeric False No

Weight given to the question when calculating a survey's score.

 4.0.106.453 4.0 Release Weight Fact CSSurvey
Sequence int True No

Sequence number of the question within the survey. Numbering starts at zero.

 4.0.106.453 4.0 Release Sequence Fact CSSurvey
Timeout int True No

Timeout, in seconds, when waiting for a response to the question.

 4.0.106.453 4.0 Release Timeout Fact CSSurvey
Retries int True No

Number of retries the caller gets to answer the question.

 4.0.106.453 4.0 Release Retries Fact CSSurvey
Options nvarchar (255) True No

TUI options for recording comments. The Options field is a pipe delimited string for TUI options for a free form recording. The pipe delimited components are as follows:

  • Terminate Keys - A comma delimited set of keys to signify the end of a recording.
  • Escape Key - Key to escape from making a recording.
  • Save Key - Key to confirm the recording should be saved.
  • Re-Record Key - Key to re-record the comment.
  • Replay Key - Key to replay the recording just made.
  • Confirm Recording - One to confirm the recording after it's been made. Zero to not confirm the recording.

An example of an options string might be:
*,#,1,2,3,4,5,6,7,8,9,0|*|1|3|2|0		 4.0.106.453 4.0 Release Options Attribute CSSurvey
MinAcceptableScore numeric False No

The minimum score that a question can have and still be considered acceptable (implemented?)

 4.0.106.453 4.0 Release Minimum Acceptable Score Fact CSSurvey
FailSurveyScore numeric True No

The score at which a question can cause an entire survey to fail (implemented?)

 4.0.106.453 4.0 Release Fail Survey Score Fact CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyQuestion Clustered SurveyQuestionID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyQuestion_SurveyID SurveyID Survey SurveyID Yes

Index Name Type Column Name (sort order)
IX_SurveyQuestion_QuestionName Non-clustered QuestionName (Ascending)
IX_SurveyQuestion_Sequence Non-clustered Sequence (Ascending)
IX_SurveyQuestion_SurveyID Non-clustered SurveyID (Ascending)