Feedback

  • Contents
 

SurveyQuestion

Table Name Column Name CX Insights Name CX Insights Type Data Type Description Folder

SurveyQuestion

FailSurveyScore

Fail Survey Score

fact

numeric

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

Survey

SurveyQuestion

IsOptional

Is Optional

attribute

int

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

Survey

SurveyQuestion

IsTemplate

Is Template

attribute

int

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

Survey

SurveyQuestion

MaxScore

Max Score

fact

numeric

Maximum score that could be received when the survey was taken.

Survey

SurveyQuestion

MinAcceptableScore

Min Acceptable Score

fact

numeric

Minimal acceptable score for the survey

Survey

SurveyQuestion

MinScore

Min Score

fact

numeric

Minimum score that could be received when the survey was taken.

Survey

SurveyQuestion

Options

Options

attribute

nvarchar

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

Survey

SurveyQuestion

QuestionName

Question Name

attribute

nvarchar

Name of the question.

Survey

SurveyQuestion

QuestionParentId

Question Parent Id

attribute

varchar

ID of the parent question.

Survey

SurveyQuestion

QuestionText

Question Text

attribute

nvarchar

Text of the question.

Survey

SurveyQuestion

QuestionType

Question Type

attribute

int

Type of the question.

Survey

SurveyQuestion

Retries

Retries

fact

int

Transmitting Fax Only: Number of retries requested for the fax. Each fax, by default, will have one attempt. The first attempt is not included in the retry number.

Survey

SurveyQuestion

Sequence

Sequence

attribute

int

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

Survey

SurveyQuestion

SurveyQuestionID

Survey Question ID

attribute

varchar

Survey id of SurveyQuestionEnum table.

Survey

SurveyQuestion

Timeout

Timeout

fact

int

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

Survey

SurveyQuestion

Weight

Weight

fact

numeric

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

Survey