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

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
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 char (32) False No

ID of the survey or question.

 4.0.106.453 4.0 Release
SurveyPromptID char (32) False No

ID of the prompt being associated.

 4.0.106.453 4.0 Release
AppCode integer 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

Constraints

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

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

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

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

Index Name Column Name (sort order)
ix_srvobjtosrvprmpt_srvprmptid surveypromptid (Ascending)