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 discharge datesumm_dsch_dt

The date on which a patient was formally released from an inpatient or facility-based care setting, as recorded within a summary record. Used in claims adjudication, utilization review, and episode-of-care analysis to calculate length of stay and coordinate post-discharge care transitions and billing.

summary due datesumm_due_dt

The deadline date by which a payment, clinical action, or administrative requirement associated with a summary record must be completed. Used in claims billing, accounts receivable, and care management workflows to track outstanding obligations and trigger follow-up actions within revenue cycle and compliance processes.

summary durationsumm_dur

The total elapsed time span covered by or associated with a summary record, representing the length of a clinical episode, authorization period, or administrative event. Used in utilization management, claims processing, and care analytics to measure service duration and support cost and outcomes reporting.

summary emailsumm_eml

The electronic mail address associated with an individual or entity referenced within a summary record. Used in member enrollment, provider data management, and care coordination workflows to support electronic communications, notification delivery, and contact verification across administrative and clinical health information systems.

summary emergency indicatorsumm_emerg_ind

A flag denoting whether the clinical event, service, or encounter captured within a summary record was classified as an emergency. Used in claims adjudication, utilization management, and quality reporting to apply appropriate reimbursement rules, override prior authorization requirements, and stratify emergency versus elective service utilization.

summary end datesumm_end_dt

The date marking the conclusion of the period, episode, or event documented within a summary record. Used in member eligibility, authorization management, care plan tracking, and claims adjudication to define the boundary of a covered service period and support accurate date-range filtering in reporting and analytics.

summary end timesumm_end_tm

The specific time at which the event, service, or clinical encounter captured within a summary record concluded. Used alongside end date in facility billing, surgical scheduling, and care coordination systems to calculate precise service durations and ensure accurate documentation of care delivery timelines for claims and clinical records.

summary entered bysumm_ent_by

The identifier or username of the individual who manually entered or submitted a summary record into a healthcare information system. Used in clinical documentation and administrative workflows to establish accountability, support audit trails, and attribute data entry actions to specific users for compliance and data quality management.

summary ethnicitysumm_ethn

The ethnicity classification associated with the individual referenced in a summary record, captured in accordance with standard healthcare demographic codes. Used in member enrollment, population health management, and quality reporting to support health equity analysis, HEDIS reporting, and identification of disparate health outcomes across demographic segments.

summary expiration datesumm_exp_dt

The date after which a summary record, authorization, credential, or associated document is no longer considered valid within a healthcare system. Used in prior authorization management, provider credentialing, and member eligibility workflows to trigger renewals, prevent use of expired records, and maintain data accuracy in downstream systems.

summary external identifiersumm_ext_id

A reference identifier assigned by an external system or trading partner that links a summary record to a corresponding record outside the native health information system. Used in data integration, claims interchange, and HIE workflows to reconcile and cross-reference records across payers, providers, and third-party platforms.

summary faxsumm_fax

The facsimile telephone number associated with an individual or entity referenced within a summary record. Used in provider data management, referral coordination, and clinical communication workflows where fax transmission remains a standard method for transmitting clinical documentation, authorizations, and administrative correspondence in healthcare settings.

summary feesumm_fee

The monetary charge associated with a service, procedure, or administrative transaction captured within a summary record. Used in claims processing, revenue cycle management, and fee schedule analysis to record billed or allowed amounts, support cost reporting, and reconcile financial data across payer adjudication and provider billing systems.

summary first namesumm_first_nm

The given name of the individual associated with a consolidated health record summary. Used in member enrollment, claims, or clinical data systems to identify patients or providers by their first name within aggregated reporting views.

summary flagsumm_flg

A binary indicator that marks whether a condensed health record summary meets specific criteria or requires action. Used in clinical data warehouses and health plan reporting to filter, trigger workflows, or classify summary records based on defined business rules.

summary frequencysumm_freq

The interval or recurrence schedule associated with a consolidated health record summary, such as how often a clinical summary is generated or a care activity is reported. Used in care management and utilization reporting to track recurring clinical or administrative events.

summary full namesumm_full_nm

The complete name, including all name components, of the individual associated with a consolidated health record summary. Used in member enrollment and claims systems to ensure accurate identification across health plan and clinical reporting contexts.

summary gendersumm_gndr

The sex or gender classification of the individual associated with a consolidated health record summary. Used in member enrollment, claims adjudication, and clinical analytics to support demographic reporting, eligibility validation, and population health stratification.

summary glucosesumm_gluc

The blood glucose measurement captured within a consolidated clinical summary, reflecting a patient's blood sugar level at a point in time. Used in chronic disease management and quality reporting to track diabetic care metrics and lab result trends across encounters.

summary group numbersumm_grp_nbr

The health insurance group identifier associated with a consolidated member summary record. Used in enrollment and claims systems to link members to their employer or sponsor group plan, enabling group-level reporting, benefit determination, and premium reconciliation.

PreviousPage 684 of 806Next