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

advance directive strengthadvdir_str

Reflects the legal or clinical enforceability strength of a patient's advance directive, indicating whether it is a fully executed legal document, an informal expression of wishes, or a partial directive, helping clinicians assess reliance on its instructions.

advance directive subtotaladvdir_subtot

A partial aggregation of components or directives within a patient's multi-section advance directive document, used in clinical data systems to summarize subsets of end-of-life care instructions for reporting, audit, or care coordination workflows.

advance directive surgery dateadvdir_surg_dt

The date of a surgical procedure referenced within or prompting the creation of a patient's advance directive. Captures the clinical context in which specific operative intervention preferences or refusals were documented as part of end-of-life care planning.

advance directive targetadvdir_tgt

Identifies the specific clinical condition, intervention, or care scenario that a patient's advance directive instruction is intended to address, such as terminal illness, persistent vegetative state, or cardiac arrest, enabling precise application of end-of-life wishes.

advance directive taxonomy codeadvdir_tax_cd

Standardized classification code identifying the category or type of advance directive document, such as a living will, healthcare proxy, or POLST. Used in clinical systems to organize, retrieve, and exchange end-of-life care preference records across care settings.

advance directive temperatureadvdir_temp

Body temperature measurement recorded at the time an advance directive was executed or reviewed, used to document the patient's clinical condition. Supports contextual assessment of the patient's physical state during advance care planning encounters in clinical records.

advance directive termination dateadvdir_term_dt

The date on which an advance directive document becomes void, is revoked by the patient, or is superseded by a newer directive. Used in clinical systems to enforce document lifecycle rules and prevent application of expired patient care preferences during treatment decisions.

advance directive timeadvdir_tm

The specific time of day at which an advance directive was created, signed, witnessed, or last reviewed. Used alongside the associated date to establish a precise chronological record of advance care planning activities in patient clinical documentation systems.

advance directive timestampadvdir_ts

The combined date and time value marking when an advance directive record was created, modified, or processed in the clinical system. Provides an auditable chronological trail for compliance, legal validity, and care coordination purposes across healthcare information systems.

advance directive titleadvdir_ttl

The formal document name or heading assigned to a patient's advance directive, such as 'Durable Power of Attorney for Healthcare' or 'Do Not Resuscitate Order.' Used in clinical records to distinguish between multiple directive types on file for a single patient.

advance directive totaladvdir_tot

The aggregate numeric value associated with advance directive records for a patient or population, such as the total number of active directives on file. Used in clinical data analytics to support advance care planning program reporting and patient outreach initiatives.

advance directive total countadvdir_tot_cnt

The cumulative number of advance directive documents on file for a patient or across a defined population cohort. Used in clinical analytics and care management programs to measure advance care planning completion rates and identify patients lacking documented end-of-life preferences.

advance directive typeadvdir_typ

A classification value identifying the specific category of advance directive on record, such as living will, healthcare power of attorney, POLST, or DNR order. Used to filter and route appropriate care instructions to clinical teams based on patient-documented end-of-life preferences.

advance directive updated dateadvdir_upd_dt

The most recent date on which a patient's advance directive record was modified, amended, or reviewed and reaffirmed. Used in clinical systems to ensure care teams are referencing current patient preferences and to trigger periodic review workflows for outdated directives.

advance directive urgencyadvdir_urg

A classification indicating the time-sensitivity or priority level associated with reviewing or applying a patient's advance directive, such as immediate, routine, or scheduled. Used in clinical workflows to flag patients requiring urgent advance care planning discussions prior to procedures or admission.

advance directive versionadvdir_ver

A sequential number or identifier tracking successive revisions of a patient's advance directive document. Used to maintain a complete revision history, ensure the most current version governs clinical decisions, and satisfy legal and regulatory documentation requirements in healthcare records systems.

advance directive zipadvdir_zip

The postal ZIP code associated with the location where an advance directive was executed, or the patient's address at the time the directive was filed. Used to support geographic reporting on advance care planning participation and to route directives within regional health information exchanges.

allergy account numberalrg_acct_nbr

A unique numeric identifier linking an allergy record to a specific patient account within a healthcare system. Used to associate documented adverse reactions with the correct patient encounter or registration record, ensuring allergy data integrity across clinical and billing systems.

allergy active indicatoralrg_actv_ind

A binary flag denoting whether a documented allergy is currently active and clinically relevant for the patient. Used in clinical decision support systems to suppress alerts for resolved or inactive reactions while ensuring active allergies trigger appropriate warnings during medication ordering and treatment planning.

allergy active statusalrg_actv_sts

A coded value representing the current clinical state of a documented allergy, such as active, inactive, resolved, or entered-in-error. Used in clinical records to manage allergy list accuracy, drive decision support logic, and communicate relevant reaction history across care team members.

PreviousPage 41 of 806Next