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.
| 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.
Or one of the following values for questions:
|
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.
Or one of the following values for questions:
|
4.0.106.453 | 4.0 Release |
| 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) |