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 start timesumm_start_tm

The precise time of day at which a clinical event, procedure, or treatment episode began as recorded in a summary record. Supports time-sensitive clinical workflows, emergency department throughput measurement, surgical scheduling, and regulatory reporting requirements.

summary statesumm_st

The U.S. state or territory associated with a clinical or administrative summary record, typically reflecting the patient's residence or the location of the treating facility. Used in geographic reporting, regulatory compliance, and state-level public health surveillance.

summary statussumm_sts

A coded value representing the current processing or clinical state of a summary record, such as active, completed, pending, or cancelled. Drives workflow routing, downstream data processing, and care coordination activities within health information and care management systems.

summary strengthsumm_str

The documented concentration or dosage strength of a medication as recorded within a clinical summary, expressed in standard units such as mg, mcg, or mg/mL. Essential for medication reconciliation, pharmacy dispensing verification, and transitions of care documentation.

summary subtotalsumm_subtot

A partial aggregated financial or utilization value within a summary record, representing costs, charges, or service counts before final adjustments or totals are applied. Used in claims adjudication, cost reporting, and financial reconciliation across payer and provider systems.

summary surgery datesumm_surg_dt

The calendar date on which a surgical procedure documented in a clinical summary was performed. Used for episode-of-care construction, post-operative follow-up tracking, surgical quality reporting, and coordination between inpatient and outpatient care records.

summary targetsumm_tgt

The intended destination system, clinical goal, or reference endpoint associated with a summary record, such as a target lab value, receiving facility, or care plan objective. Used in care management workflows, data routing, and clinical outcome tracking.

summary taxonomy codesumm_tax_cd

The Health Care Provider Taxonomy Code identifying the specialty or provider type associated with a clinical summary. Sourced from the NUCC taxonomy code set, this value supports claim routing, network adequacy reporting, and specialty-specific quality measure attribution.

summary temperaturesumm_temp

A recorded body temperature measurement documented within a clinical summary, expressed in Fahrenheit or Celsius. Used as a vital sign indicator in inpatient assessments, sepsis screening, infection surveillance, and longitudinal patient monitoring across clinical encounters.

summary termination datesumm_term_dt

The calendar date on which a clinical episode, treatment plan, or summary record officially ended or was closed. Used in episode-of-care analytics, chronic condition management, member enrollment reporting, and determining the effective duration of clinical or administrative records.

summary timesumm_tm

The time of day associated with a clinical event or data entry within a summary record, independent of date. Supports chronological sequencing of clinical activities, shift-based reporting, medication administration verification, and time-sensitive regulatory documentation requirements.

summary timestampsumm_ts

The combined date and time value capturing when a summary record was created, modified, or transmitted within a health information system. Provides an audit trail for data governance, supports chronological ordering of clinical events, and enables latency analysis in data pipelines.

summary titlesumm_ttl

The formal descriptive label assigned to a clinical summary document, such as Discharge Summary, Operative Report, or Annual Wellness Visit Summary. Used to classify and retrieve specific summary types within health information systems and standardized clinical documentation frameworks.

summary totalsumm_tot

The aggregate monetary or unit value across all line items within a consolidated summary record, such as a claims payment summary, remittance advice, or utilization report. Used in financial reconciliation and population health reporting to validate totals against detail records.

summary total countsumm_tot_cnt

The total number of discrete records, transactions, or events included within a consolidated summary, such as the count of claims processed in a remittance batch or encounters captured in a utilization summary. Used to validate completeness during data reconciliation and audit workflows.

summary typesumm_typ

A categorical classification that identifies the nature or purpose of a consolidated summary record, such as a claims payment summary, clinical discharge summary, utilization review summary, or remittance advice. Drives downstream processing logic and determines applicable business rules for interpretation.

summary updated datesumm_upd_dt

The most recent date on which a consolidated summary record was modified, corrected, or supplemented. Used in audit trails, data governance, and version control processes to ensure downstream consumers are referencing the current state of the summary within claims, clinical, or enrollment systems.

summary urgencysumm_urg

A coded or descriptive value indicating the time-sensitivity level assigned to a consolidated summary record, such as routine, urgent, or stat. Used in clinical documentation and care coordination workflows to prioritize review and action on summaries such as discharge or referral summaries.

summary versionsumm_ver

A sequential or labeled version identifier assigned to a consolidated summary record that distinguishes the current iteration from prior versions. Supports audit compliance, amendment tracking, and longitudinal data management in clinical documentation, claims, and care management systems.

summary zipsumm_zip

The five- or nine-digit postal ZIP code associated with a consolidated summary record, typically reflecting the geographic location of the member, patient, or service site referenced in the summary. Used for geographic analysis, regional reporting, and population health stratification.

PreviousPage 688 of 806Next