EXT_MED_BARCODE
Description:
This table contains information about accepted barcodes for medication orders from external sources. These barcodes are all valid for barcoded medication administration (BCMA).

Primary Key
Column Name Ordinal Position
ORDER_ID 1
LINE 2

Column Information
Name Type Discontinued?
1 ORDER_ID NUMERIC No
The unique identifier (.1 item) for the order record.
2 LINE INTEGER No
The line number for the information associated with this record. Multiple pieces of information can be associated with this record.
3 EXT_MED_BARCODE_IDENT VARCHAR No
The barcode IDs for the medication order from an external source (e.g., from an external pharmacy through RxFill messages).
4 DISP_SOURCE_CONTACT_DATE_REAL FLOAT No
A unique contact date in decimal format. The integer portion of the number indicates the date of contact. The digits after the decimal distinguish different contacts on the same date and are unique for each contact on that date. For example, .00 is the first/only contact, .01 is the second contact, etc. This is the contact date for the dispense on the order that sent over this external medication barcode. If empty, the dispense that sent over this external medication barcode is on a previous order.
5 EXT_BARCODE_SOURCE_C_NAME VARCHAR No
Stores the source category of this external barcode.
May contain organization-specific values: Yes
Category Entries:
RxFill dispense message
Copied from previous order
6 EXT_BARCODE_SOURCE_ORDER_ID NUMERIC No
Stores the source order ID if this external barcode is copied from another order.
7 EXT_BARCODE_ADDED_USER_ID VARCHAR No
Stores the user that added this barcode to the order.
8 EXT_BARCODE_ADDED_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
9 EXT_BARCODE_ADDED_UTC_DTTM DATETIME (UTC) No
Stores the UTC instant when this external barcode is added to the order.
10 EXT_BARCODE_BEFORE_REMOVED VARCHAR No
Stores the original external barcode if it has been removed from the order.
11 EXT_BARCODE_REMOVE_RSN_C_NAME VARCHAR No
Stores the reason of removal if this external barcode has been removed from the order.
May contain organization-specific values: Yes
Category Entries:
Revert order equivalence confirmation
Order modified or reordered
12 EXT_BARCODE_REMOVE_USER_ID VARCHAR No
Stores the user that removed this external barcode from the order.
13 EXT_BARCODE_REMOVE_USER_ID_NAME VARCHAR No
The name of the user record. This name may be hidden.
14 EXT_BARCODE_REMOVE_UTC_DTTM DATETIME (UTC) No
Stores the UTC instant when this external barcode is removed from the order.