It returns detailed data from end-user satisfaction surveys associated with ASMS suite cases, consolidating response and rating data within the DataWarehouse environment.
Fields
| Field | Type | Description |
|---|---|---|
| change_survey_answered | INT | Indicates exchange rate cases with completed survey |
| creation_date | DATETIME | Date when the survey invitation is registered |
| creation_date_sk | INT | Survey Invitation Record Dimension Identifier |
| id | INT | Case ID |
| incident_survey_answered | INT | Indicates incident type cases with completed survey |
| invitation_sent_email | INT | Indicates whether the invitation has already been sent or not (0 has not been sent, 1 has been sent) to the end user |
| question_sk | INT | Unique identifier of the question |
| question_type_sk | INT | Identifier of the type of question it represents |
| rating | INT | Value of the rating per question given by the user in the survey |
| response_date | DATETIME | Survey Response Date |
| response_date_sk | INT | Survey response dimension identifier |
| service_call_survey_answered | INT | Indicates the cases of the request type with answered survey |
| survey_answered | INT | Indicates the cases whose survey was answered by the user |
| survey_rating_max | INT | Indicates surveys with the maximum possible score set |
| survey_rating_min | INT | Indicates surveys with the minimum rating |
| survey_sent* | INT | Indicates the cases to which a survey was sent |
| survey_sk* | INT | Identifier of the survey template associated with the invitation |
| survey_unanswered | INT | Indicates cases with survey sent but not answered |