QUESR_LST_ANS_INFO

Description:

This table stores information about the most recent patient questionnaire submission. This table stores when the questionnaire was last answered and the contact serial number for the encounter.

Primary Key

Column Name	Ordinal Position
PAT_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_ID	VARCHAR	No
	The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
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	QUESR_ANS_FORM_ID	VARCHAR	No
	This column stores recently answered questionnaire IDs. Use the QUESR_ANS_CSN_ID and QUESR_ANS_DDATETIME columns to determine the encounter and last submission instant for each questionnaire.
4	QUESR_ANS_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
5	QUESR_ANS_CSN_ID	NUMERIC	No
	This column stores the encounter contact serial number (CSN) for the most recent questionnaire submissions. Use the QUESR_ANS_FORM_ID and QUESR_ANS_CSN_ID columns to determine the form ID and encounter contact serial number for each questionnaire.
6	QUESR_ANS_DATETIME	DATETIME (Attached)	No
	This column stores the last instant of submission for questionnaires. Use the QUESR_ANS_FORM_ID and QUESR_ANS_CSN_ID columns to determine the form ID and encounter contact serial number for each questionnaire.