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 instructiondur_instr

The written or coded guidance associated with a treatment duration period, such as medication administration directions or therapy protocol steps, used by clinical staff to ensure correct execution of care plans and support patient education and adherence during defined treatment intervals.

duration keydur_key

A lookup or surrogate key value linked to a treatment duration record, used to join duration data with related clinical or administrative tables in data warehouse environments, supporting efficient querying, reporting, and dimensional modeling of treatment period information across healthcare datasets.

duration labeldur_lbl

A human-readable text string used to identify or categorize a treatment duration period in user interfaces, reports, and clinical documentation, providing descriptive context such as therapy phase names or duration type classifications within care management and clinical data systems.

duration languagedur_lang

The preferred or documented communication language associated with a patient or contact linked to a treatment duration record, used to ensure clinical instructions, care plan documents, and patient communications related to the treatment period are delivered in the appropriate language for comprehension and safety.

duration last namedur_last_nm

The surname component associated with a duration record, typically linking the time period to a patient or member. Used in clinical and claims data to associate treatment duration spans with individual identifiers for longitudinal care tracking and reporting.

duration legal namedur_legal_nm

The officially registered full name associated with a duration record, used to link treatment time periods to verified patient or member identities. Supports compliance and audit requirements in clinical data systems where legal name matching is required for accurate duration attribution.

duration leveldur_lvl

A hierarchical classification value that categorizes treatment duration within a defined tiering structure, such as short-term, intermediate, or long-term. Used in utilization management and care management systems to segment authorization periods, episode lengths, or benefit duration tiers.

duration license numberdur_lic_nbr

The professional license identifier associated with the clinician or facility linked to a treatment duration record. Used in claims and authorization systems to verify that the treating provider was licensed during the applicable duration period for compliance and audit purposes.

duration marital statusdur_mar_sts

The marital status of a member or patient associated with a treatment duration record. Captured in enrollment and clinical data systems where marital status influences benefit eligibility, coordination of benefits determinations, or demographic stratification across duration-based reporting.

duration master identifierdur_mstr_id

The enterprise-level unique identifier assigned to a treatment duration record, enabling consistent tracking across multiple healthcare systems and data domains. Used to link duration data across claims, authorization, and clinical platforms without duplication or identity fragmentation.

duration maximumdur_max

The upper boundary value defining the longest allowable or observed treatment duration within a defined clinical or benefit context. Used in utilization management, prior authorization rules, and benefit configuration to enforce maximum covered days or episode length limits.

duration middle namedur_mid_nm

The middle name or initial associated with a patient or member linked to a duration record. Used in identity matching and deduplication processes within clinical and claims systems to improve accuracy when associating treatment duration spans with the correct individual.

duration minimumdur_min

The lower boundary value defining the shortest allowable or clinically expected treatment duration within a defined context. Used in utilization management and clinical decision support to flag cases where treatment length falls below evidence-based or benefit-defined thresholds.

duration mobiledur_mob

The mobile phone number associated with a patient or member tied to a treatment duration record. Used in care management and outreach systems to contact individuals regarding active treatment periods, follow-up scheduling, or duration-based care coordination interventions.

duration modified bydur_mod_by

The identifier of the user or system process that last updated a treatment duration record. Used in audit trail and data governance workflows to track accountability for changes made to duration values within clinical, claims, or authorization management systems.

duration modified datedur_mod_dt

The calendar date on which a treatment duration record was most recently updated. Used in data governance, audit, and change management processes to establish when duration values were revised within clinical, claims, or utilization management systems for compliance tracking.

duration modified timedur_mod_tm

The timestamp recording the exact time a treatment duration record was last updated. Used alongside the modified date in audit trails and data lineage tracking to provide precise change history for duration records within clinical and claims data systems.

duration namedur_nm

A human-readable label or descriptive text assigned to identify a specific treatment duration category or period. Used in clinical workflows, benefit plan configurations, and reporting interfaces to present duration classifications in an understandable format for users and analysts.

duration notedur_nt

Free-text annotation providing supplemental clinical or administrative context about a treatment duration record. Used in clinical documentation, utilization management, and care coordination systems to capture qualifications, exceptions, or explanations related to the length of a treatment period.

duration numberdur_nbr

A numeric reference value assigned to uniquely identify or sequence a treatment duration record within a healthcare data system. Used in claims processing, authorization tracking, and clinical data management to reference specific duration records across transactions and reporting workflows.

PreviousPage 217 of 806Next