CASE_SUMM_QUEST

Description:

The CASE_SUMM_QUEST table allows you to report on questionnaires (not contact-specific) in Tapestry's Chronic Disease Case Management module.

Primary Key

Column Name	Ordinal Position
CASE_ID	1
LINE	2

Column Information

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