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

summary modified datesumm_mod_dt

The calendar date on which a consolidated summary record was most recently updated. Used in audit logging, data governance workflows, and change management processes to track the recency of information and support compliance with record retention requirements.

summary modified timesumm_mod_tm

The timestamp indicating the exact time at which a consolidated summary record was last updated. Combined with the modified date field, this value provides a precise audit trail for record changes across clinical documentation, claims, or member enrollment systems.

summary namesumm_nm

The human-readable label or title assigned to a consolidated summary record, used to identify the summary in reporting interfaces, administrative workflows, and data catalogs. May represent a patient name, report title, or program label depending on the summary context.

summary notesumm_nt

A free-text annotation or comment associated with a consolidated summary record. Used by clinical or administrative staff to document context, flag exceptions, or provide supplementary details that cannot be captured in structured data fields within the summary.

summary numbersumm_nbr

A system-assigned or externally referenced numeric identifier associated with a consolidated summary record. Used to uniquely track and retrieve summary records across healthcare platforms, including claims summaries, authorization summaries, and clinical episode groupings.

summary onset datesumm_onset_dt

The date on which a condition, symptom, or clinical event first began as recorded in a consolidated clinical summary record. This field supports longitudinal care management, chronic disease tracking, and accurate coding of diagnosis onset for claims and quality reporting.

summary oxygen saturationsumm_o2sat

The recorded blood oxygen saturation level, expressed as a percentage, within a consolidated clinical summary record. This vital sign measurement is used in monitoring respiratory status, guiding clinical interventions, and supporting quality metrics for inpatient and outpatient care.

summary paid amountsumm_pd_amt

The total dollar amount paid as recorded in a financial or claims summary record. Reflects actual reimbursement issued to a provider or member after adjudication, used in financial reconciliation, cost reporting, and analytics across health plan and claims processing systems.

summary paid datesumm_pd_dt

The date on which payment was issued as recorded in a financial or claims summary record. Used in accounts payable reconciliation, claims adjudication tracking, and financial reporting to confirm that reimbursement obligations were fulfilled within contractual or regulatory timeframes.

summary parentsumm_prnt

The identifier or reference linking a consolidated summary record to its parent record in a hierarchical data structure. Used in systems where summaries are organized into parent-child relationships, such as episode groupings, benefit plan hierarchies, or organizational reporting structures.

summary percentagesumm_pct

A proportional ratio value captured within a consolidated summary record, such as coinsurance rate, benefit utilization percentage, or clinical metric proportion. Used in benefit design calculations, cost-sharing determinations, and population health performance reporting.

summary periodsumm_prd

The defined time interval to which a consolidated summary record applies, such as a benefit year, reporting quarter, or episode of care duration. Used to scope financial, clinical, or operational summary data to a specific measurement window for analysis and reporting.

summary phonesumm_ph

The primary telephone number associated with an individual as recorded in a consolidated health or demographic summary record. Used to support member outreach, care coordination communication, claims correspondence, and contact verification in member enrollment systems.

summary preferred namesumm_pref_nm

The human-readable display label assigned to a clinical or administrative summary record. Used in patient-facing documents, care coordination workflows, and reporting interfaces to identify the summary in a clear, standardized format across health information systems.

summary pricesumm_prc

The monetary cost associated with a clinical service, benefit, or item captured within a summary record. Used in claims adjudication, benefits administration, and financial reporting to reflect the charged, allowed, or reimbursed amount tied to the summarized encounter or service.

summary primary indicatorsumm_prim_ind

A flag identifying whether a summary record is designated as the primary or preferred instance among multiple related summaries. Used in care coordination and data deduplication workflows to distinguish the authoritative summary when multiple versions or types exist for a patient or encounter.

summary prioritysumm_prty

A ranked value indicating the urgency or processing order assigned to a clinical or administrative summary. Used in care management, utilization review, and workflow routing to ensure high-priority summaries such as critical diagnoses or urgent authorizations receive timely attention and action.

summary procedure datesumm_proc_dt

The calendar date on which a clinical procedure documented within a summary record was performed. Used in claims processing, clinical documentation, and quality reporting to establish the temporal context of the intervention and support timely filing, coordination of benefits, and outcome tracking.

summary pulsesumm_pulse

The recorded heart rate measurement, expressed in beats per minute, captured within a clinical summary record. Used in vital signs documentation, chronic disease management, and longitudinal patient health tracking to monitor cardiovascular status across encounters and support clinical decision-making.

summary quantitysumm_qty

The numeric count or volume of a service, item, or clinical observation recorded within a summary. Used in pharmacy dispensing records, claims processing, and utilization management to capture units dispensed, services rendered, or supplies provided during a summarized period or encounter.

PreviousPage 686 of 806Next