PAT_GROUP

Description:

The PAT_GROUP table contains information about patient groups. This table will hold groups used for scheduling as well as groups used for clinical documentation.

Primary Key

Column Name	Ordinal Position
PAT_GROUP_ID	1

Column Information

	Name	Type	Discontinued?
1	PAT_GROUP_ID	NUMERIC	No
	The unique ID of the patient group record.
2	RECORD_STATUS_C_NAME	VARCHAR	No
	This item stores the record status of the group record. May contain organization-specific values: No Category Entries: Active Inactive Deleted Inactive and Deleted Hidden Inactive and Hidden Deleted and Hidden Inactive Deleted and Hidden
3	PAT_GROUP_TYPE_C_NAME	VARCHAR	No
	This item defines the type of GRP record and whether or not this record stores a list of EPT IDs or a list of EPT CSNs. May contain organization-specific values: No Category Entries: Scheduling Group Clinical Scheduled Group Episode Group
4	CONTACT_LIST_TYPE_C_NAME	VARCHAR	No
	This item describes the type of group that is being documented by clinical users. May contain organization-specific values: Yes
5	GROUP_START_UTC_DTTM	DATETIME (UTC)	No
	This item stores the instant that a group was started.
6	GROUP_END_UTC_DTTM	DATETIME (UTC)	No
	This item stores the instant when a group ended.
7	CREATED_BY_USER_ID	VARCHAR	No
	This item stores the user ID for the user that created a group.
8	CREATED_BY_USER_ID_NAME	VARCHAR	No
	The name of the user record. This name may be hidden.
9	GROUP_DEPARTMENT_ID_EXTERNAL_NAME	VARCHAR	No
	The external name of the department record. This is often used in patient correspondence such as reminder letters.