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

directive descriptiondir_desc

The free-text or standardized narrative explaining the nature, scope, and instructions of a patient care directive. Captures clinician-authored language describing treatment preferences, restrictions, or orders, and is used in EHR displays, care summaries, and clinical documentation workflows.

directive detaildir_dtl

Granular clinical information associated with a specific patient care directive, including supplementary instructions, qualifications, or conditions that govern how the directive should be applied. Used in EHR and care management systems to provide context beyond the primary directive description for clinical decision support.

directive discharge datedir_dsch_dt

The date on which a patient was discharged from an inpatient or outpatient facility in relation to an active care directive. Used in clinical data systems to associate directive lifecycle events with the patient's episode of care and to determine when facility-based directives should be transitioned or closed.

directive due datedir_due_dt

The target date by which a patient care directive or associated clinical action must be completed, reviewed, or renewed. Used in care management and EHR systems to trigger workflow reminders, ensure timely compliance with care plan instructions, and support follow-up scheduling for time-sensitive directives.

directive durationdir_dur

The defined length of time a patient care directive is intended to remain active or in effect from its initiation date. Captured in clinical systems to automatically calculate expiration timelines, support renewal workflows, and ensure directives such as medication orders or treatment instructions are not applied beyond their intended period.

directive emaildir_eml

The electronic mail address associated with the clinician, patient, or responsible party linked to a patient care directive. Used in clinical communication workflows to route notifications, directive acknowledgments, or care instruction updates to the appropriate contact within EHR and care coordination systems.

directive emergency indicatordir_emerg_ind

A flag identifying whether a patient care directive carries emergency or urgent status, signaling that it must be immediately surfaced or acted upon in clinical workflows. Used in EHR systems to prioritize display of critical directives such as emergency DNR orders or urgent treatment restrictions during acute care encounters.

directive end datedir_end_dt

The calendar date on which a patient care directive is scheduled to expire, was completed, or was formally discontinued. Used in EHR and clinical data systems to manage the active period of treatment instructions, advance directives, and clinical orders, ensuring expired directives are removed from active care workflows.

directive end timedir_end_tm

The specific time of day at which a patient care directive is scheduled to expire or was formally discontinued within the clinical system. Combined with the directive end date to provide precise timestamp-level control over time-sensitive orders such as medication directives or procedural instructions in EHR workflows.

directive entered bydir_ent_by

The identifier or name of the clinical user who manually entered or created a patient care directive in the EHR or clinical information system. Supports accountability and audit trail requirements by documenting the originating data entry source, which may differ from the authorizing clinician of record.

directive ethnicitydir_ethn

The self-reported or administratively assigned ethnicity classification of the patient associated with a care directive. Captured in clinical systems to support health equity reporting, culturally informed care planning, and demographic analysis of directive usage patterns across patient populations.

directive expiration datedir_exp_dt

The date after which a patient care directive is no longer considered valid or clinically actionable. Used in EHR and clinical data systems to automatically retire outdated directives, prompt renewal reviews for advance care plans, and prevent application of expired treatment instructions during active patient encounters.

directive external identifierdir_ext_id

A reference identifier assigned to a patient care directive by an external system, such as a referring facility, health information exchange, or third-party clinical platform. Used in EHR and data integration workflows to link and reconcile directive records across disparate systems without relying solely on internal identifiers.

directive faxdir_fax

The facsimile number associated with the clinician, facility, or contact responsible for a patient care directive. Used in clinical communication workflows to route hard-copy directive transmissions, such as advance directive confirmations or order authorizations, to the appropriate receiving party in EHR and care coordination systems.

directive feedir_fee

The charge amount associated with a clinical directive or care instruction order, such as a procedure directive or treatment protocol. Captures the billable service fee linked to the directive in pharmacy, clinical, or claims-based reimbursement workflows.

directive first namedir_first_nm

The given name of the individual associated with a clinical directive, such as a patient or ordering clinician. Used in care management systems to identify the person named in an advance directive, treatment order, or care instruction document.

directive flagdir_flg

A binary indicator that marks whether a specific clinical directive is active, completed, suspended, or otherwise in a particular state. Used in care management and clinical workflows to filter, route, or trigger downstream processes based on directive status.

directive frequencydir_freq

The prescribed schedule or interval at which a clinical directive must be executed, such as daily, weekly, or PRN. Commonly used in medication orders, treatment protocols, and care plans to define how often a care instruction should be carried out.

directive full namedir_full_nm

The complete name of the individual or entity associated with a clinical directive, combining first, middle, and last name components. Used in care management records to fully identify a patient or clinician referenced within an advance directive or treatment order.

directive genderdir_gndr

The biological sex or gender identity of the individual associated with a clinical directive. Used in care management and clinical workflows to ensure gender-appropriate care instructions, dosing guidelines, and treatment protocols are correctly applied.

PreviousPage 170 of 806Next