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.