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