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.