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.