VDEX Survey Form
A view comprised of the SurveyForm table and the SurveyDetail table.
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SurveyFormId | uniqueidentifier (16) | False | No | ID of the survey form. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| SurveyID | varchar (32) | False | No | ID of the survey that was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| CallIdKey | varchar (20) | False | No | Full 18 digit call ID key of the interaction. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| SurveyedIntxId | varchar (32) | True | Yes | ID of the individual who took this survey. Links to the Individual table. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| MaxScore | numeric (9) | True | No | Maximum score that could be received when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| MinScore | numeric (9) | True | No | Minimum score that could be received when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| Score | numeric (9) | True | No | Actual score received. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| IsComplete | int (4) | False | No | 1 if the survey was completed, else 0. Other values are not defined. See SurveyDetail.EventCode for more information about why the survey was not completed. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| RankName | nvarchar (40) | True | Depends on customer usage | Name of the rank given to this survey result. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| Duration | int (4) | True | No | Duration, in seconds, of the time it took to complete the survey. |
17.4.0.0 | Added for data extraction from SurveyForm 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 SurveyForm table. |
| Column | Data Type (Size) | Is Nullable | Contains PII | Description | Last Change Version | Last Change Reason |
|---|---|---|---|---|---|---|
| SurveyFormId | raw (16) | False | No | ID of the survey form. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| SurveyID | char (32) | False | No | ID of the survey that was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| CallIdKey | varchar2 (20) | False | No | Full 18 digit call ID key of the interaction. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| SurveyedIntxId | varchar2 (32) | True | Yes | ID of the individual who took this survey. Links to the Individual table. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| MaxScore | number (22) | True | No | Maximum score that could be received when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| MinScore | number (22) | True | No | Minimum score that could be received when the survey was taken. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| Score | number (22) | True | No | Actual score received. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| IsComplete | number (22) | False | No | 1 if the survey was completed, else 0. Other values are not defined. See SurveyDetail.EventCode for more information about why the survey was not completed. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| RankName | varchar2 (80) | True | Depends on customer usage | Name of the rank given to this survey result. |
17.4.0.0 | Added for data extraction from SurveyForm table. |
| Duration | number (22) | True | No | Duration, in seconds, of the time it took to complete the survey. |
17.4.0.0 | Added for data extraction from SurveyForm 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 SurveyForm table. |