Expand All Collapse All
Survey Question Branching

SurveyQuestionBranching Table

Survey Question Branching

The SurveyQuestionBranching table contains the information for question branching. There is one entry in this table for each configured branch.

  • 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
SurveyQuestionBranchingID uniqueidentifier False No

ID of the survey question branching entry

 4.0.106.453 4.0 Release Survey Question Branching ID Attribute CSSurvey
SurveyQuestionID varchar (32) False No

The ID of the question to which this branching entry corresponds

 4.0.106.453 4.0 Release Survey Question ID Attribute CSSurvey
OperatorType int True No

Operator type of the branching condition

  • 0 - Continue to Next
  • 1 - Less Than
  • 2 - Less Than Or Equal
  • 3 - Equal
  • 4 - Greater Than Or Equal
  • 5 - Greater Than
  • 6 - Between
  • 7 - Not Equal
  • 8 - Skip
 4.0.106.453 4.0 Release Operator Type Fact CSSurvey
Operand1Value int True No

The operand1 of the branching operator

 4.0.106.453 4.0 Release Operand1 Value Fact CSSurvey
Operand2Value int True No

The operand2 of the branching operator

 4.0.106.453 4.0 Release Operand2 Value Fact CSSurvey
TargetQuestionID varchar (32) True No

The question ID to jump to if the condition is met

 4.0.106.453 4.0 Release Target Question ID Attribute CSSurvey
Sequence int True No

The sequence of the branching entry

 4.0.106.453 4.0 Release Sequence Fact CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyQuestionBranching Clustered SurveyQuestionBranchingID (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyQuestionBranching_SurveyQuestionID SurveyQuestionID SurveyQuestion SurveyQuestionID Yes
FK_SurveyQuestionBranching_TargetQuestionID TargetQuestionID SurveyQuestion SurveyQuestionID Yes