ORDER_MED_7

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 (.1 item) for the order record.
2	MED_DOSAGE_END_DATE	DATETIME	No
	Stores the calculated end date of the order when using the wide end date feature
3	FIRST_DOSE_EDU_PATIENT_CSN_ID	NUMERIC	No
	The unique contact serial number of the patient encounter associated with first-dose education.
4	PENDED_PREV_SIG	VARCHAR	No
	For a pended medication order, this holds the contents (if any) of the "Sig (Previous)" display item from the order composer. If populated, this is the sig (ORD 7055) of the source order at the time the reorder was created.
5	DOSE_ADJ_ACCEPTED_YN	VARCHAR	No
	Stores whether the dose adjustment is accepted. May contain organization-specific values: No Category Entries: No Yes
6	MED_DOSE_CALCULATION_DESC	VARCHAR	No
	Stores medication dose override dose programming point calculation.
7	NUM_DOSES_TO_SCHED	INTEGER	No
	Stores the number of doses that should actually be scheduled after reconciling a pre-existing OP order into an encounter which schedules OP meds
8	DO_NOT_SCHED_PAST_DATE	DATETIME	No
	Stores the last date on which it is OK to schedule an OP order that has been reconciled into an encounter that schedules OP meds
9	SCHED_FROM_PERIOD	INTEGER	No
	Stores the period to start scheduling from for an OP order that has been reconciled into an encounter that schedules OP meds
10	SCHED_FROM_PERIOD_DURATION	INTEGER	No
	Stores the remaning number of days in the period to start scheduling from for an OP order that has been reconciled into an encounter that schedules OP meds
11	SEND_TO_PHARM_REASON_C_NAME	VARCHAR	No
	Reasons for sending a prescription directly to a pharmacy. For Australia e-prescribing. May contain organization-specific values: Yes Category Entries: Provided to Patient Dosing Point Staged Supply Repeats Kept on File
12	RX_MOBILE_NUM	VARCHAR	No
	Patient's mobile phone number. For Australia e-prescribing.
13	MED_PROV_ORDER_ID	NUMERIC	No
	Links to the shadow order containing provisional verify data
14	TAPER_TRIMMING_INCOMPLETE_C_NAME	VARCHAR	No
	Set to Yes if the taper trimming UI's decision hasn't been made yet May contain organization-specific values: No Category Entries: Yes
15	STARTED_TAKING_DATE	DATETIME	No
	The date the patient reports they started taking a medication
16	RX_REQ_SUBTYPE_C_NAME	VARCHAR	No
	This item specifies the subtype of the external change request this order represents. It is only set on orders created by external pharmacies, and is used in conjunction with ORD 7499. May contain organization-specific values: Yes Category Entries: Site Verification Notification Unverified Site Reminder Deactivated User/Provider Notification Initiate Patient Outreach Encounter Anticoagulation Enrollment Anticoagulation Update Communications Chart Review CC'd Charts Ad Hoc Bed Planning Page Order not released, PA complete Waiting for PA, no recent updates Generic Diagnosis E-Prescribing Cancel Response Call Pharmacy New INR Edited INR Subsequent INR Coverage PCP Change Review FMK Refill Request FMK Message Notice Care Team Message Infection Notification Case Audit Message Return to OR Encounter After Schedule Encounter After Check-In Encounter After Check-Out Encounter After Cancel Encounter After Cancel Check-In/Out Admission Discharge HOV Confirm Preadmission ED Arrival ED Dismiss LD Assessment LD Newborn Admission Undo Admission Undo Discharge HOV Cancel Undo Preadmission New Managed Access Patient Lab Result - Abnormal Lab Result - Normal Close Encounter ED Discharge Undo ED Dismiss Undo ED Discharge Undo ED Arrival Encounter Addendum Signed Note Signed Note Addendum Signed Note Deleted Study Signed Study Edited Study Canceled Imaging Result Other Result Encounter After No-Show Transfer to Inpatient Undo Transfer to Inpatient Referral Authorized Referral Denied Remittance Advice Received Referral Appointment Scheduled Referral Appointment Canceled Referral Appointment No-Show Premium Billing Invoice Received Patient Deceased Patient Not Deceased Referral Triage Info Request Unsigned Plan Orders Deviation Request Home Care - Close Visit Validation Kanta Renewal Request Therapy Plan Scheduling Failure Referral Created Referral Note Added Procedure-Allergy Interaction message Deferred Medication Warning Therapy Plan Expiration Therapy Plan Order Expiration Therapy Plan Inactive Orders Study Version Updated Plan Not Updated RxRenewalRequest - Patient Error RxRenewalRequest - Med Error RxRenewalRequest - Other Error RxChange-Equivalent Medication Requested RxChange-No Medication Requested RxChange - DEA License Status in Prescribing State RxChange - DEA Class RxChange - DEA License Status/Class NewRxRequest - Other Error NewRxRequest NewRxRequest - Patient Error NewRxRequest - Med Error Plan Hold Retracted incoming referral message Retracted outgoing referral message Rejected Direct Message CE Referrals Scheduling Errors CE Referrals Update Message CE Incoming Reject Message CE Referral Conflict Message Anticoagulation Enroll Error CE Referral Disconnect Message Order Sign Notification Release Request Upcoming Unused OR Time Release Notification Block Message E-Prescribing Cancel Response Follow Up Needed Utilization Notification - Error OR Time Available Block Hold Notification CE Referral Appointment Review Waitlist Block Request Multidose - Pharmacy Questions Multidose - Change Multidose - Registration Multidose - Failed PLL Update Multidose - New Responsible Provider Community Resource Broadcast Message New Account Broadcast Message Upcoming Unused Responsible Block Block Request MedCom Treatment Complete Treatment Resumed Death Notification Discharge Report Epikrise Municipal Care Report Municipal Summary of Care Report SLV Application Refused Outpatient Visit from External Hospital CCSC Selection Notification Order Not Collected Medication Management Research Study Message KoGu status update Insurer inquiry Round Table - Reviewer Assignment Round Table - Owner Update - Reviewer Waiting Round Table - Owner Update - All Approved Round Table - Owner Update - New Review Period Appointment Notification - Multiple Genomic Indicator Added Genomic Variant OPA Multi Patient Message Error Patient Information Update Request Patient Preferences Update Request Patient History Questionnaire Submission Patient General Questionnaire Submission Patient Insurance Update Request Patient Questionnaire Series Submission Patient Questionnaire Submission CC Administrator WPR Merge - UnMerge Status Patient Submitted Data Failed Validation Notification Patient Entered Flowsheet Notification Patient Clinical Update Notification Proxy Access Level Transition Error Patient Admin Login Alert Patient Unviewed Labs Notification Patient Unread Message Notification Patient Screening With Questionnaire Submission Patient-Entered COVID-19 Vaccination COVID-19 Vaccination Reconciliation Request MyChart Blocked Lab Notification
