ODC_BASIC
Description:
The ODC_BASIC table contains the basic information for the order context record. These include record status, logical/physical owner, record type, status, etc.

Primary Key
Column Name Ordinal Position
ORDER_CONTEXT_ID 1

Column Information
Name Type Discontinued?
1 ORDER_CONTEXT_ID NUMERIC No
The unique identifier for the order context record, which contains information about when orders are intended to be used.
2 ODC_RECORD_TYPE_C_NAME VARCHAR No
The type category number for the order context record.
May contain organization-specific values: No
Category Entries:
User created context
Surgical/Invasive
Procedure order context
3 ODC_STATUS_C_NAME VARCHAR No
The status category number for the order context record.
May contain organization-specific values: No
Category Entries:
Active
Active-Completed
Auto-Completed
Expired
Canceled
4 ODC_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.
5 PAT_VISIT_CSN NUMERIC No
This item stores the contact serial number (CSN) of the visit that the order context is linked to.
6 HOLDING_REASON_C_NAME VARCHAR No
The pend reason category ID for the order context record, which indicates the reason the record was created.
May contain organization-specific values: Yes
7 LAST_ORDER_ADDED_DT DATETIME No
The most recent date when an order was associated with the order context record.
8 LAST_ORDER_RLSD_DT DATETIME No
The most recent date when an order associated with this order context record was activated.
9 OVERRIDE_START_DT DATETIME No
The date the original surgical visit associated with this order context record was cancelled.
10 INACTIVE_DT DATETIME No
The date the context record was set to an inactive status.