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 racesumm_race

The patient's self-reported racial classification captured within a clinical or administrative summary record. Used in population health management, health equity analysis, and regulatory reporting to identify disparities in care access, outcomes, and service utilization across demographic groups.

summary rangesumm_rng

The minimum and maximum boundary values associated with a clinical measurement or data element within a summary record. Used in laboratory results interpretation, vital signs monitoring, and quality metrics reporting to define normal reference intervals or acceptable thresholds for flagging abnormal findings.

summary ratesumm_rt

The per-unit pricing or frequency value associated with a service or clinical measurement captured in a summary record. Used in claims reimbursement calculations, pharmacy benefit management, and actuarial analysis to determine payment amounts or measure the frequency of events per defined time period.

summary ratingsumm_rtg

A scored or graded assessment value assigned to a clinical condition, plan, provider, or health program within a summary record. Used in quality measurement, health plan star ratings, risk stratification, and utilization review to standardize evaluations and support performance benchmarking across populations.

summary ratiosumm_ratio

A proportional value expressing the relationship between two clinical or administrative measurements within a summary record. Used in quality reporting, pharmacy benefit analysis, and population health metrics to calculate rates such as medication adherence ratios, cost-to-utilization comparisons, or clinical outcome proportions.

summary reasonsumm_rsn

The explanatory text or coded rationale describing why a clinical action, administrative decision, or status change was taken as recorded in a summary. Used in prior authorization workflows, claims adjustments, care management documentation, and audit trails to provide context for decisions affecting patient care or coverage.

summary received datesumm_rcvd_dt

The date on which a clinical document, referral, authorization request, or administrative summary was received by the processing entity. Used in claims intake, utilization management, and care coordination workflows to track timeliness of submission, trigger response deadlines, and support regulatory compliance reporting.

summary referencesumm_ref

An identifier or pointer linking a summary record to an external document, encounter, claim, or system of record. Used in care coordination, claims cross-referencing, and health information exchange to maintain traceability between summarized data and its originating source records across systems.

summary resolution datesumm_resol_dt

The date on which a clinical condition, complaint, issue, or administrative matter documented in a summary was resolved or closed. Used in chronic disease management, case management, and claims processing to track the duration of conditions or issues and assess timeliness of interventions and outcomes.

summary respirationsumm_resp

The recorded respiratory rate, expressed in breaths per minute, captured within a clinical summary record. Used in vital signs documentation, acute care monitoring, and longitudinal health tracking to assess pulmonary and cardiovascular status, flag deterioration, and support clinical decisions across patient encounters.

summary resultsumm_rslt

The outcome value or finding produced by a clinical test, procedure, or intervention as recorded in a summary. Used in laboratory reporting, diagnostic imaging, care management, and quality measurement to communicate actionable findings, track treatment responses, and support evidence-based clinical decision-making.

summary revisionsumm_rev

A sequential version number or iteration count tracking updates made to a clinical or administrative summary record over time. Used in document management, care plan maintenance, and audit workflows to ensure the most current version is referenced and to maintain a complete history of changes for compliance purposes.

summary risksumm_rsk

A scored or categorized assessment of the likelihood or severity of an adverse clinical, financial, or operational outcome as captured in a summary record. Used in care management stratification, underwriting, utilization review, and population health programs to prioritize interventions and allocate resources to high-risk individuals.

summary routesumm_rte

The medication administration pathway documented in a clinical summary record, such as oral, intravenous, or topical. Captures how a drug is delivered to the patient and is critical for medication reconciliation, care transitions, and discharge summary documentation.

summary scoresumm_scr

A calculated numeric value derived from clinical assessment tools documented within a patient summary, such as APACHE, Glasgow Coma Scale, or risk stratification scores. Used to quantify patient acuity, treatment response, or outcome measures across care episodes.

summary sequencesumm_seq

A numeric ordering value that determines the display or processing order of summary records within a patient's clinical history. Ensures that multiple summary entries are presented in the correct logical or chronological order within health information systems.

summary severitysumm_sev

A coded classification indicating the clinical seriousness of a condition, diagnosis, or adverse event as documented in a patient summary. Values typically range from mild to life-threatening and inform prioritization of care, utilization management, and quality reporting.

summary sexsumm_sex

The biological sex classification of the patient as recorded in a clinical or administrative summary record. Used for demographic reporting, sex-specific clinical decision support, eligibility determination, and population health analytics across enrollment and claims data.

summary sourcesumm_src

Identifies the originating system, facility, or data feed from which a clinical summary record was generated or received. Critical for data provenance, audit trails, and reconciling information across multiple contributing healthcare systems or care settings.

summary start datesumm_start_dt

The calendar date marking the beginning of the clinical event, treatment episode, or condition documented in a summary record. Used in longitudinal patient tracking, care gap analysis, chronic disease management, and episode-of-care reporting across clinical data systems.

PreviousPage 687 of 806Next