ORDER_MED_5

Description: |
This table enables you to report on medications ordered. This table should be used with ORDER_MED.

Primary Key

Column Name | Ordinal Position |
--- | --- | ---
ORDER_ID | 1 |

Column Information

| Name | Type | Discontinued? |
--- | --- | --- | --- | ---
1 | ORDER_ID | NUMERIC | No |
The unique identifier for the order record.
2 | FREE_TXT_SUP_PROV_NAME | VARCHAR | No |
This is the name of the supervising provider.
3 | FREE_TXT_SUP_PROV_IS_EXT_YN | VARCHAR | No |
This indicates whether the supervising provider comes from an external provider database.
May contain organization-specific values: No
Category Entries:
No
Yes
4 | FREE_TXT_SUP_PROV_DEA | VARCHAR | No |
This is the Drug Enforcement Administration (DEA) number of the supervising provider.
5 | FREE_TXT_SUP_PROV_NPI | VARCHAR | No |
This is the National Provider Identifier (NPI) of the supervising provider.
6 | FREE_TXT_SUP_PROV_PHONE | VARCHAR | No |
This is the phone number of the supervising provider.
7 | FREE_TXT_SUP_PROV_FAX | VARCHAR | No |
This is the fax number of the supervising provider.
8 | FREE_TXT_SUP_PROV_STREET | VARCHAR | No |
This is the street address of the supervising provider.
9 | FREE_TXT_SUP_PROV_CITY | VARCHAR | No |
This is the city of the supervising provider.
10 | FREE_TXT_SUP_PROV_STATE_C_NAME | VARCHAR | No |
This is the state of the supervising provider.
May contain organization-specific values: Yes
11 | FREE_TXT_SUP_PROV_ZIP | VARCHAR | No |
This is the zip code of the supervising provider.
12 | FREE_TXT_SUP_PROV_HOUSE | VARCHAR | No |
This is the house number of the supervising provider for medication instructions.
13 | FREE_TXT_SUP_PROV_DISTRICT_C_NAME | VARCHAR | No |
This is the district of the supervising provider.
May contain organization-specific values: Yes
14 | FREE_TXT_SUP_PROV_COUNTY_C_NAME | VARCHAR | No |
This is the county of the supervising provider.
May contain organization-specific values: Yes
15 | FREE_TXT_SUP_PROV_COUNTRY_C_NAME | VARCHAR | No |
This is the country of the supervising provider.
May contain organization-specific values: Yes
16 | MLSIG_SIGTYPE_C_NAME | VARCHAR | No |
The multiline sig type category ID for the order record, indicating the relationship between multiple sets of medication instructions, each defined for a discrete period of time. '1' or NULL indicates that the order record only has one set of medication instructions.
May contain organization-specific values: No
Category Entries:
SIMPLE
THEN
AND
THEN-AND
17 | HOME_HEALTH_DUE_COMMENT | VARCHAR | No |
The comments entered about the home health medication due time or the person responsible for home health medication administration.
18 | HH_RESP_PERS_C_NAME | VARCHAR | No |
The home health responsible person category ID for the order record, indicating the person responsible for administering the medication.
May contain organization-specific values: Yes
No Entries Defined
19 | BASE_MED_ORDER_ID | NUMERIC | No |
The unique identifier for the order record representing a multi-product prescription group, containing this order record and others which represent individual product prescriptions within the group.
20 | MULTI_PROD_IMS_YN | VARCHAR | No |
Indicates whether the order uses multi-product prescription ordering, which selects multiple products to reach the total ordered dose. 'Y' indicates that the medication uses multi-product prescription ordering. 'N' or NULL indicates that the medication uses single-product prescription ordering.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
21 | PA_DISP_OVERRIDE_YN | VARCHAR | No |
This item indicates if prior authorization should be shown or hidden for this order, regardless of whether other data indicates that PA is needed.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
22 | SELECTED_CRCL_SEX_C_NAME | VARCHAR | No |
The sex assigned at birth category ID for the patient sex used in creatinine clearance (CrCl) calculations.
May contain organization-specific values: Yes
Category Entries:
Female
Male
Unknown
Not recorded on birth certificate
Choose not to disclose
Uncertain
23 | RX_TYPE_C_NAME | VARCHAR | No |
Flag used to determine how this prescription should be sent to the Finland prescription center.
May contain organization-specific values: No
Category Entries:
Package
Total amount
Duration
No Dispensable Amount
24 | MED_PROVENANCE | VARCHAR | No |
This item stores provenance information about medications from external health record systems.
25 | PAIN_AGREEMENT_YN | VARCHAR | No |
Stores whether or not there is a pain agreement with the patient effective at the time the order was placed.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
26 | HOME_HEALTH_GIVE_PRN_YN | VARCHAR | No |
Indicates whether the home health medication should be given on an as-needed basis in addition to or in place of scheduled due times. 'Y' indicates that the medication should be given on an as-needed basis. 'N' or NULL indicates that the medication should only be given at scheduled due times.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
27 | NO_RENEW_REASON_C_NAME | VARCHAR | No |
The do not renew reason category ID for the order record.
May contain organization-specific values: No
Category Entries:
User Selected
Authorizing/Follow-up Provider Mismatch
After defaulting extension
28 | ORIG_RX_ORDER_CLASS_C_NAME | VARCHAR | No |
For prescription orders created by the interface, this item holds the order class that was assigned at the time the order was created.
May contain organization-specific values: Yes
Category Entries:
Normal
29 | ORDER_INST_UTC_DTTM | DATETIME (UTC) | No |
The date and time the order was placed in UTC. This is the same as the data in ORDER_MED.ORDER_INST, but in UTC.
30 | HH_NOT_DAILY_YN | VARCHAR | No |
Indicates whether a home health medication is not taken daily. 'Y' indicates that the home health medication is not taken daily. 'N' or NULL indicates that the home health medication is taken daily.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
31 | CONFIDENTIALITY_FLAG_C_NAME | VARCHAR | No |
The hide from proxies flag category ID for the order record, indicating whether the order should be hidden on medication lists shown to a patient's family or proxies.
May contain organization-specific values: No
Category Entries:
Not Hidden From Proxies
Hide From Patient Proxies
Patient Is Too Young To Decide
Cannot Determine Will Of Patient
32 | ORDERED_DAYS_SUPPLY_PER_FILL | INTEGER | No |
The calculated minimum days supply of the medication ordered. The value for this item is calculated when the order is signed, or when the order is edited by the pharmacy.
33 | PAUSE_START_DTTM | DATETIME (Local) | No |
The start instant for the pause period of a medication order.
34 | PAUSE_END_DTTM | DATETIME (Local) | No |
The end instant for the pause period of a medication order.
35 | PREVIOUS_INR_DATE | DATETIME | No |
The date of the patient's last INR assessment.
36 | NEXT_INR_DATE | DATETIME | No |
The next date on which a patient's international normalized ratio (INR) should be assessed.
37 | USER_SEL_ORDER_TEMPLATE_OTL_ID_ORDER_DESC | VARCHAR | No |
Description of the procedure.
38 | DISP_RECPNT_NAME | VARCHAR | No |
This item holds the recipient name for the dispatch request.
39 | DISP_RECPNT_CITY | VARCHAR | No |
This item holds the city for this dispatch request.
40 | DISP_RECPNT_STATE_C_NAME | VARCHAR | No |
This item holds the state for this dispatch request.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_STATE_C_NAME
41 | DISP_RECPNT_ZIP | VARCHAR | No |
This item holds the zip code for this dispatch request.
42 | DISP_RECPNT_COUNTRY_2_C_NAME | VARCHAR | No |
This item holds the country for this dispatch request.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_COUNTRY_C_NAME
43 | DISP_RECPNT_HOUSE | VARCHAR | No |
This item holds the house number for this dispatch request.
44 | DISP_RECPNT_COUNTY_2_C_NAME | VARCHAR | No |
This item holds the county for this dispatch request.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_COUNTY_C_NAME
45 | DISP_RECPNT_DISTRICT_C_NAME | VARCHAR | No |
This item holds the district for this dispatch request.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_DISTRICT_C_NAME
46 | HH_IN_BAG_YN | VARCHAR | No |
Indicates whether a home health medication was marked by a clinician as prepacked in a bag. 'Y' indicates that the medication was prepacked in a bag. 'N' or NULL indicates that the medication was not prepacked in a bag.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
47 | HH_IN_PILL_BOX_YN | VARCHAR | No |
Indicates whether a home health medication was marked by a clinician as dispensed in a pill box. 'Y' indicates that the medication was dispensed in a pill box. 'N' or NULL indicates that the medication was not dispensed in a pill box.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
48 | HH_BAG_START_DATE | DATETIME | No |
The start date of a home health medication prepacked in a bag.
49 | HH_BAG_END_DATE | DATETIME | No |
The end date of a home health medication prepacked in a bag.
50 | HH_PILL_START_DATE | DATETIME | No |
The start date of a home health medication dispensed in a pill box.
51 | HH_PILL_END_DATE | DATETIME | No |
The end date of a home health medication dispensed in a pill box.
52 | BRAND_SEL_RSN_C_NAME | VARCHAR | No |
The brand selected reason category ID for the order, indicating why the brand medication was selected. This column is blank if the brand product was selected because a user specified the medication should be dispensed as written.
May contain organization-specific values: No
Category Entries:
Generic Not Available
Payer Prefers Brand
53 | DISCON_PAT_ENC_DATE_REAL | NUMERIC | No |
The encounter or visit in which the medication was discontinued.
54 | UNIQUE_ORDER_IDENTIFIER | VARCHAR | No |
Order identifier that is unique for all deployments
55 | REC_W_MAP_ERX_YN | VARCHAR | No |
Flag that indicates if an ORD row was created in Reconcile Outside Information by a user manually choosing an ERX to match with an unmapped DXR prescription. 'Y' Indicates that an order was manually mapped by a user. 'N' indicates that the order was not manually mapped by a user. NULL indicates that the order was not created in Reconcile Outside Information or the item is not used in the current locale.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
56 | HH_OVERRIDE_DOSE_YN | VARCHAR | No |
Indicates whether the reported dose should be used instead of the prescribed dose for med administration in home health. 'Y' indicates that the reported dose should be used. 'N' or NULL indicates that the prescribed dose should be used.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
57 | HH_IN_BAG_REVIEWED_YN | VARCHAR | No |
Indicates if a clinician has acknowledged that the medication was removed from a prepacked bag. 'Y' indicates that the clinician has acknowledged the warning. 'N' or NULL indicates that the warning is not present or has not been acknowledged.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN
58 | HH_DUE_TIMES_REVIEWED_YN | VARCHAR | No |
Indicates if a clinician has acknowledged that the due times are correct. 'Y' indicates that the clinician has acknowledged the warning. 'N' or NULL indicates that the warning is not present or has not been acknowledged.
The category values for this column were already listed for column: FREE_TXT_SUP_PROV_IS_EXT_YN