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 onset datedur_onset_dt

The date on which symptoms, a condition, or a treatment episode first began, marking the start boundary of a clinical duration period. Used in claims, clinical documentation, and utilization management to establish when a condition originated for coverage determination and longitudinal tracking.

duration oxygen saturationdur_o2sat

The measured peripheral blood oxygen saturation level recorded in association with a treatment duration period. Used in respiratory care, chronic disease management, and inpatient clinical data systems to track oxygen levels across the duration of a condition or therapy episode.

duration paid amountdur_pd_amt

The total dollar amount paid by the payer for services associated with a treatment duration period. Used in claims adjudication and financial reporting systems to capture reimbursement values tied to specific duration spans for cost analysis, reconciliation, and provider payment tracking.

duration paid datedur_pd_dt

The date on which payment was issued for services associated with a treatment duration period. Used in claims financial processing and accounts payable systems to record when reimbursement was disbursed, supporting reconciliation, cash flow reporting, and payment audit workflows.

duration parentdur_prnt

Identifies the hierarchical parent record to which a treatment duration belongs, enabling nested time period structures in clinical data systems. Used to link subordinate duration intervals to their governing treatment episode or care plan timeline.

duration percentagedur_pct

Represents a proportional value expressed as a percentage relative to a treatment time period, such as the portion of a therapy course completed or the share of an authorized duration consumed. Used in utilization management and care coordination analytics.

duration perioddur_prd

Defines the discrete time interval associated with a clinical treatment or service, specifying the span across which care, authorization, or benefit coverage applies. Used in care management, prior authorization, and claims adjudication workflows.

duration phonedur_ph

Stores the telephone contact number associated with a treatment duration record, such as the scheduling or coordinating contact for an ongoing therapy episode. Used to facilitate communication during active treatment periods tracked in clinical systems.

duration preferred namedur_pref_nm

The human-readable display label assigned to a treatment duration record, used to present the time period in a standardized, user-friendly format within clinical dashboards, care plans, and reporting interfaces across health information systems.

duration pricedur_prc

Captures the monetary cost associated with a treatment duration period, representing charges or reimbursement amounts tied to a defined clinical timeframe. Used in healthcare billing, contract management, and financial reporting for time-based care services.

duration primary indicatordur_prim_ind

A flag that designates whether a given treatment duration record is the primary or principal time period among multiple duration entries for the same episode or service. Used to resolve conflicts and prioritize records in clinical and claims data processing.

duration prioritydur_prty

Indicates the relative importance or processing order assigned to a treatment duration record when multiple time periods exist for the same clinical episode. Used in care management workflows to determine scheduling, resource allocation, and authorization sequencing.

duration procedure datedur_proc_dt

Records the date on which a clinical procedure or intervention was performed within a treatment duration period. Used in claims processing and clinical documentation to timestamp the specific service event tied to an authorized or active care timeframe.

duration pulsedur_pulse

Captures the patient's heart rate measurement recorded in association with a specific treatment duration period. Used in clinical monitoring and longitudinal vital sign tracking to correlate cardiovascular readings with defined phases of a patient's care timeline.

duration quantitydur_qty

Specifies the numeric count or volume associated with a treatment duration, such as the number of authorized visits, units of service, or doses administered within the defined time period. Used in utilization management, pharmacy dispensing, and claims adjudication.

duration racedur_race

Records the patient's self-reported racial identification in association with a treatment duration record. Used in population health analytics, health equity reporting, and clinical outcome studies to evaluate disparities across treatment timeframes and care episodes.

duration rangedur_rng

Defines the minimum and maximum boundary values permitted or observed for a treatment duration period, such as acceptable lengths of stay or authorized service windows. Used in clinical guidelines, utilization review, and quality measurement benchmarking.

duration ratedur_rt

Specifies the per-unit reimbursement or charge rate applied to a treatment duration period, such as a daily room rate or per-session therapy fee. Used in healthcare contract pricing, claims adjudication, and financial modeling for time-based clinical services.

duration ratingdur_rtg

Represents a scored or graded assessment value assigned to a treatment duration, such as a quality score or risk rating tied to the length or outcome of a care episode. Used in performance measurement, value-based care analytics, and clinical quality programs.

duration ratiodur_ratio

Expresses the proportional relationship between a treatment duration and a reference value, such as actual versus expected length of stay. Used in clinical benchmarking, utilization review, and outcomes analysis to evaluate efficiency of care delivery over time.

PreviousPage 218 of 806Next