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.