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

diagnosis urgencydiag_urg

Indicates the clinical time-sensitivity or acuity level assigned to a diagnosed condition, such as emergent, urgent, or routine. Used in triage workflows, utilization management, and care coordination to prioritize patient interventions and ensure timely treatment for high-acuity conditions within clinical and care management systems.

diagnosis valuediag_val

The specific coded or numeric data point representing a diagnosis attribute within EHR, claims, or clinical registry systems, such as an ICD-10 code or a risk score output. Used by data engineers to populate diagnosis dimensions, validate coding completeness, and feed risk adjustment and quality measure calculation engines.

diagnosis versiondiag_ver

Tracks the sequential version number of a diagnosis record to support longitudinal change management, reflecting updates such as code refinements, clinical amendments, or status changes. Enables audit trail reconstruction and ensures data lineage accuracy across EHR problem lists, claims submissions, and clinical data warehouses.

diagnosis zipdiag_zip

Stores the postal ZIP code associated with the location where a diagnosis was rendered or the patient's residence at time of diagnosis. Used in public health surveillance, geographic disease prevalence analysis, and social determinants of health reporting to identify regional health patterns and disparities across populations.

directive active indicatordir_actv_ind

A binary flag indicating whether a patient care directive, such as a DNR order, advance directive, or treatment instruction, is currently in effect. Used in EHR and care management systems to ensure clinicians can quickly identify enforceable directives during care delivery, supporting patient safety and legal compliance.

directive active statusdir_actv_sts

Specifies the current operational state of a patient care directive, such as active, suspended, completed, or revoked. Distinct from a simple binary flag, this field supports nuanced workflow tracking across EHR and clinical systems, ensuring care teams apply only applicable directives during treatment and transitions of care.

directive admission datedir_admn_dt

Records the inpatient or facility admission date associated with the creation or activation of a patient care directive. Links the directive to a specific episode of care, enabling clinical and utilization management systems to apply appropriate care instructions within the correct inpatient encounter context.

directive agedir_age

Captures the patient's age at the time a care directive was created, modified, or activated. Used to validate age-based eligibility for certain directive types, support pediatric versus adult care protocols, and enable demographic analysis of advance care planning patterns across clinical and population health data systems.

directive allowed amountdir_alwd_amt

Represents the maximum reimbursable dollar amount associated with a billable care directive or clinical order. Used in claims adjudication and utilization management to apply contractual limits, payer fee schedules, or benefit plan constraints to services rendered under a specific patient directive or authorization.

directive amountdir_amt

Captures the monetary value assigned to a care directive transaction, such as the cost of ordered services, authorized spend, or estimated treatment cost. Used in financial tracking, prior authorization workflows, and care management budgeting to associate patient care instructions with their corresponding financial impact.

directive approved bydir_appr_by

Identifies the clinician, care manager, or authorized user who reviewed and approved a patient care directive such as a treatment plan, standing order, or advance directive. Supports accountability, audit trail documentation, and compliance requirements by recording the approving individual's identity within clinical workflow systems.

directive arrival timedir_arrv_tm

Records the time at which a patient arrived at a care setting when a directive was initiated or evaluated, such as an emergency department triage time or outpatient check-in time. Used to measure care timeliness, support directive activation workflows, and calculate throughput metrics in clinical operational reporting.

directive arrived datedir_arrv_dt

Captures the calendar date on which a patient physically arrived at a care facility in conjunction with a care directive event. Used to establish temporal context for directive activation, inpatient admission workflows, and longitudinal care episode tracking across clinical documentation and healthcare information systems.

directive assessmentdir_asmt

Contains the clinician's narrative or structured clinical evaluation associated with a patient care directive, documenting the clinical rationale, condition status, and reasoning that informed the directive's creation or modification. Supports care planning documentation, interdisciplinary communication, and clinical decision-making in EHR and care management systems.

directive balancedir_bal

The remaining unpaid amount associated with a clinical directive or patient care instruction order. Represents the difference between the billed amount and payments received, used in revenue cycle tracking to monitor outstanding directive-related financial obligations.

directive billed amountdir_bill_amt

The total charges invoiced for services or items associated with a clinical directive or patient care instruction. Captured during revenue cycle processing to record the gross billed value before adjustments, contractual discounts, or patient payments are applied to the directive.

directive birth datedir_birth_dt

The date of birth of the patient associated with a clinical directive or care instruction record. Used to verify patient identity, calculate age-appropriate dosing or treatment parameters, and support demographic validation when processing directive-related clinical orders.

directive blood pressuredir_bp

The systolic and diastolic arterial blood pressure reading recorded in association with a clinical directive or care instruction. Captured as a vital sign measurement to inform clinical decision-making, establish baselines, or satisfy preconditions required before executing the directive.

directive cancelled datedir_cncl_dt

The calendar date on which a clinical directive or patient care instruction was formally cancelled and removed from active workflow. Used in clinical order management to audit directive lifecycle events, track cancellation patterns, and maintain accurate order status histories.

directive categorydir_cat

The high-level classification grouping assigned to a clinical directive or patient care instruction, such as medication, procedure, laboratory, or imaging. Used to organize directives within clinical workflow systems, enabling filtering, prioritization, and reporting across care instruction types.

PreviousPage 168 of 806Next