Survey Question Enumeration
The SurveyQuestionEnum table contains enumerations for true/false and multiple choice questions. It also contains min/max values for numeric questions.
| 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 |
|---|---|---|---|---|---|---|---|---|---|
| SurveyQuestionEnumId | varchar (32) | False | No | ID of the survey question enumeration. |
4.0.106.453 | 4.0 Release | Survey Question Enum Id | Attribute | CSSurvey |
| SurveyQuestionID | varchar (32) | False | No | ID of the question the enumeration value belongs to. |
4.0.106.453 | 4.0 Release | Survey Question Id | Attribute | CSSurvey |
| EnumSequence | int | False | No | Sequence number of the value within the enumeration. Numbering starts at zero. |
4.0.106.453 | 4.0 Release | EnumSequence | Fact | CSSurvey |
| EnumName | nvarchar (255) | False | No | Name of the enumeration value. |
4.0.106.453 | 4.0 Release | Enum Name | Attribute | CSSurvey |
| EnumText | nvarchar (255) | True | Depends on customer usage | Description of the enumeration value. |
4.0.106.453 | 4.0 Release | Enum Text | Attribute | CSSurvey |
| EnumScore | numeric | True | No | Score given if this enumeration value is selected. |
4.0.106.453 | 4.0 Release | Enum Score | 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 |
|---|---|---|---|---|---|---|---|---|---|
| SurveyQuestionEnumId | char (32) | False | No | ID of the survey question enumeration. |
4.0.106.453 | 4.0 Release | |||
| SurveyQuestionID | char (32) | False | No | ID of the question the enumeration value belongs to. |
4.0.106.453 | 4.0 Release | |||
| EnumSequence | integer | False | No | Sequence number of the value within the enumeration. Numbering starts at zero. |
4.0.106.453 | 4.0 Release | |||
| EnumName | nvarchar2 (255) | False | No | Name of the enumeration value. |
4.0.106.453 | 4.0 Release | |||
| EnumText | nvarchar2 (255) | True | Depends on customer usage | Description of the enumeration value. |
4.0.106.453 | 4.0 Release | |||
| EnumScore | number | True | No | Score given if this enumeration value is selected. |
4.0.106.453 | 4.0 Release |
| Primary Key Name | Type | Column Name (sort order) |
|---|---|---|
| PK_SurveyQuestionEnum | Clustered | SurveyQuestionEnumId (Ascending) |
| Primary Key Name | Column Name (sort order) |
|---|---|
| PK_SurveyQuestionEnum | SurveyQuestionEnumId (Ascending) |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_SurveyQuestionEnum_SurveyQuestionID | SurveyQuestionID | SurveyQuestion | SurveyQuestionID | Yes |
| Foreign Key Name | Column | Reference Table | Reference Column | Indexed |
|---|---|---|---|---|
| FK_SURVEYQSTNENUM_SURVEYQSTNID | SurveyQuestionID | SurveyQuestion | SurveyQuestionID | Yes |
| Index Name | Type | Column Name (sort order) |
|---|---|---|
| IX_SurveyQuestionEnum_EnumSequence | Non-clustered | EnumSequence (Ascending) |
| IX_SurveyQuestionEnum_SurveyQuestionID | Non-clustered | SurveyQuestionID (Ascending) |
| Index Name | Column Name (sort order) |
|---|---|
| IX_SURVEYQSTNENUM_ENUMSEQUENCE | EnumSequence (Ascending) |
| IX_SURVEYQSTNENUM_SURVEYQSTNID | SurveyQuestionID (Ascending) |