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.