EPT_OR_PAT_SURG_PREORD

Description: |
This table stores data for all of a patient's pre-ordered specimens.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
PAT_ENC_CSN_ID | 1 |
LINE | 2 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | PAT_ENC_CSN_ID | NUMERIC | No |
The unique contact serial number for this contact. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
2 | LINE | INTEGER | No |
The line number for the information associated with this contact. Multiple pieces of information can be associated with this contact.
3 | ORD_SPEC_PREORDER_ID | NUMERIC | No |
Stores pre-existing, releasable specimen orders.
4 | ORD_SPEC_PREORD_COLLECT_C_NAME | VARCHAR | No |
Stores whether or not related specimen orders were collected.
May contain organization-specific values: No
Category Entries:
Collected
Not Collected
No Status Documented
5 | ORD_SPEC_PREORD_NC | VARCHAR | No |
Stores comments for specimen pre-orders that have been documented as "Not Collected" in EPT 88401.
6 | ORD_SPEC_PREORD_IB_MSG_ID | VARCHAR | No |
Stores the In Basket message ID for required pre-order specimens that has not been collected.
7 | ORD_SPEC_FL_LPP_ID | NUMERIC | No |
Search extension ID that the related order failed, even though it was still shown in the Specimens section
8 | ORD_SPEC_FL_LPP_ID_LPP_NAME | VARCHAR | No |
The name of the extension.