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 citysumm_city

The municipality name associated with the address captured at the summary record level. Used in member enrollment, claims adjudication, and population health reporting to support geographic segmentation, network adequacy analysis, and service area assignment for patients or members.

summary classsumm_cls

A classification tier or benefit class designation assigned at the summary record level. Used in member enrollment and claims processing to identify the benefit plan tier, coverage category, or service classification that governs eligibility rules and cost-sharing calculations.

summary codesumm_cd

A standardized code value assigned to a summary record to identify its type, status, or clinical and administrative classification. Used across claims, clinical documentation, and enrollment systems to categorize summary transactions and enable consistent cross-system reporting and data exchange.

summary commentsumm_cmt

A free-text notation field attached to a summary record that captures supplemental clinical or administrative context not represented by structured data elements. Used in clinical documentation, utilization review, and care management workflows to preserve narrative detail at the summary level.

summary completed datesumm_cmpl_dt

The date on which a summary-level service, authorization, care plan, or clinical task was marked as completed. Used in utilization management, care coordination, and claims processing workflows to track service fulfillment timelines and measure compliance with turnaround requirements.

summary confidential indicatorsumm_conf_ind

A flag designating that a summary record contains sensitive or protected information requiring restricted access. Applied in clinical and administrative systems to enforce privacy controls for records involving behavioral health, substance use, reproductive health, or other specially protected categories.

summary countsumm_cnt

A numeric value representing the total number of occurrences, items, or transactions aggregated within a summary record. Used in claims reporting, utilization analysis, and population health dashboards to quantify service volumes, member encounters, or grouped administrative events at a summary level.

summary countrysumm_ctry

The country name or code associated with the address recorded at the summary record level. Used in member enrollment, claims processing, and clinical data management to support international address validation, regulatory compliance reporting, and geographic segmentation of patient or member populations.

summary created bysumm_crtd_by

The identifier of the user, clinician, or automated process that originally created a summary record in the system. Used in audit trail tracking, data governance, and compliance reporting to establish record ownership and support investigation of data entry or workflow issues across clinical and administrative systems.

summary created datesumm_crtd_dt

The calendar date on which a summary record was first created and written to the system. Used in audit logging, data lineage tracking, and reporting workflows to establish the origination timestamp of summary-level transactions across clinical documentation, claims, enrollment, and care management systems.

summary created timesumm_crtd_tm

The timestamp indicating the exact time a summary record was created in the system on its creation date. Used alongside the created date in audit trail reporting, workflow sequencing, and data quality monitoring to provide precise record origination tracking across clinical and administrative platforms.

summary creatininesumm_cr

The serum or urine creatinine value recorded at the clinical summary level, used as a key biomarker for assessing kidney function. Captured in chronic disease management programs and lab result summaries to support CKD staging, medication safety monitoring, and renal function trend reporting across patient populations.

summary datesumm_dt

The primary calendar date associated with a summary record, representing the reference point for the summarized activity, encounter, or transaction period. Used across clinical documentation, claims, and enrollment systems to anchor summary-level data to a specific point in time for reporting and chronological sequencing.

summary datetimesumm_dttm

The combined date and time stamp recorded on a clinical or administrative summary record. Captures the precise moment a summary was generated, updated, or finalized within claims processing, EHR documentation, or care management workflows for audit and chronological tracking purposes.

summary dea numbersumm_dea_nbr

The Drug Enforcement Administration registration number associated with a prescribing clinician as recorded on a clinical summary. Used in pharmacy and controlled substance workflows to validate prescriber authorization and link prescription activity to the correct licensed practitioner across health systems.

summary death datesumm_death_dt

The recorded date of a member or patient's death as captured within a summary record. Used in member enrollment, claims adjudication, and care management systems to terminate coverage, close active care plans, and ensure accurate demographic data across downstream reporting and eligibility processes.

summary deleted datesumm_del_dt

The date on which a summary record was flagged for deletion or physically removed from an active dataset. Used in clinical data warehouses and health information systems to maintain data integrity, support audit trails, and track record lifecycle management within retention and compliance workflows.

summary deleted indicatorsumm_del_ind

A boolean or coded flag that identifies whether a summary record has been marked as deleted within a healthcare data system. Used in data governance and records management to exclude voided or retracted entries from active reporting while preserving the record for historical audit and compliance purposes.

summary descriptionsumm_desc

A free-text or structured narrative field providing a human-readable explanation of the contents or purpose of a summary record. Used in clinical documentation, care coordination, and utilization management to communicate key findings, decisions, or classifications associated with a patient encounter or administrative transaction.

summary detailsumm_dtl

Granular supplementary information associated with a summary record that provides additional context beyond high-level fields. Used in clinical data warehouses, claims systems, and care management platforms to store line-level or expanded data supporting the top-level summary for reporting and downstream processing.

PreviousPage 683 of 806Next