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 indexadvdir_idx

A numeric position or sequence value assigned to a patient's advance directive record within a clinical dataset or document repository. Used to order multiple directive versions or entries and support systematic retrieval of end-of-life care documentation in health information systems.

advance directive indicatoradvdir_ind

A coded value denoting the current status or presence of a patient's advance directive, such as active, revoked, or pending. Enables clinical workflows to quickly assess whether valid end-of-life care instructions exist and whether care teams must adhere to specific documented patient preferences.

advance directive instructionadvdir_instr

The specific guidance or directives recorded within a patient's advance directive, detailing their preferences for medical interventions, resuscitation, life support, and other end-of-life care decisions. These instructions legally guide clinical teams when the patient cannot communicate their own wishes.

advance directive keyadvdir_key

A system lookup value used to reference or join advance directive records across related clinical data tables. Functions as a relational identifier linking end-of-life care documentation to associated patient, encounter, or provider records within the health information system.

advance directive labeladvdir_lbl

The display text or UI label associated with a patient's advance directive record, used to identify the directive type such as living will, DNR, or healthcare proxy in clinical documentation systems and EHR interfaces.

advance directive languageadvdir_lang

The preferred spoken or written language in which a patient's advance directive was documented or should be communicated, ensuring clinical staff and legal representatives can accurately interpret end-of-life care instructions across multilingual healthcare settings.

advance directive last nameadvdir_last_nm

The family surname of the patient or legally authorized representative associated with an advance directive document, used to match and verify the directive against patient demographic records in clinical and legal workflows.

advance directive legal nameadvdir_legal_nm

The full official registered name of the patient as it appears on a legally executed advance directive document, used to validate the directive's authenticity and ensure accurate patient matching in medical records and legal review processes.

advance directive leveladvdir_lvl

The hierarchical classification or priority tier assigned to a patient's advance directive, indicating the scope of care instructions such as comfort care only, limited intervention, or full treatment, used to guide clinical decision-making at point of care.

advance directive license numberadvdir_lic_nbr

The professional license identifier of the healthcare provider, attorney, or notary who witnessed or validated the advance directive document, used for compliance verification and legal authentication of end-of-life care instructions in clinical records.

advance directive marital statusadvdir_mar_sts

The marital status of the patient at the time of advance directive execution, used to determine legal next-of-kin hierarchy and identify the appropriate healthcare proxy or surrogate decision-maker when the patient cannot express end-of-life care preferences.

advance directive master identifieradvdir_mstr_id

The enterprise-level unique identifier assigned to a patient's advance directive across integrated healthcare systems, enabling consistent tracking and retrieval of end-of-life care instructions across facilities, EHRs, and clinical data repositories.

advance directive maximumadvdir_max

The upper threshold or maximum value associated with a clinical parameter specified within a patient's advance directive, such as the highest acceptable level of intervention or resuscitation effort permitted under the documented end-of-life care instructions.

advance directive middle nameadvdir_mid_nm

The middle name or initial of the patient or authorized representative listed on an advance directive document, used to support accurate identity matching and disambiguation in clinical records when patients share similar first and last names.

advance directive minimumadvdir_min

The lower threshold or minimum value associated with a clinical parameter specified within a patient's advance directive, such as the least level of intervention required under the documented end-of-life care instructions, used to guide clinical treatment boundaries.

advance directive mobileadvdir_mob

The mobile phone number of the patient or designated healthcare proxy listed on the advance directive, used by clinical staff to establish urgent contact with the responsible party when end-of-life care decisions must be communicated or confirmed.

advance directive modified byadvdir_mod_by

The user identifier of the clinician, administrator, or authorized representative who last updated the advance directive record in the healthcare system, used for audit trail purposes and to maintain accountability in end-of-life care documentation workflows.

advance directive modified dateadvdir_mod_dt

The calendar date on which a patient's advance directive record was most recently updated in the healthcare system, used to determine whether the documented end-of-life care instructions reflect the patient's current wishes and to support legal and clinical compliance audits.

advance directive modified timeadvdir_mod_tm

The timestamp recording the exact time a patient's advance directive record was last updated in the healthcare system, used alongside the modified date to maintain a precise audit trail of changes to end-of-life care documentation in clinical workflows.

advance directive nameadvdir_nm

The human-readable display name assigned to a patient's advance directive record, identifying the document type such as living will, durable power of attorney for healthcare, or POLST, used for retrieval and presentation in clinical and administrative interfaces.

PreviousPage 38 of 806Next