CL_QANSWER_QNR_PROGRESS

Description:

The CL_QANSWER_QNR_PROGRESS table contains information about the steps a user took while navigating a questionnaire as they provided answers. This information includes the questionnaires they've seen and the pages they've visited.

Primary Key

Column Name	Ordinal Position
ANSWER_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ANSWER_ID	VARCHAR	No
	This column stores the unique identifier for the answer record.
2	LINE	INTEGER	No
	The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3	FORM_CSN_ID	NUMERIC	No
	Stores what questionnaire form was shown to the patient at this point in their audit history.
4	FORM_PAGE	INTEGER	No
	Stores what page of the corresponding questionnaire was shown to the patient at this point in their audit history.
5	IN_PROGRESS_FORM_ID	VARCHAR	No
	Stores the record ID for the questionnaire that was shown to the patient at this point in their audit history.
6	IN_PROGRESS_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
7	IN_PROGRESS_CONTACT_DATE_REAL	NUMERIC	No
	Stores the contact date (DAT) for the questionnaire that was shown to the patient at this point in their audit history.
8	FORM_ANSWER_ID	VARCHAR	No
	Stores the answer corresponding to the questionnaire that was shown to the patient at this point in their audit history.
9	COMPLD_FORM_LOCALE	VARCHAR	No
	Stores the locale subscript of the compiled questionnaire record that was shown to the patient at this point in their audit history. This only applies if a language override was triggered.