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.