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 commentadvdir_cmt

A free-text field capturing supplementary notes or observations related to a patient's advance directive, such as clarifications about specific care preferences or circumstances. Supports detailed documentation of end-of-life care intent beyond structured data fields in clinical systems.

advance directive completed dateadvdir_cmpl_dt

The date on which the patient's advance directive was fully executed and finalized, including all required signatures and witnessing. Recorded in the EHR to establish the legal effective date of the end-of-life care instructions and support compliance tracking.

advance directive confidential indicatoradvdir_conf_ind

A flag indicating whether a patient's advance directive is designated as confidential, restricting access to authorized personnel only. Used in EHR and clinical data systems to enforce privacy controls and ensure end-of-life care preferences are shared only with appropriate care team members.

advance directive countadvdir_cnt

The total number of advance directive records associated with a patient or encounter within the clinical system. Used in reporting and analytics to measure the frequency of end-of-life care planning documentation across patient populations, facilities, or defined time periods.

advance directive countryadvdir_ctry

Identifies the nation in which a patient's advance directive was executed. Used in EHR systems to ensure the document complies with jurisdiction-specific legal requirements governing end-of-life care instructions, such as living wills or healthcare proxy designations.

advance directive created byadvdir_crtd_by

Records the unique identifier of the clinical or administrative user who entered the patient's advance directive into the health record system. Supports audit trails and accountability tracking for end-of-life care documentation across EHR and health information systems.

advance directive created dateadvdir_crtd_dt

Captures the calendar date on which a patient's advance directive record was first entered into the health information system. Used to establish documentation timelines and verify that end-of-life care instructions were recorded prior to any relevant clinical events or procedures.

advance directive created timeadvdir_crtd_tm

Captures the precise time at which a patient's advance directive was entered into the health information system. Combined with the created date, this timestamp supports detailed audit logging and sequencing of end-of-life care documentation within clinical workflows.

advance directive creatinineadvdir_cr

Records a patient's serum creatinine laboratory value in the context of advance directive documentation, typically captured to establish baseline kidney function at the time the directive was completed. Supports clinical decision-making for patients with renal conditions affecting end-of-life care planning.

advance directive dateadvdir_dt

Records the calendar date on which the patient formally executed or signed their advance directive document. This date is critical for determining the legal validity and currency of end-of-life care instructions such as living wills, DNR orders, or healthcare proxy designations.

advance directive datetimeadvdir_dttm

Stores the combined date and time stamp associated with a patient's advance directive event, such as when the document was signed, received, or processed. Enables precise chronological tracking of end-of-life care instructions within clinical and administrative health record systems.

advance directive dea numberadvdir_dea_nbr

Stores the Drug Enforcement Administration registration number associated with a clinician involved in the advance directive process, such as a prescribing provider completing a POLST or similar end-of-life care order. Used to verify prescriber identity and regulatory compliance in clinical documentation.

advance directive death dateadvdir_death_dt

Records the date of a patient's death as documented in relation to their advance directive record. Used in clinical data systems to close or finalize end-of-life care documentation and to support mortality reporting, quality review, and retrospective analysis of advance care planning outcomes.

advance directive deleted dateadvdir_del_dt

Captures the date on which a patient's advance directive record was marked as deleted or removed from active use within the health information system. Supports audit and data governance processes by preserving a historical record of when end-of-life care documents were rescinded or purged.

advance directive deleted indicatoradvdir_del_ind

A flag indicating whether a patient's advance directive record has been logically deleted or deactivated within the health information system. Allows clinical and administrative workflows to distinguish between active end-of-life care instructions and those that have been rescinded, superseded, or removed from active use.

advance directive descriptionadvdir_desc

Contains a human-readable narrative summarizing the type or content of a patient's advance directive, such as whether it is a living will, do-not-resuscitate order, or durable power of attorney for healthcare. Used to communicate end-of-life care preferences clearly across clinical teams and health record systems.

advance directive detailadvdir_dtl

Contains granular information about the specific instructions, preferences, or conditions documented within a patient's advance directive. This may include particular treatment refusals, care goals, or situational guidance intended to inform clinical decision-making during end-of-life or incapacitation scenarios.

advance directive discharge dateadvdir_dsch_dt

Records the date a patient was discharged from an inpatient facility in relation to their advance directive documentation. Used to correlate end-of-life care planning activities with inpatient encounters and to ensure advance directive instructions are communicated during care transitions to post-acute or home settings.

advance directive due dateadvdir_due_dt

Indicates the target date by which a patient's advance directive should be completed, reviewed, or renewed within the care setting. Used in care coordination workflows to prompt clinicians and administrative staff to ensure end-of-life care documentation is current and compliant with facility or regulatory requirements.

advance directive durationadvdir_dur

Represents the length of time a patient's advance directive is considered valid or in effect, measured from execution to expiration or next required review. Used in health record systems to manage the lifecycle of end-of-life care documents and trigger renewal workflows when directives approach expiration.

PreviousPage 36 of 806Next