OUTREACH_PAT_QUESRS

Description:

This table stores patient questionnaire tasks linked to an outreach tasks, and the answers to the questionnaires.

Primary Key

Column Name	Ordinal Position
ACTIVITY_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	ACTIVITY_ID	VARCHAR	No
	The unique identifier (.1 item) for the task 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	PAT_QUESTIONNAIRE_FORM_ID	VARCHAR	No
	For outreach tasks, this item stores any patient questionnaires linked to this outreach.
4	PAT_QUESTIONNAIRE_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
5	PAT_QUESTIONNAIRE_ANSWER_ID	VARCHAR	No
	The patient's answers to the questionnaire sent in the linked task. This may be an in progress response if the linked task is not completed.
6	PAT_QUESTIONNAIRE_ORDER_ID	NUMERIC	No
	The order record related to the questionnaire, if any.
7	PAT_QUESTIONNAIRE_START_DATE	DATETIME	No
	The date the questionnaire is to be available to be answered by the patient.