|
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 |
|
|
