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
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 PCA_TOTAL_DOSE_FLO_ID VARCHAR No
The unique identifier of the flowsheet row record storing the total dose row of the order's linked PCA assessments. If the order is not for a PCA or it does not have a linked PCA assessment configured, the value will be null. A flowsheet row is a documentation tool used to track a specific piece of information over time.
28 PCA_TOTAL_DOSE_FLO_ID_DISP_NAME VARCHAR No
The display name given to the flowsheet group/row.
29 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
30 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
31 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.
32 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
33 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
34 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.
35 PAUSE_START_DTTM DATETIME (Local) No
The start instant for the pause period of a medication order.
36 PAUSE_END_DTTM DATETIME (Local) No
The end instant for the pause period of a medication order.
37 PREVIOUS_INR_DATE DATETIME No
The date of the patient's last INR assessment.
38 NEXT_INR_DATE DATETIME No
The next date on which a patient's international normalized ratio (INR) should be assessed.
39 USER_SEL_ORDER_TEMPLATE_OTL_ID_ORDER_DESC VARCHAR No
Description of the procedure.
40 DISP_RECPNT_NAME VARCHAR No
This item holds the recipient name for the dispatch request.
41 DISP_RECPNT_CITY VARCHAR No
This item holds the city for this dispatch request.
42 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
43 DISP_RECPNT_ZIP VARCHAR No
This item holds the zip code for this dispatch request.
44 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
45 DISP_RECPNT_HOUSE VARCHAR No
This item holds the house number for this dispatch request.
46 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
47 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
48 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
49 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
50 HH_BAG_START_DATE DATETIME No
The start date of a home health medication prepacked in a bag.
51 HH_BAG_END_DATE DATETIME No
The end date of a home health medication prepacked in a bag.
52 HH_PILL_START_DATE DATETIME No
The start date of a home health medication dispensed in a pill box.
53 HH_PILL_END_DATE DATETIME No
The end date of a home health medication dispensed in a pill box.
54 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
55 DISCON_PAT_ENC_DATE_REAL NUMERIC No
The encounter or visit in which the medication was discontinued.
56 UNIQUE_ORDER_IDENTIFIER VARCHAR No
Order identifier that is unique for all deployments
57 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