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 nameord_nm

The human-readable display label assigned to a clinical service request in EHR and CPOE systems such as Epic and Cerner, representing the orderable item name as presented in provider workflows. Maps to catalog entries in order master tables and is used for reporting, analytics, and claims crosswalk validation.

order noteord_nt

A structured or free-text annotation attached to a clinical service request in EHR systems, capturing provider comments, clinical context, or special handling instructions not captured in coded fields. Transmitted in HL7 NTE segments to pharmacy, laboratory, and radiology fulfillment systems for execution guidance.

order numberord_nbr

The human-readable reference number assigned to a clinical service request within EHR, pharmacy, or laboratory systems, distinct from the internal order identifier. Used for provider communication, patient-facing documentation, downstream system cross-referencing, and claim attachment linkage in billing workflows.

order onset dateord_onset_dt

The date on which the patient's symptoms or condition first began, as documented in association with a clinical order. Used to establish medical necessity, support diagnosis coding, and inform clinical decision-making for time-sensitive treatment orders such as antibiotics, stroke protocols, or urgent referrals.

order oxygen saturationord_o2sat

The peripheral oxygen saturation (SpO2) percentage recorded at the time of a clinical order, typically measured via pulse oximetry. Used in EHR order records to document patient respiratory status and support clinical decision-making for oxygen therapy or respiratory interventions.

order paid amountord_pd_amt

The actual dollar amount remitted by a payer or patient against a clinical service order, reflecting post-adjudication payment. Used in revenue cycle workflows to reconcile ordered services against reimbursement received and identify underpayments or billing discrepancies.

order paid dateord_pd_dt

The calendar date on which payment was applied to a clinical service order by a payer or patient. Used in revenue cycle and accounts receivable tracking to calculate days-to-payment, monitor cash flow, and support denial management and financial reporting workflows.

order parentord_prnt

The identifier or reference linking a subordinate clinical service request to its originating parent order within hierarchical order sets in EHR systems. Used to enforce dependency logic, manage conditional order execution, and maintain relational integrity between compound protocol orders and their component child tasks.

order percentageord_pct

A ratio value expressed as a percentage associated with a clinical service request, used in EHR and pharmacy systems to define dose calculations based on body weight or surface area, compounding formula ratios, or formulary compliance rates tracked in PBM and pharmacy benefit reporting datasets.

order periodord_prd

The defined time duration over which a clinical service request remains active and executable in EHR and pharmacy systems, encompassing start-to-stop intervals for medication courses, treatment schedules, and recurring lab panels. Used to drive refill logic in pharmacy systems and care gap analysis in population health platforms.

order phoneord_ph

The telephone number associated with a clinical service request in EHR and referral management systems, identifying the contact number for the ordering provider, ordering facility, or authorizing entity. Used in prior authorization workflows, DME orders, and external referral transmissions requiring callback verification.

order preferred nameord_pref_nm

The clinician- or system-designated display label for a clinical order, often a standardized or facility-specific name used in lieu of a catalog code. Ensures consistent order identification across clinical workflows, patient-facing documents, and reporting within EHR and order management systems.

order priceord_prc

The established charge or list price assigned to a clinical service order before adjustments, discounts, or contractual allowances are applied. Used in revenue cycle management to initiate billing, calculate expected reimbursement, and support cost analysis and chargemaster maintenance.

order primary indicatorord_prim_ind

A flag identifying whether a clinical order is designated as the primary order among multiple related or duplicate orders for the same service. Used in order management systems to prioritize processing, support accurate billing, and prevent duplicate fulfillment or reimbursement submissions.

order priorityord_prty

The coded ranking assigned to a clinical service request in EHR and laboratory systems indicating urgency of fulfillment, such as STAT, ASAP, routine, or timed. Drives queue sequencing in LIS, RIS, and pharmacy dispensing systems, and is mapped to HL7 OBR-27 priority fields in downstream integrations.

order procedure dateord_proc_dt

The date on which the clinical procedure or service associated with an order was actually performed. Critical for claims submission, coding accuracy, and compliance with payer timely filing requirements, and used to align ordered services with encounter-level clinical and billing records.

order pulseord_pulse

The patient's heart rate in beats per minute captured at the time of a clinical order entry. Recorded as a vital sign within the order record to document baseline cardiovascular status, support clinical decision rules, and provide context for medication or procedure orders.

order quantityord_qty

The numeric count or volume value specifying the amount of a drug, supply, or service requested in a clinical order within EHR, pharmacy, and DME systems. Used to drive dispensing calculations, inventory deduction, and claim unit-of-service reporting, and must align with NDC package quantities in PBM adjudication.

order raceord_race

The patient's self-reported or clinician-recorded racial classification associated with a clinical order record. Used to support health equity reporting, population health analytics, and regulatory compliance with federal mandates requiring race data collection in clinical and claims datasets.

order rangeord_rng

The defined minimum and maximum value boundaries associated with a clinical service request in EHR systems, applied to dose range validation for weight-based medication orders, lab result reference intervals, or acceptable quantity limits enforced during CPOE entry and pharmacy verification workflows.

PreviousPage 472 of 806Next