- Contents
PureConnect CX Insights Help
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 |

