OCS_CODE_STATUS

Description: |
This table contains information about patient code statuses, which are mainly used for documenting compliance reasons and quality. This table replaces the older IP_CODE_STATUS table.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
OCS_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | OCS_ID | VARCHAR | No |
The unique ID for the code status record.
2 | OCS_NAME | VARCHAR | No |
The name of the code status record.
3 | OCS_STATUS_C_NAME | VARCHAR | No |
This stores the status of the record (hidden, soft deleted, etc.)
May contain organization-specific values: No
Category Entries:
Soft Deleted
Hidden
Hidden and Soft Deleted
4 | CODE_STATUS_C_NAME | VARCHAR | No |
Code status category value.
May contain organization-specific values: Yes
Category Entries:
<Disabled>
Full Code
DNR
Partial Code
5 | ACTIVATED_INST | DATETIME (Local) | No |
The instant at which the code status (full code, DNR, etc.) was created.
6 | USER_ID | VARCHAR | No |
The unique identifier of the user that created the code status
7 | USER_ID_NAME | VARCHAR | No |
The name of the user record. This name may be hidden.
8 | ORDER_ID | NUMERIC | No |
The unique identifier for the code status order record.
9 | COMMENTS | VARCHAR | No |
The comment associated with the code status.
10 | INACTIVATED_INST | DATETIME (Local) | No |
The instant at which the code status was inactivated.
11 | CONTEXT_C_NAME | VARCHAR | No |
The context (inpatient/ambulatory/etc.) in which the status was recorded.
May contain organization-specific values: No
Category Entries:
Outpatient
Inpatient
HOV
ED
Surgery
Demographics
Home Health
Hospice
12 | PATIENT_ID | VARCHAR | No |
The patient for which this code status was recorded.
13 | PATIENT_CSN | NUMERIC | No |
The Contact Serial Number of the encounter in which the code status order was placed.
14 | ACTV_UTC_DTTM | DATETIME (UTC) | No |
Holds the instant the code status was activated in UTC time.
15 | INACTV_UTC_DTTM | DATETIME (UTC) | No |
The instant at which the code status was inactivated in UTC time.
16 | VERBAL_ORDER_ID | VARCHAR | No |
The unique identifier of the home care order that created this code status record.