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.