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 statusord_sts

A coded value representing the current processing state of a clinical order, such as pending, active, completed, cancelled, or on-hold, within EHR and CPOE systems. Mapped from HL7 ORC-5 fields and tracked in order management tables to support workflow automation, audit compliance, and clinical reporting in Epic and Cerner environments.

order strengthord_str

The drug concentration or potency specified in a medication order, such as 500mg or 10mg/mL. Used in pharmacy and clinical systems to ensure accurate dispensing and administration, supporting dose verification and medication safety workflows across inpatient and outpatient settings.

order subtotalord_subtot

The partial cost or quantity sum associated with a clinical service order prior to applying taxes, adjustments, or additional charges. Used in revenue cycle and order management systems to calculate intermediate billing amounts before finalizing charges on a patient account or claim.

order surgery dateord_surg_dt

The scheduled or actual date on which a surgical procedure linked to a clinical order is performed. Used in perioperative and surgical scheduling systems to coordinate pre-operative orders, anesthesia planning, and post-operative care timelines for inpatient and outpatient surgical encounters.

order targetord_tgt

The intended recipient, department, system, or clinical destination to which a clinical order is directed, such as a lab, pharmacy, radiology unit, or external provider. Used in EHR routing logic, interface engine configurations, and data warehouse schemas to trace order fulfillment pathways across Epic, Cerner, and ancillary systems.

order taxonomy codeord_tax_cd

The NUCC Health Care Provider Taxonomy code assigned to a clinical order, identifying the ordering provider's specialty or subspecialty classification. Used in claims processing and order routing to ensure services are directed to appropriately credentialed clinicians and to support payer adjudication rules.

order temperatureord_temp

The body temperature measurement recorded as part of a clinical order or vital signs assessment, typically expressed in degrees Fahrenheit or Celsius. Used in clinical monitoring workflows to flag abnormal values, trigger nursing interventions, and document baseline patient status during care delivery.

order termination dateord_term_dt

The date on which a clinical service order is discontinued, expired, or formally ended. Used in order management and medication administration systems to prevent execution of outdated orders, support audit trails, and ensure care teams are acting on current, valid clinical instructions.

order timeord_tm

The time-of-day component at which a clinical order was entered, scheduled, or transmitted within EHR and CPOE systems, typically stored separately from or combined with the order date. Used in conjunction with order timestamps for SLA measurement, STAT order tracking, and shift-level analytics in clinical data warehouses and HL7 messaging pipelines.

order timestampord_ts

The combined date and time value recording when a clinical order was created, modified, transmitted, or fulfilled within EHR and order management systems. Stored as a datetime field in clinical data warehouses and HL7 ORC/OBR segments, used for audit trails, latency measurement, and temporal sequencing across Epic, Cerner, and LIS platforms.

order titleord_ttl

The formal name or descriptive label assigned to a clinical service order, identifying the procedure, medication, or service being requested. Used in clinical documentation and workflow systems to display standardized order names to care team members across ordering, fulfillment, and reporting processes.

order totalord_tot

The aggregated numeric value representing the total quantity, cost, or unit count associated with a clinical order, such as total medication units dispensed or total charges for a service order. Used in pharmacy, revenue cycle, and claims data systems to support billing reconciliation, PBM adjudication, and utilization reporting workflows.

order total countord_tot_cnt

The aggregate number of individual line items, doses, or service instances included within a clinical order or order set. Used in pharmacy dispensing, procedure scheduling, and order management systems to track fulfillment completion and ensure all components of a multi-part order are processed.

order typeord_typ

A classification code identifying the category of a clinical order, such as laboratory, medication, radiology, referral, or procedure, within EHR and CPOE systems. Mapped from HL7 ORC/OBR segments and used in data warehouse schemas to partition order workflows, drive routing logic, and support clinical analytics across Epic and Cerner platforms.

order updated dateord_upd_dt

The most recent date on which a clinical service order was modified, amended, or corrected in the system of record. Used in order management audit logs and clinical data warehouses to track order change history, support compliance reviews, and identify discrepancies between original and modified order details.

order urgencyord_urg

The priority or time-sensitivity classification assigned to a clinical order, such as STAT, urgent, or routine. Used in clinical workflow and order routing systems to determine fulfillment sequence, alert care teams to time-critical needs, and support triage decisions across diagnostic, pharmacy, and procedural departments.

order versionord_ver

The sequential version number assigned to a clinical order record each time it is modified or reissued, enabling tracking of order revisions over time. Used in clinical data warehouses and audit systems to distinguish the most current order iteration from prior versions and maintain a complete change history.

order zipord_zip

The postal ZIP code associated with the location where a clinical order is placed, fulfilled, or delivered, such as a clinic, pharmacy, or patient address. Used in healthcare operations and analytics to support geographic reporting, delivery logistics, and site-of-service tracking across distributed care settings.

organization admission dateorg_admn_dt

The date on which a patient was formally admitted to a healthcare organization, such as a hospital or skilled nursing facility. Used in inpatient encounter records and claims processing to establish the start of a covered stay, calculate length of stay, and support utilization management reporting.

organization discharge dateorg_dsch_dt

The date on which a patient was formally released from a healthcare organization following an inpatient or residential stay. Used in encounter records and claims systems to mark the end of a covered admission, calculate length of stay, and trigger post-discharge care coordination and billing processes.

PreviousPage 474 of 806Next