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 commentord_cmt

Free-text notation entered by a clinician or staff member on a clinical service request in EHR and order management systems, providing supplemental instructions or clinical context. Used to communicate special handling requirements, clarify order intent, and support audit trails in care coordination workflows.

order completed dateord_cmpl_dt

Captures the calendar date on which a clinical order was fully fulfilled and results or outcomes were finalized, such as a lab result released or a procedure performed. Used to calculate order turnaround times, measure departmental throughput, and support compliance reporting against clinical service level agreements.

order confidential indicatorord_conf_ind

Flag indicating whether a clinical order contains sensitive or restricted information requiring limited access, such as behavioral health, substance abuse, or HIV-related services. When set, this restricts visibility in EHR systems to authorized clinicians only, supporting HIPAA privacy compliance.

order contactord_cntct

The designated communication point, such as a provider, department, or phone number, associated with a clinical service request in EHR and order management systems. Used to route inquiries, facilitate result delivery, and ensure accountability for order follow-through in care coordination workflows.

order countord_cnt

The total number of clinical service requests associated with a patient, encounter, or time period, aggregated in EHR and analytics systems. Used to measure provider ordering patterns, support utilization management reporting, and identify outliers in diagnostic or therapeutic ordering behavior.

order countryord_ctry

The country associated with a clinical service request, used to identify the geographic jurisdiction governing the order. Relevant for international patient encounters, cross-border care coordination, and ensuring compliance with country-specific clinical and regulatory documentation standards in EHR systems.

order created byord_crtd_by

The unique identifier of the user who originally created the clinical order in the EHR or clinical information system. Used for audit trail purposes, accountability tracking, and distinguishing the order creator from the authorizing clinician or order entry personnel in clinical workflows.

order created dateord_crtd_dt

The timestamp recording when a clinical service request was initially entered into an EHR or order management system. Used to establish order timelines, measure turnaround times, support audit trails, and calculate lag between order creation and execution in clinical operations analytics.

order created timeord_crtd_tm

The exact timestamp recorded when a clinical service request was first entered into the system. Used in audit trails, order management workflows, and turnaround time analysis to establish when the ordering process began and to sequence events within a patient encounter timeline.

order creatinineord_cr

The serum or urine creatinine value documented at the time of a clinical order, used to assess renal function and guide dosing decisions for renally-cleared medications or contrast-requiring imaging. Critical for nephrology, pharmacy, and radiology workflows where kidney function impacts treatment safety.

order dateord_dt

The calendar date on which a clinical service request was placed in an EHR or order management system, representing the intended date of the order. Used to sequence clinical events, validate claims service dates, and support longitudinal patient timeline analysis across care episodes.

order datetimeord_dttm

The combined date and time stamp recording when a clinical service request was placed in EHR or CPOE systems. Used by data engineers to sequence workflow events, calculate order-to-fulfillment latency, and audit clinical decision timelines across inpatient and outpatient encounters.

order dea numberord_dea_nbr

The Drug Enforcement Administration registration number of the prescribing clinician associated with a controlled substance order. Required by federal law for Schedule II-V medication orders, this identifier is used to validate prescriber authority and maintain regulatory compliance in pharmacy dispensing systems.

order death dateord_death_dt

The recorded date of patient death associated with a clinical service request in EHR or claims systems. Used by data engineers to flag posthumous orders, trigger claim adjudication rules, and support mortality analytics within hospital and payer data pipelines.

order deleted dateord_del_dt

The date on which a clinical service request was marked as deleted or removed from the active order list in the EHR. Used in audit trails and data reconciliation to track when orders were discontinued, ensuring accurate historical records and supporting regulatory compliance reviews.

order deleted indicatorord_del_ind

A flag identifying whether a clinical order has been logically removed from the active order set without permanent physical deletion from the database. Enables systems to retain a complete audit history while excluding voided or cancelled orders from active clinical views and downstream reporting workflows.

order descriptionord_desc

The free-text or structured label describing a clinical service request in EHR, CPOE, or laboratory systems. Used by data engineers to map orders to standard code sets such as LOINC or CPT, support NLP pipelines, and enable order categorization across clinical data warehouses.

order detailord_dtl

Granular supplemental information attached to a clinical service request in EHR or pharmacy systems, including dosage, frequency, or specimen instructions. Used by data engineers to parse order line-level attributes for clinical analytics, pharmacy adjudication, and care coordination workflows.

order discharge dateord_dsch_dt

The date a patient was released from a facility in relation to a specific clinical service request in EHR or claims systems. Used by data engineers to calculate length of stay, validate episode boundaries, and reconcile inpatient order timelines against UB-04 claim discharge dates.

order due dateord_due_dt

The target date by which a clinical service request is expected to be completed, collected, or fulfilled. Used in laboratory, radiology, and procedural workflows to prioritize pending orders, manage scheduling queues, and trigger alerts when clinical tasks are approaching or past their required completion timeframe.

PreviousPage 469 of 806Next