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

duration completed datedur_cmpl_dt

Records the date on which all services or clinical activities within a treatment duration period were fully delivered and closed. Used in care management, claims reconciliation, and authorization tracking systems to confirm episode completion and trigger post-care workflows or billing finalization.

duration confidential indicatordur_conf_ind

A flag indicating that information associated with a treatment duration period is subject to enhanced privacy protections, such as behavioral health, substance use, or reproductive care restrictions. Used to control data access, limit disclosures, and enforce compliance with regulations such as 42 CFR Part 2 or state confidentiality laws.

duration countdur_cnt

Represents the total number of occurrences, units, or instances recorded within a treatment duration period. Used in utilization management and clinical analytics to quantify service volume, track authorized visit limits, and measure care intensity across approved episodes for reporting and reimbursement purposes.

duration countrydur_ctry

Stores the country associated with a patient's residence or care delivery location during a treatment duration period. Used in member enrollment, international claims processing, and care management systems to support cross-border benefit administration, geographic segmentation, and regulatory compliance reporting.

duration created bydur_crtd_by

Identifies the user or system that originally created a treatment duration record. Captures the username or system ID responsible for initiating the duration entry, supporting audit trails and accountability in clinical data management workflows.

duration created datedur_crtd_dt

The calendar date on which a treatment duration record was first created in the system. Used to establish an audit trail for duration entries, supporting data governance, record tracking, and chronological reporting in clinical and administrative workflows.

duration created timedur_crtd_tm

The exact time at which a treatment duration record was first created in the system. Combined with the created date, this timestamp provides a precise audit trail for duration record creation, supporting data integrity and clinical workflow tracking.

duration creatininedur_cr

Records the serum creatinine lab value associated with a treatment duration period. Used in clinical decision support and pharmacy dosing contexts to assess renal function, particularly for medication dosing adjustments and monitoring chronic kidney disease progression over time.

duration datedur_dt

The specific calendar date associated with a defined treatment duration period. Used in clinical workflows to anchor the duration to a point in time, supporting scheduling, authorization tracking, and longitudinal care management across healthcare data systems.

duration datetimedur_dttm

The combined date and time value marking a key moment within a treatment duration period. This precise timestamp supports accurate sequencing of clinical events, concurrent treatment tracking, and time-sensitive reporting in healthcare data warehouses and clinical systems.

duration dea numberdur_dea_nbr

The Drug Enforcement Administration registration number associated with a treatment duration record, typically linked to controlled substance prescribing. Used to identify the prescribing clinician's DEA credentials when tracking scheduled medication therapy durations in pharmacy and clinical systems.

duration death datedur_death_dt

Records the date of patient death as it relates to the termination of an active treatment duration period. Used to close open treatment episodes, reconcile care timelines, and support mortality reporting, outcomes analysis, and longitudinal patient record management.

duration deleted datedur_del_dt

The calendar date on which a treatment duration record was logically deleted or inactivated in the system. Supports soft-delete audit trails, data retention compliance, and historical reporting by preserving the deletion timestamp without permanently removing the record.

duration deleted indicatordur_del_ind

A flag indicating whether a treatment duration record has been logically deleted or inactivated in the system. Supports soft-delete functionality, allowing records to be excluded from active reporting while preserving historical data for audit, compliance, and retrospective analysis purposes.

duration descriptiondur_desc

A human-readable text description explaining the nature or purpose of a treatment duration period. Provides clinical or administrative context for the duration record, aiding clinicians and analysts in identifying the associated care episode, protocol, or authorization period.

duration detaildur_dtl

Stores granular clinical or administrative information specific to a treatment duration period. Captures supplementary details beyond standard structured fields, such as clinical notes, special conditions, or protocol-specific parameters that define or qualify the duration record in healthcare systems.

duration discharge datedur_dsch_dt

The date a patient was discharged from an inpatient or outpatient facility, marking the end of a treatment duration period. Used in utilization management, claims processing, and care coordination to calculate length of stay and close active authorization or episode records.

duration due datedur_due_dt

The target or deadline date associated with a treatment duration period, such as when a follow-up, authorization renewal, or clinical milestone is expected. Used in care management and utilization review workflows to trigger alerts, renewals, or administrative actions within defined treatment timelines.

duration durationdur_dur

Stores the calculated or specified length of a treatment duration period, typically expressed in days, weeks, or other time units. Used in clinical decision support, prior authorization, and pharmacy dispensing workflows to define the total span of an approved or active treatment episode.

duration emaildur_eml

The electronic mail address associated with a contact or responsible party linked to a treatment duration record. Used to facilitate communication regarding duration-related notifications, authorization updates, or care coordination activities within clinical and administrative healthcare workflows.

PreviousPage 215 of 806Next