ISOLATIONS

Description: |
This table contains patient isolation data.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ISOLATION_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ISOLATION_ID | NUMERIC | No |
The unique identifier for the isolation record.
2 | RECORD_STATUS_2_C_NAME | VARCHAR | No |
The record status category ID for the isolation.
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
3 | PAT_ID | VARCHAR | No |
The unique ID of the patient record for this row. This column is frequently used to link to the PATIENT table.
4 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for the contact in which this isolation took place. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
5 | ISOLATION_C_NAME | VARCHAR | No |
The isolation type category ID for the isolation.
May contain organization-specific values: Yes
6 | ISOLATION_STATUS_C_NAME | VARCHAR | No |
The isolation status category ID for the isolation.
May contain organization-specific values: No
Category Entries:
Active
Removed
Deleted
Encounter Ended
7 | HOW_ISO_ADDED_C_NAME | VARCHAR | No |
The How Isolation Was Added category ID for the isolation.
May contain organization-specific values: No
Category Entries:
User
Import
Interface
Conversion
Automatic (ADT Rules)
Isolation Order
8 | ISOLATION_ORDER_ID | NUMERIC | No |
The unique identifier of the order that added the isolation.
9 | ADDED_UTC_DTTM | DATETIME (UTC) | No |
The UTC date and time when the isolation was added.
10 | ADDED_USER_ID | VARCHAR | No |
The unique ID associated with the user record for the user who added this isolation. This column is frequently used to link to the CLARITY_EMP table.
11 | ADDED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
12 | REMOVED_UTC_DTTM | DATETIME (UTC) | No |
The UTC date and time when the isolation was removed.
13 | REMOVED_USER_ID | VARCHAR | No |
The unique ID associated with the user record for the user who removed this isolation. This column is frequently used to link to the CLARITY_EMP table.
14 | REMOVED_USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
15 | COMMENTS | VARCHAR | No |
The user-entered comments associated with the isolation
16 | RECORD_CREATION_DATE | DATETIME | No |
The date when the isolation record was created.
17 | ADDED_LOCAL_DTTM | DATETIME (Attached) | No |
Local instant when isolation was added.
18 | REMOVED_LOCAL_DTTM | DATETIME (Attached) | No |
Local instant when isolation was removed.
19 | INFECTION_LINKS_CALCULATED_YN | VARCHAR | No |
Indicates whether all linked infections have been calculated. 'Y' indicates all linked infections have been calculated. 'N' or NULL indicates that there may be infections that would be considered linked to the isolation, but that the isolation pre-dates the linking calculation.
May contain organization-specific values: No
Category Entries:
No
Yes