V_EHI_HQA_QUEST_ANSWER

Description: |
This view converts the QUEST_ANSWER column in CL_QANSWER_QA into an external-facing format for EHI Export. This table should be used in tandem with CL_QANSWER_QA, using the ANSWER_ID and LINE columns to join the two together.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ANSWER_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ANSWER_ID | VARCHAR | No |
The unique ID of the questionnaire answer record.
2 | LINE | INTEGER | No |
Line count of the answers in the questionnaire record.
3 | QUEST_ANSWER_EXTERNAL | VARCHAR | No |
The actual answer to the question as it was seen by the answering user. This value is converted to an external format depending on the question response type (I LQL 110). For category values, this column will contain the category title. For all other value types, the value matches what is stored in CL_QANSWER_QA__QUEST_ANSWER.