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

substitution resultsub_rslt

The clinical or operational outcome recorded following a therapeutic drug substitution, documenting whether the alternative medication achieved the intended therapeutic effect. Used in pharmacy and clinical quality records to evaluate the effectiveness and safety of substitution decisions.

substitution surgery datesub_surg_dt

The date of a surgical procedure associated with a therapeutic drug substitution event, capturing when an operative intervention occurred in the context of an alternative medication being dispensed. Used in pharmacy and surgical records to coordinate perioperative medication substitution documentation.

summary active indicatorsumm_actv_ind

A binary flag designating whether a patient or claim summary record is currently active within the system. Used in health plan and clinical data management to distinguish current, actionable summary records from those that have been superseded, closed, or archived.

summary active statussumm_actv_sts

A coded status field indicating the current activity state of a patient or claim summary record, providing more granular classification than a binary indicator. Used in health plan and clinical data systems to manage record lifecycle, including active, inactive, pending, or suspended states.

summary admission datesumm_admn_dt

The date a patient was admitted to an inpatient facility, as recorded within a consolidated clinical or claims summary record. Used in utilization management and claims adjudication to anchor the inpatient episode timeline and calculate length of stay and associated reimbursement.

summary agesumm_age

The patient's calculated age as captured within a consolidated clinical or claims summary record, typically derived from date of birth at the time of service or enrollment. Used in population health analytics, risk stratification, and actuarial reporting to segment members by age cohort.

summary allowed amountsumm_alwd_amt

The maximum dollar amount a health plan will reimburse for services rendered, as recorded in an aggregated claims or financial summary record. Used in claims adjudication and payment reconciliation to determine plan liability after applying contracted rates, edits, and benefit limitations.

summary amountsumm_amt

The total monetary value associated with a consolidated claims or financial summary record, representing the aggregate dollar figure for all charges, payments, or adjustments within the summarized period. Used in health plan financial reporting, cost analysis, and member billing reconciliation.

summary approved bysumm_appr_by

The identifier of the user, clinician, or administrator who authorized or approved a consolidated summary record, establishing an audit trail for record validation. Used in clinical documentation and health plan workflows to enforce accountability and compliance with approval governance requirements.

summary arrival timesumm_arrv_tm

The recorded time at which a patient arrived at a care facility, as captured within a consolidated encounter or claims summary record. Used in emergency department and ambulatory care reporting to measure throughput, triage timeliness, and compliance with patient access performance benchmarks.

summary arrived datesumm_arrv_dt

The calendar date on which a patient arrived at a care facility, as recorded within a consolidated encounter or claims summary record. Used in utilization management and facility reporting to establish the start of an encounter episode and support length of stay and access metric calculations.

summary assessmentsumm_asmt

A concise clinical evaluation narrative captured within a consolidated patient summary, documenting the clinician's interpretation of the patient's condition at a specific point in care. Used in care coordination and quality reporting to communicate diagnostic impressions and inform ongoing treatment planning.

summary balancesumm_bal

The remaining outstanding dollar amount owed on a consolidated patient account or claims summary after payments, adjustments, and credits have been applied. Used in health plan and revenue cycle management to track member or payer liability and drive billing follow-up and collections workflows.

summary billed amountsumm_bill_amt

The aggregated invoice total recorded at the summary level of a claim or billing transaction. Represents the gross charges submitted to a payer before adjustments, contractual allowances, or payments are applied. Used in claims processing and financial reconciliation reporting.

summary birth datesumm_birth_dt

The date of birth captured at the summary record level for a patient or member. Used to support age-based eligibility validation, benefit determination, and demographic reporting across enrollment, claims, and clinical data systems where summary-level patient identification is required.

summary blood pressuresumm_bp

The aggregated or most recent systolic and diastolic blood pressure reading recorded at the clinical summary level. Used in population health management, chronic condition monitoring, and care gap reporting to track cardiovascular risk across patient panels or episodes of care.

summary cancelled datesumm_cncl_dt

The date on which a summary-level record, authorization, referral, or service request was cancelled. Used in utilization management and care coordination workflows to track voided transactions, calculate turnaround compliance, and audit authorization lifecycle activity.

summary categorysumm_cat

A classification grouping applied to a summary record that designates its type, subject matter, or functional domain within a clinical or administrative system. Used to organize and filter summary data across reporting workflows, including claims, clinical documentation, and member management.

summary chief complaintsumm_cc

The primary presenting symptom or reason for a clinical encounter as documented at the summary level of a patient record. Captured during intake or discharge documentation, this field supports clinical coding, triage classification, and retrospective analysis of visit patterns across care settings.

summary childsumm_chld

A reference identifier linking a summary record to a subordinate or dependent record within a parent-child hierarchy. Used in clinical and administrative data models to associate summary-level entries with detailed transaction records, encounter sub-records, or dependent member relationships.

PreviousPage 682 of 806Next