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
Owing Script
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 Multidose List Update
Multidose - New Responsible Provider
Community Resource Broadcast Message
New Account Broadcast Message
Upcoming Unused Responsible Block
Multidose - Send Updated Multidose List
Block Request
MedCom
Case Replacement Suggestions Message
Case Replacement Suggestions Daily Digest
Reservation Overbooked
Commission Statement Received
Site Admin Approval New Account Broadcast Message
ePA Communication
Validate Barcodes
Purchase Request
Automatic Package Build Validation
Treatment Complete
Treatment Resumed
Death Notification
Discharge Report
Epikrise
Municipal Care Report
Municipal Summary of Care Report
DMP Application Refused
Outpatient Visit from External Hospital
CCSC Selection Notification
Order Not Collected
HH Discharge or Transfer Summary
Medication Therapy Management
Research Study Message
Research Prospect Interest
Posttherapy Stage Unsigned
Peer Review - Reviewer Assigned
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
Round Table - Builder Update
Round Table - Owner Update - Builder Completed
Round Table - Comment Mention
General Study Message
Budget Study Message
Study Activation
Study Status
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
MyChart Blocked Lab Notification WMG
Preference Card Suggestion Review
Preference Card Suggestion Review Completion
Preference Card Change Request
Compass Rose Visit Set Request Failed
Compass Rose Episode Creation Failed
Compass Rose Episode Update Failed
Compass Rose Task Update Failed
Credentialing Account Request
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
35 | ERX_INP_WITH_LTC_YN | VARCHAR | No |
Whether or not an Inpatient e-prescribed order was signed with long-term care specific features enabled for the order. This does not include orders which used old long-term care e-prescribing.
The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
36 | ORG_RX_QS_YN | VARCHAR | No |
Original Quantity Sufficient status.
The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
37 | MEDICATION_ACCESS_REFERRAL_ID | NUMERIC | No |
The referral record used to request medication access.
38 | AUTO_ORD_REC_STATUS_C_NAME | VARCHAR | No |
The category ID indicating whether this order was created via automatic order reconciliation and whether it needs review, has been reviewed, or has otherwise been acted on.
May contain organization-specific values: No
Category Entries:
Automatically continued
Automatically continued, no review needed
Reviewed
Modified
Discontinued
Held
39 | OMT_ORDER_YN | VARCHAR | No |
Only used in Norway currently. The term used in Norway for this treatment is 'LAR'. This item stores Yes if the order is for such treatment.
The category values for this column were already listed for column: DOSE_ADJ_ACCEPTED_YN
40 | FUTURE_MODIFY_STATE_C_NAME | VARCHAR | No |
If a future modify was signed, then this will contain the future modify state category ID for the order.
May contain organization-specific values: Yes
Category Entries:
Select a Time
After Current Dose
41 | FUTURE_MODIFY_LOCAL_DTTM | DATETIME (Local) | No |
If a future modify was signed, then this will contain the date of the future modify. Can be empty for pended and not yet signed orders.
42 | AUTO_SCHED_CSN_ID | NUMERIC | No |
Stores the low-acuity encounter where the medication is auto-scheduled based on department-level configurations.