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.