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 identifierord_id

The unique alphanumeric key assigned to a clinical service request within EHR, laboratory, pharmacy, or radiology systems. Used as the primary linkage key across CPOE, LIS, RIS, and pharmacy dispensing platforms to track order lifecycle from entry through fulfillment and billing reconciliation.

order indexord_idx

The sequential position number assigned to a clinical service request within a grouped order set, care plan, or batch transmission in EHR and claims systems. Used to preserve ordering logic, resolve processing sequence conflicts, and maintain referential integrity in HL7 ORM message segments.

order indicatorord_ind

A boolean or coded flag denoting a specific condition state of a clinical service request in EHR and pharmacy systems, such as whether an order is electronically signed, requires cosignature, is protocol-driven, or has been electronically transmitted to a downstream fulfillment system.

order instructionord_instr

Free-text or coded guidance associated with a clinical service request that conveys administration, collection, or execution details to fulfilling departments in EHR systems such as Epic and Cerner. Mapped to HL7 OBR and NTE segments for transmission to pharmacy, lab, and nursing workflows.

order keyord_key

The unique surrogate or natural key value that identifies a specific clinical order record within the healthcare data system. Used as the primary join attribute when linking order data across clinical, billing, and operational tables in data warehouses and analytical reporting environments.

order labelord_lbl

The human-readable display name or descriptive text assigned to a clinical order, used to identify the order in clinical interfaces, printed requisitions, and patient-facing documentation. Derived from the order catalog and may differ from the underlying order code or internal system identifier.

order languageord_lang

The preferred spoken or written language of the patient associated with a clinical order, captured to support communication and informed consent requirements. Used to trigger translation services, language-appropriate patient instructions, and compliance with federal language access mandates during care delivery.

order last nameord_last_nm

The patient's family surname as recorded on a clinical order at the time of order entry. Used for patient matching, order attribution, and verification workflows to ensure orders are correctly associated with the intended patient record in EHR and laboratory systems.

order legal nameord_legal_nm

The patient's full legal name as recorded on a clinical order, used for identity verification, consent documentation, and regulatory compliance. Distinguishes from preferred or display names in systems where patients may have aliases, ensuring accurate attribution for medical and legal records.

order levelord_lvl

The hierarchical classification assigned to a clinical service request within a structured order set or care pathway in EHR systems, indicating whether the order is a parent protocol, child task, conditional branch, or standalone entry that governs downstream order dependency and processing logic.

order license numberord_lic_nbr

The professional state license number of the clinician who entered or authorized a clinical order. Used to validate ordering authority, support credentialing verification, and meet regulatory requirements for orders requiring a licensed provider signature or DEA-controlled substance compliance.

order marital statusord_mar_sts

The marital or domestic partnership status of the patient at the time a clinical order is placed. Used in clinical documentation and demographic profiling, and may influence insurance coordination of benefits determinations when secondary payer coverage is linked to a spouse or domestic partner.

order master identifierord_mstr_id

The enterprise master patient index or master order identifier that uniquely identifies a clinical order across multiple systems and facilities. Used for cross-system order reconciliation, duplicate detection, and longitudinal tracking of orders throughout the care continuum in integrated health networks.

order maximumord_max

The upper allowable threshold value defined for a clinical order parameter, such as maximum dose, maximum frequency, or maximum quantity. Used in clinical decision support rules to prevent unsafe order entry and in pharmacy dispensing systems to enforce dosing limits and regulatory caps.

order middle nameord_mid_nm

The patient's middle name or initial as recorded on a clinical order, used to enhance patient identity matching accuracy. Particularly important in large health systems where first and last name combinations alone may be insufficient to uniquely distinguish patients during order verification and specimen labeling.

order minimumord_min

The lower allowable threshold value defined for a clinical order parameter, such as minimum dose, minimum frequency, or minimum quantity dispensed. Used in clinical decision support to flag subtherapeutic orders and in pharmacy management systems to enforce evidence-based dosing floor requirements.

order mobileord_mob

The mobile phone number of the patient or responsible party associated with a clinical order, used for appointment reminders, order status notifications, and result delivery communications. Supports patient engagement workflows and telehealth coordination linked to the specific order encounter.

order modified byord_mod_by

The system username or user identifier of the clinician, staff member, or automated process that last modified a clinical order record. Used in audit trail documentation to track order changes, support compliance reviews, and identify accountability for amendments made after initial order entry.

order modified dateord_mod_dt

The timestamp recording the most recent update to a clinical service request in EHR or pharmacy systems, capturing edits to dose, frequency, route, or status. Critical for audit trail compliance, concurrency conflict resolution, and incremental data extraction in ETL pipelines feeding clinical data warehouses.

order modified timeord_mod_tm

The date and timestamp recording when a clinical order record was last updated or amended in the healthcare system. Used in audit logging, version control, and workflow management to track the sequence of changes to an order and ensure data integrity across integrated clinical and billing systems.

PreviousPage 471 of 806Next