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

study total countstdy_tot_cnt

The cumulative count of discrete items associated with a radiology or diagnostic imaging examination, such as total image instances, series, or procedure occurrences. Used in PACS and RIS reporting to measure imaging volume, monitor storage utilization, and validate study completeness.

study typestdy_typ

The classification category of a radiology or diagnostic imaging examination indicating the modality or clinical purpose, such as CT, MRI, ultrasound, or X-ray. Used in RIS and PACS to route studies to appropriate reading queues, apply protocol rules, and support imaging utilization analytics.

study updated datestdy_upd_dt

The date on which a radiology or diagnostic imaging examination record was most recently modified in the imaging system. Used in RIS and PACS for change tracking, synchronization between downstream clinical systems, and audit compliance to identify when study metadata or results were last revised.

study urgencystdy_urg

The clinical priority or time-sensitivity level assigned to a radiology or diagnostic imaging examination, such as STAT, urgent, or routine. Used in RIS worklist management to determine reading order prioritization, turnaround time expectations, and escalation protocols for critical findings.

study versionstdy_ver

The sequential version number tracking revisions to a radiology or diagnostic imaging examination record, including updates to study metadata, amended radiology reports, or corrected procedure codes. Used in RIS and PACS to maintain a complete audit history of changes throughout the study lifecycle.

study zipstdy_zip

The postal ZIP code associated with the facility or location where a radiology or diagnostic imaging examination was performed. Used in imaging data systems for geographic analysis of imaging utilization, site-level reporting, and population health studies linking imaging services to patient residence areas.

subscriber blood pressuresubscr_bp

The systolic and diastolic arterial blood pressure measurement recorded for the primary insurance policy holder. Captured in member health records or wellness programs to support care management interventions, chronic condition monitoring, and population health stratification within health plan data systems.

subscriber creatininesubscr_cr

The serum creatinine laboratory value recorded for the primary insurance policy holder, used as a biomarker of kidney filtration function. Referenced in health plan care management and utilization data to identify members at risk for chronic kidney disease and guide targeted outreach or case management programs.

subscriber glucosesubscr_gluc

The blood glucose measurement recorded for the primary insurance policy holder, indicating current blood sugar levels. Used in health plan care management systems to identify and monitor members with diabetes or prediabetes, support disease management program enrollment, and track clinical outcome improvements over time.

subscriber hemoglobinsubscr_hgb

The blood hemoglobin concentration recorded for the primary insurance policy holder, reflecting oxygen-carrying capacity and screening for anemia. Used in health plan care management and member wellness programs to identify clinical risk, support chronic disease monitoring, and inform population health stratification decisions.

subscriber oxygen saturationsubscr_o2sat

The peripheral blood oxygen saturation percentage recorded for the primary insurance policy holder, typically measured via pulse oximetry. Used in health plan care management systems to monitor members with respiratory or cardiac conditions, flag clinical deterioration risk, and support remote patient monitoring program data integration.

subscriber pulsesubscr_pulse

The resting heart rate measurement in beats per minute recorded for the primary insurance policy holder. Used in health plan member health records and care management programs to monitor cardiovascular health, identify members with arrhythmia risk or heart failure, and support clinical intervention targeting within population health analytics.

subscriber respirationsubscr_resp

The respiratory rate measurement in breaths per minute recorded for the primary insurance policy holder. Used in health plan care management and member clinical data systems to monitor pulmonary conditions such as COPD or asthma, assess acute illness severity, and support care coordination programs targeting high-risk members.

substitution admission datesub_admn_dt

The inpatient admission date associated with a drug substitution event, typically recorded when a therapeutic substitution occurs during a hospital stay. Used in pharmacy and claims data to correlate alternative medication dispensing with inpatient encounter timelines.

substitution discharge datesub_dsch_dt

The inpatient discharge date associated with a drug substitution event, capturing when a patient was released following an encounter where a therapeutic alternative was dispensed. Used in pharmacy and claims data to define the duration of the substitution episode.

substitution emergency indicatorsub_emerg_ind

A flag indicating whether a drug substitution was performed under emergency circumstances, such as a formulary shortage or urgent clinical need. Used in pharmacy dispensing records to distinguish routine therapeutic substitutions from those driven by emergent clinical or supply conditions.

substitution history present illnesssub_hpi

A narrative description of the clinical condition or presenting illness that prompted a therapeutic drug substitution. Captured in pharmacy or clinical documentation to provide context for why an alternative medication was selected over the originally prescribed treatment.

substitution labelsub_lbl

The display name or descriptive label assigned to a therapeutic drug substitution record, identifying the alternative medication dispensed in place of the originally prescribed drug. Used in pharmacy systems to clearly communicate substitution details to clinical staff and patients.

substitution procedure datesub_proc_dt

The date on which a clinical procedure was performed in conjunction with or as a result of a therapeutic drug substitution. Used in pharmacy and clinical records to link the alternative medication dispensing event to a specific procedural intervention or treatment date.

substitution rangesub_rng

The acceptable value span or dosage limits defined for a therapeutic drug substitution, specifying the minimum and maximum parameters within which an alternative medication may be dispensed. Used in pharmacy systems to ensure substitutions remain within clinically approved boundaries.

PreviousPage 681 of 806Next