mdatool
Healthcare Data Dictionary for the Modern Data Stack
LibraryBlogPricing
mdatool
mdatool

The healthcare data dictionary for dbt, Snowflake, Databricks, and BigQuery. 100,000+ ISO-11179 standard terms, free SQL tools, and AI data modeling.

HIPAA-AlignedEnterprise Ready

Tools

  • SQL Linter
  • DDL Converter
  • Bulk Sanitizer
  • Naming Auditor
  • Name Generator
  • AI Data Modeling
  • HCC Calculator
  • Data Model Canvas

Library

  • Glossary
  • Guides
  • Blog

Company

  • About
  • Contact
  • Pricing

Account

  • Sign Up Free
  • Sign In
  • Upgrade to Pro
  • Dashboard

Legal

  • Privacy Policy
  • Terms of Service

© 2026 mdatool. All rights reserved.

Built for healthcare data teams.

Back to Glossary

Domain

Clinical

EHR, ICD-10, LOINC, SNOMED CT, patient care and clinical documentation

16,101 clinical terms

order durationord_dur

The prescribed length of time over which a clinical order remains active or a treatment is intended to be administered. Used in medication management, therapy scheduling, and care plan workflows to define the total course of treatment and determine when orders should automatically expire or require renewal.

order emailord_eml

The electronic mail address associated with a clinical order, used to route notifications, results, and referral communications in EHR and care coordination platforms. Captured in order management tables to support provider contact resolution, audit trails, and interoperability workflows in systems like Epic and Cerner.

order emergency indicatorord_emerg_ind

A flag designating a clinical order as emergent, requiring immediate prioritization over routine requests. Used in laboratory, radiology, and pharmacy workflows to route STAT orders to the front of processing queues, trigger urgent notifications, and ensure rapid turnaround in time-critical patient care situations.

order end dateord_end_dt

The date on which a clinical order is scheduled to conclude or is administratively closed within EHR, pharmacy, or CPOE systems. Critical for determining order duration, medication stop dates, and authorization expiration in claims and utilization management workflows across Epic, Cerner, and PBM platforms.

order end timeord_end_tm

The timestamp marking when a clinical service request was completed, discontinued, or expired. Used in clinical analytics and workflow management to calculate order turnaround times, evaluate service delivery performance, and establish the closing boundary for time-sensitive procedures, infusions, or monitoring orders.

order entered byord_ent_by

The identifier of the clinical staff member who physically entered the order into the EHR system, which may differ from the ordering or authorizing clinician. Used to distinguish data entry personnel from prescribers in verbal or telephone order workflows, supporting accountability and audit trail documentation requirements.

order ethnicityord_ethn

The ethnicity of the patient associated with a clinical order, captured to support population health analysis, health equity reporting, and clinical research. Used alongside race data to identify disparities in care delivery, meet federal reporting requirements, and inform culturally appropriate clinical decision-making.

order expiration dateord_exp_dt

The date after which a clinical service request is no longer valid for fulfillment. Used in EHR order management systems (Epic, Cerner) to enforce time-limited orders such as PRN medications, lab panels, and imaging requests, triggering workflow alerts when orders lapse without completion.

order external identifierord_ext_id

A reference identifier assigned by an external system, such as a reference laboratory, radiology information system, or trading partner, used to cross-reference a clinical order across multiple platforms. Enables accurate result matching, status reconciliation, and interoperability between the originating EHR and external fulfillment systems.

order faxord_fax

The facsimile number associated with the destination or originating party of a clinical order transmission, such as an external pharmacy, specialist office, or referring facility. Used to route paper-based or electronic fax transmissions of orders, referrals, or prescriptions when direct system integration is unavailable.

order feeord_fee

The charge amount associated with a clinical service request, representing the cost billed to the patient, payer, or responsible party for the ordered service. Used in revenue cycle management to link clinical orders to billing records, enabling accurate charge capture, claims generation, and financial reporting.

order first nameord_first_nm

The given name of the patient or individual associated with a clinical order, used to confirm patient identity during order processing and result reporting. Critical for patient matching workflows in EHR systems to prevent mislabeling errors and ensure accurate association of orders with the correct patient record.

order flagord_flg

A binary or coded status marker applied to a clinical service request in EHR and pharmacy systems to indicate special conditions such as STAT priority, pending authorization, duplicate detection, or clinical decision support alerts requiring provider acknowledgment before processing.

order frequencyord_freq

The prescribed administration schedule for a clinical order, specifying how often a medication, treatment, or monitoring task should occur, such as daily, twice daily, or every eight hours. Used in pharmacy dispensing, nursing task scheduling, and medication administration record workflows to ensure timely and accurate care delivery.

order full nameord_full_nm

The complete name of the patient or clinician associated with a clinical order, combining given and family name components into a single displayable value. Used in order review interfaces, printed requisitions, and result reports to provide unambiguous human-readable identification for clinical and administrative processing purposes.

order genderord_gndr

The biological sex or gender identity of the patient associated with a clinical order, captured at the time of order entry. Used in diagnostic and treatment orders where biological sex influences reference ranges, dosing calculations, or clinical decision support rules.

order glucoseord_gluc

The blood glucose measurement recorded in association with a clinical order, typically captured during pre-procedure assessment or medication management. Used in orders for insulin administration, anesthesia, or diabetes-related diagnostics to establish baseline or threshold values.

order group numberord_grp_nbr

The insurance group policy number associated with a clinical order at the time of order entry, used to link the order to the patient's coverage plan. Supports billing workflows, prior authorization, and claims adjudication by identifying the correct payer group contract.

order hemoglobinord_hgb

The hemoglobin level recorded in association with a clinical order, typically captured during pre-operative screening or transfusion threshold assessment. Used to determine clinical eligibility for procedures, blood product orders, or anemia management treatment protocols.

order history present illnessord_hpi

The structured narrative describing the onset, duration, and progression of the patient's current condition as documented at the time of a clinical order. Provides clinical context for the ordering clinician's decision and supports medical necessity documentation for downstream billing and coding.

PreviousPage 470 of 806Next