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 sourcedir_src

Identifies the originating system, clinician role, or external reference from which a clinical directive was generated, such as an attending physician order, clinical protocol, or external care plan. Supports audit trails and care coordination across clinical settings.

directive start datedir_start_dt

Records the calendar date on which a clinical directive becomes active and should begin execution. Used in care plan management, medication scheduling, and treatment workflows to establish when an order or instruction is authorized to take effect within the patient's clinical record.

directive start timedir_start_tm

Records the specific time of day at which a clinical directive is authorized to begin, complementing the start date for precise scheduling. Critical for time-sensitive orders such as medication administration, pre-operative preparations, or timed diagnostic procedures.

directive statedir_st

Captures the U.S. state or territory jurisdiction associated with a clinical directive, relevant when directives such as advance care plans, prescriptions, or legal orders are subject to state-specific regulatory requirements, licensure boundaries, or cross-state care coordination rules.

directive statusdir_sts

Indicates the current lifecycle state of a clinical directive, such as active, pending, completed, cancelled, or on hold. Used in EHR and care management systems to track whether an order or care instruction is actionable, awaiting fulfillment, or no longer applicable to the patient's current care plan.

directive strengthdir_str

Specifies the concentration or potency of a medication or therapeutic agent referenced within a clinical directive, such as 500mg or 0.9% solution. Essential for pharmacy fulfillment, medication reconciliation, and safe drug administration to ensure accurate dosing per the prescribing clinician's intent.

directive subtotaldir_subtot

Represents an intermediate sum calculated within a clinical directive, such as a partial cost accumulation, partial dosage calculation, or component-level quantity before final totals are applied. Used in billing, care planning, and pharmacy workflows requiring stepwise aggregation of directive-related values.

directive surgery datedir_surg_dt

Records the scheduled or actual date on which a surgical procedure referenced within a clinical directive is performed. Used in pre-operative planning, post-operative care coordination, and clinical documentation to link directive instructions to a specific operative event in the patient's timeline.

directive targetdir_tgt

Identifies the intended clinical goal, anatomical site, patient population segment, or system destination associated with a care directive. Used to specify what outcome, body region, or downstream workflow the directive is designed to address, supporting precise clinical execution and reporting.

directive taxonomy codedir_tax_cd

Stores the standardized NUCC taxonomy code identifying the clinical specialty or provider type associated with the issuance or execution of a directive. Used to ensure directives are routed to appropriately credentialed clinicians and to support specialty-specific reporting and compliance requirements.

directive temperaturedir_temp

Records a temperature value specified within a clinical directive, such as a target body temperature for therapeutic hypothermia, a storage temperature for a medication, or a fever threshold triggering a clinical intervention. Used in nursing, pharmacy, and critical care workflows requiring precise thermal parameters.

directive termination datedir_term_dt

Captures the calendar date on which a clinical directive expires, is discontinued, or is no longer authorized for execution. Used in medication management, care plan oversight, and compliance workflows to prevent continuation of orders beyond their intended clinical duration or authorized validity period.

directive timedir_tm

Records the specific time of day associated with a clinical directive event, such as the scheduled administration time for a medication or the time a care instruction was issued. Used in nursing workflows, medication scheduling, and clinical audit trails requiring precise time-level documentation.

directive timestampdir_ts

Captures the combined date and time at which a clinical directive was created, modified, executed, or recorded in the system. Used for audit trail integrity, clinical event sequencing, and regulatory compliance to establish an accurate chronological record of directive activity within the patient's care history.

directive titledir_ttl

The formal name or heading assigned to a patient care directive, such as an advance directive, DNR order, or care plan instruction. Used in clinical systems to label and retrieve specific directive documents within a patient's longitudinal health record.

directive totaldir_tot

The aggregate numeric value associated with a set of patient care directives, such as total authorized services or cumulative instruction counts within a care episode. Used in clinical data warehouses to support utilization analysis and care coordination reporting.

directive total countdir_tot_cnt

The total number of patient care directive records associated with a patient, encounter, or care plan. Used in clinical analytics to measure directive volume across populations, track compliance with advance care planning protocols, and support quality reporting initiatives.

directive typedir_typ

A coded classification identifying the category of a patient care directive, such as advance directive, DNR, POLST, medication order, or treatment limitation. Used in clinical systems to route, filter, and report directives according to their clinical intent and legal standing.

directive updated datedir_upd_dt

The calendar date on which a patient care directive was most recently modified, amended, or reviewed. Used in clinical record management to ensure that care teams are acting on current patient instructions and to support audit trails for directive change history.

directive urgencydir_urg

A coded value indicating the time-sensitivity or priority level assigned to a patient care directive, such as routine, urgent, or emergent. Used in clinical workflows to prioritize the execution of care instructions and ensure timely compliance with patient or provider-initiated orders.

PreviousPage 174 of 806Next