CASE_CONT_QUEST

Description:

The CASE_CONT_QUEST table allows you to report on questionnaires for each contact in the Chronic Disease Case Management module.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
CONTACT_DATE_REAL	2
LINE	3

Column Information

	Name	Type	Discontinued?
1	CASE_ID	NUMERIC	No
	The unique ID for the case record.
2	CONTACT_DATE_REAL	FLOAT	No
	The contact date in decimal format.
3	LINE	INTEGER	No
	The line count of questionnaire information for the case record.
4	CONTACT_DATE	DATETIME	No
	The contact date in datetime format.
5	QUEST_FORM_ID	VARCHAR	No
	The unique ID of the questionnaire form.
6	QUEST_FORM_ID_FORM_NAME	VARCHAR	No
	The name of the form associated with the questionnaire.
7	QUEST_ANSWER_ID	VARCHAR	No
	The unique ID of the questionnaire answer.
8	QUEST_TIME	DATETIME (Local)	No
	The date and time of the questionnaire.
9	QUEST_USER_ID	VARCHAR	No
	The unique ID of the user associated with the questionnaire.
10	QUEST_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
11	QUEST_COMMENT	VARCHAR	No
	The comment of the questionnaire.