PAT_GROUP_CLINICAL

Description:

This table contains clinical information specific to patients that attended a given group therapy session.

Primary Key

Column Name	Ordinal Position
PAT_GROUP_ID	1
LINE	2

Column Information

	Name	Type	Discontinued?
1	PAT_GROUP_ID	NUMERIC	No
	The unique identifier (.1 item) for the group 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	LIST_OF_CONTACTS	NUMERIC	No
	This column stores the list of patient contacts for the group.
4	CSN_DOC_DONE_YN	VARCHAR	No
	This item determines if the documentation for a given contact in a group is complete. May contain organization-specific values: No Category Entries: No Yes
5	GENERATED_NOTE_ID	VARCHAR	No
	This item stores the ID of each patient's individual note for the group session. These notes are generated by the system.
6	LINKED_PAT_ID	VARCHAR	No
	This item stores the patient ID for each patient for the group session.
7	LINKED_EPISODE_ID	NUMERIC	No
	This item stores the ID of each patient's linked episode for the group session.
8	GROUP_ATTENDANCE_STAT_C_NAME	VARCHAR	No
	The group attendance category ID for a patient's attendance in a group session. This item stores whether a patient was absent, partially absent, or fully attended a group session. May contain organization-specific values: No Category Entries: Attended Partially Attended Absent
9	GROUP_ABSENCE_RSN_C_NAME	VARCHAR	No
	The category ID for the reason for a patient's absence or partial absence from a group session. May contain organization-specific values: Yes Category Entries: Asleep Declined Treatment Disruption Medical Other - Excused Other - Unexcused Patient Off Unit Transportation With Staff
10	ABSENCE_EXPLANATION	VARCHAR	No
	The patient's group attendance explanation by the user who recorded attendance.
11	ATTENDANCE_DUR	INTEGER	No
	The length of the patient's attendance in the group in minutes.