Expand All Collapse All
Survey Object To Survey Prompt

SurveyObjectToSurveyPrompt Table

Survey Object To Survey Prompt

The SurveyObjectToSurveyPrompt table associates prompts that are assigned to a survey (Invitation, Opt-in, etc.) or a question. This is a many-to-many relationship.

  • 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
SurveyObjectID varchar (32) False No

ID of the survey or question.

 4.0.106.453 4.0 Release Survey Object ID Attribute CSSurvey
SurveyPromptID varchar (32) False No

ID of the prompt being associated.

 4.0.106.453 4.0 Release Survey Prompt ID Attribute CSSurvey
AppCode int False No

When during the survey or question the prompt will be played.
AppCode can be one of the following values for surveys:

  • 0 - Survey Invitation
  • 1 - Survey Opt-in
  • 2 - Survey Opt-Out
  • 3 - Survey Welcome
  • 4 - Survey Finish
  • 5 - Survey Help
  • 6 - Survey Bad Score

Or one of the following values for questions:
  • 7 - Question Prompts
  • 8 - Question Help
  • 9 - Question No Input
  • 10 - Question No Match
  • 11 - Save Comment
  • 12 - Re-Record Comment
  • 13 - Re-Play Comment
 4.0.106.453 4.0 Release App Code Fact CSSurvey

SQL Constraints

Primary Key Name Type Column Name (sort order)
PK_SurveyObjectToSurveyPrompt Clustered SurveyPromptID (Ascending)
SurveyObjectID (Ascending)
AppCode (Ascending)

Foreign Key Name Column Reference Table Reference Column Indexed
FK_SurveyObjectToSurveyPrompt_SurveyPromptID SurveyPromptID SurveyPrompt SurveyPromptID Yes