ORDER_MED_8
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_MED_ID 1

Column Information
Name Type Discontinued?
1 ORDER_MED_ID NUMERIC No
The unique identifier (.1 item) for the order record.
2 PA_PRIORITY_C_NAME VARCHAR No
The prior authorization priority category ID for the prior authorization request of medication prescription order.
May contain organization-specific values: No
Category Entries:
Standard
Unknown
Urgent
3 STOP_REASON_C_NAME VARCHAR No
The reason for the continuum stop
May contain organization-specific values: Yes
4 STOP_COMMENT VARCHAR No
The comment for the continuum stop
5 PRESCRIPTION_TYPE_CODE_C_NAME NUMERIC No
The code that identify the prescriber type, form type, and prescriber initiative.
May contain organization-specific values: Yes
No Entries Defined
6 UK_SIGNING_PROVIDER_ROLE VARCHAR No
The role ID of the provider from the UK NHS system when they signed this medication.
7 UK_CANCELLING_PROVIDER_ROLE VARCHAR No
The role ID of the provider from the UK NHS system when they cancelled this medication.
8 ALLOW_DOSE_CHANGE_YN VARCHAR No
Flag that indicates this medication can have its dosage changed by other clinical users.
May contain organization-specific values: No
Category Entries:
No
Yes
9 UK_TRIG_PROV_ROLE VARCHAR No
The role ID of the provider from the UK NHS system when they trigger NHS signing of this medication. This could be different than the signing user UK provider role (I ORD 20415) in some workflows, such as a pharmacist verifying the order after making edits.
10 RX_EMAIL_ADDRESS VARCHAR No
Patient email address associated with the prescription.
11 RADIOPHARM_TRACKING_NUMBER_STR VARCHAR No
The order tracking number used in radiopharmaceutical manufacturing and radiopharmacy portals.
12 RADIOPHARM_EXPECTED_TREAT_DATE DATETIME No
The date that the radiopharmaceutical manufacturer intends for the drug to be administered.
13 SIC_REASON_C_NAME NUMERIC No
Reason for the SIC marking
May contain organization-specific values: Yes
No Entries Defined
14 SIC_COMMENT VARCHAR No
SIC Comment
15 UK_AUTHORIZING_PROVIDER_ROLE VARCHAR No
The role ID of the authorizing provider from the UK NHS system when they signed this medication.
16 IP_ERX_DISABLED_YN VARCHAR No
Specifies whether an inpatient or long-term-care e-prescribing order was signed with e-prescribing disabled for this order even though its department is set up for IP e-prescribing (e.g., disabled by a rule build).
The category values for this column were already listed for column: ALLOW_DOSE_CHANGE_YN
17 EXT_RENEW_SERV_AREA_ID_LOC_NAME VARCHAR No
The name of the revenue location.
18 ORIG_ORDERING_DATE DATETIME No
An original ordering date for the order