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 rateord_rt

The unit price or reimbursement value assigned to a clinical service request in EHR, charge capture, and claims systems. Used to calculate expected charges for procedures, medications, and supplies, and is reconciled against fee schedules, contract rates, and PBM pricing tables during claim adjudication and revenue cycle processing.

order ratingord_rtg

A scored or categorical assessment value assigned to a clinical order, which may reflect urgency level, quality measure compliance, or clinician-assigned priority. Used in clinical decision support and operational reporting to triage order queues and evaluate ordering patterns across care settings.

order ratioord_ratio

A calculated proportional value associated with a clinical order, such as a drug concentration ratio, dosage-to-weight ratio, or test result ratio. Used in pharmacy, laboratory, and clinical documentation contexts to standardize dosing calculations and support safe order verification workflows.

order reasonord_rsn

The coded or free-text explanation documenting the clinical justification for a service request in EHR and prior authorization systems, such as diagnosis codes, medical necessity criteria, or formulary exception rationale. Required for prior authorization submissions, appeals documentation, and medical necessity validation in claims adjudication workflows.

order received dateord_rcvd_dt

The date on which a clinical order was received by the fulfilling department, pharmacy, or ancillary service. Used to calculate order turnaround time, measure departmental throughput, support service level agreement tracking, and identify delays between order placement and receipt.

order referenceord_ref

An external identifier or pointer linking a clinical order to related records such as referrals, authorizations, lab requisitions, or external system transactions. Used in EHR integration layers and claims systems to maintain cross-system traceability across Epic, Cerner, payer platforms, and health information exchanges.

order resolution dateord_resol_dt

The date on which a clinical order was closed, completed, canceled, or otherwise resolved within the order management system. Used to calculate order lifecycle duration, support audit trails, and facilitate reporting on outstanding versus fulfilled orders across clinical departments.

order respirationord_resp

The patient's respiratory rate in breaths per minute documented at the time of a clinical order. Captured as a vital sign within the order record to reflect baseline pulmonary status and inform clinical decisions for respiratory treatments, anesthesia planning, or medication administration orders.

order resultord_rslt

The clinical outcome or returned value from a fulfilled order, including lab results, imaging findings, or medication dispensing confirmations in EHR and LIS systems. Stored in OBX segments of HL7 messages and mapped to result tables in data warehouses for quality reporting and clinical decision support workflows.

order revisionord_rev

A numeric or sequential identifier indicating which version or modification iteration a clinical order represents. Used in order management systems to track changes made after initial order entry, maintain audit history, and ensure the most current order version is fulfilled and billed correctly.

order riskord_rsk

A clinician- or system-assigned risk level associated with a clinical order, reflecting patient safety concerns, drug interaction severity, or procedural complication potential. Used in clinical decision support to trigger alerts, require secondary approval, or flag high-risk orders for pharmacist or physician review.

order routeord_rte

The designated administration pathway specified in a clinical order, such as oral, intravenous, intramuscular, or topical. Critical in pharmacy and nursing workflows to ensure safe and accurate medication or treatment delivery, and used in clinical data systems to support medication reconciliation and adverse event tracking.

order scoreord_scr

A calculated numeric rating assigned to a clinical order, reflecting acuity, priority, risk stratification, or decision support scoring logic within EHR and clinical analytics platforms. Used in systems like Epic and Cerner to drive order prioritization, triage workflows, and population health scoring models in data pipelines.

order sequenceord_seq

A numeric value defining the position or processing order of a clinical order within a series of related orders, order sets, or care protocols in EHR and CPOE systems. Used in data pipelines to preserve ordering logic, dependency resolution, and workflow execution order across Epic, Cerner, and clinical data warehouses.

order severityord_sev

A coded or descriptive indicator of the clinical urgency or seriousness associated with a clinical order, such as STAT, urgent, or routine designations in CPOE and EHR systems. Used in triage workflows, HL7 priority fields, and clinical data warehouses to drive escalation logic and care pathway prioritization across Epic and Cerner.

order sexord_sex

The patient's biological sex recorded in association with a clinical order, used to apply sex-specific clinical decision rules, reference ranges, and dosing protocols. Supports order validation logic in EHR systems and is required for regulatory reporting and population health stratification in clinical datasets.

order sourceord_src

The originating system, provider, department, or interface through which a clinical order was entered or transmitted into the EHR or order management system. Used in data lineage tracking, audit logging, and interoperability pipelines to identify whether orders originated from CPOE, HIE, fax intake, or external provider portals.

order start dateord_start_dt

The date on which a clinical order is initiated or scheduled to begin execution within EHR, pharmacy, or care management systems. Used in data warehouses to calculate order duration, align with authorization start dates, and support longitudinal care analysis across Epic, Cerner, PBM, and claims adjudication platforms.

order start timeord_start_tm

The timestamp indicating when execution of a clinical order was initiated, such as when a medication infusion began or a procedure commenced. Used in clinical documentation, nursing administration records, and operational analytics to measure order-to-start intervals and support patient safety event investigations.

order stateord_st

The U.S. state or territory associated with the location where a clinical order was placed or where the ordering provider holds licensure. Used in regulatory compliance, cross-state telehealth credentialing, and geographic reporting to ensure orders meet jurisdiction-specific scope-of-practice and licensure requirements.

PreviousPage 473 of 806Next