17	RESCARE_REORDER_C_NAME	VARCHAR	No
	Response to a question that a user is shown when reordering or modifying an outpatient order while the patient is admitted to a residential care facility. May contain organization-specific values: No Category Entries: Start After Original Order Ends Discontinue Original and Start Now Discontinue Original and Specify Start Date Prompt Shown But No Response Default Start After Original Order Ends
18	DISCRETE_SIG_SOURCE_C_NAME	VARCHAR	No
	The discrete sig source category ID for the order. May contain organization-specific values: No Category Entries: Codified Sig Copied from Source Order Sig Mapping Table
19	MED_ORIG_DOSAGE_END_DATE	DATETIME	No
	Stores the original dosage end date for a medication order when using the wide end date feature if it was changed after the order was signed
20	SCHED_FIRST_DOSE_DTTM	DATETIME (Local)	No
	Stores the date and time that the first dose in an admission should be scheduled
21	LAST_REFILL_REQUEST_UTC_DTTM	DATETIME (UTC)	No
	The datetime of when the patient last requested a refill for this medication order through MyChart. Used to determine when another refill can be requested for medications filled through non-integrated pharmacies.
22	SCHEDULE_PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number of the Patient contact for when Low Acuity scheduling information is saved to an order (SI 34570).
23	SOURCE_SCHED_IN_PAT_ENC_CSN_ID	NUMERIC	No
	The unique contact serial number for the low-acuity admission contact if the source order is schedulable in that admission when the current order is signed or released. This number is unique across all patient encounters in your system. If you use IntraConnect, this is the Unique Contact Identifier (UCI).
24	SCHEDULE_USING_METHOD_C_NAME	VARCHAR	No
	The schedule using method category ID for the order. This determines how the medication should schedule administration due times in an encounter that supports scheduling outpatient medications on the MAR. May contain organization-specific values: No Category Entries: Remaining Doses Stop Taking On Date Until Discontinued
25	NEED_INTAKE_SCHED_YN	VARCHAR	No
	Stores whether the medication needs intake to be scheduled, even if it was ordered directly on the low acuity encounter. The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
26	RX_WRITTEN_UTC_DTTM	DATETIME (UTC)	No
	The UTC instant of when the prescription was written
27	REMAINING_DOSES_BEFORE_INTAKE	INTEGER	No
	The system will track the number of doses remaining for the order prior to the most recent intake into a low acuity medication management encounter.
28	MED_CHG_REPLACE_YN	VARCHAR	No
	Flag to determine if I ORD 7088 - Med change reorder ID is actually a replacement ID. The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
29	USES_TOD_IN_PAT_SIG_C_NAME	VARCHAR	No
	If the patient sig contains time of day indicators like "morning", "noon", "evening", or "bedtime". 1 if yes it does, and I ORD 7661 will contain which times are included. 2 if no it doesn't, and that was determined either from an unsupported frequency or explicitly marking "no" when placing the composer. Null if the order was placed prior to this item, and therefore it isn't known. May contain organization-specific values: No Category Entries: Times of Day are used in Patient Sig No Times of Day are used in Patient Sig
30	TREATMENT_IDENT	VARCHAR	No
	ID to track the treamtent group associated with this medication order.
31	DISPENSE_REQUEST_IDENT	VARCHAR	No
	ID to track dispense request associated with this medication order.
32	ADDL_WISH_MEDICATION_C_NAME	VARCHAR	No
	The additional wishes selection for the medication roll. Currently only used by the Netherlands. May contain organization-specific values: No Category Entries: Bewust hoge dosering Bewust lage dosering Bewust afwijkende toedieningsweg Medische Noodzaak Profylaxe Per direct Per rolwissel Bewust afwijken van leeftijdsdgrenzen Bewust van een te lage nierfunctie Bewust van eerder gemelde overgevoeligheid
33	ADDL_WISH_DELIVER_YN	VARCHAR	No
	The additional wishes selection for deliver. Currently only used by the Netherlands. The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
34	ERX_DISP_QTY_SUFFICIENT_YN	VARCHAR	No
	Whether or not a medication is to be dispensed as Quantity Sufficient. The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN