VDEX Survey Answer
A view comprised of the SurveyAnswer table and the SurveyDetail table.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SurveyAnswerId | varchar (32) | False | No | ID of the survey answer. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| SurveyFormID | uniqueidentifier (16) | False | No | ID of the survey form this answer belongs to. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| SurveyQuestionId | varchar (32) | False | No | ID of the question given for this answer |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| NumericScore | numeric (9) | True | No | Score given to this answer. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| EnumSequence | int (4) | True | No | For true/false or multiple choice questions this is the value of EnumSequence in the SurveyQuestionEnum table that contains the possible answers to the question. Numbering starts at zero. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| FreeFormAnswerURI | varchar (255) | True | Depends on customer usage | Path and filename of the recorded comment for free-form questions. (See the following Explanation of FreeFormAnswerURI.) |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| EventDate | datetime (8) | False | No | UTC Date and time of when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SurveyAnswerId | char (32) | False | No | ID of the survey answer. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| SurveyFormID | raw (16) | False | No | ID of the survey form this answer belongs to. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| SurveyQuestionId | char (32) | False | No | ID of the question given for this answer |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| NumericScore | number (22) | True | No | Score given to this answer. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| EnumSequence | number (22) | True | No | For true/false or multiple choice questions this is the value of EnumSequence in the SurveyQuestionEnum table that contains the possible answers to the question. Numbering starts at zero. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| FreeFormAnswerURI | varchar2 (255) | True | Depends on customer usage | Path and filename of the recorded comment for free-form questions. (See the following Explanation of FreeFormAnswerURI.) |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |
| EventDate | date (7) | False | No | UTC Date and time of when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyAnswer table. |