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

balance routebal_rte

The designated pathway or method by which an outstanding patient account balance is directed for resolution, such as collections, payment plan, financial assistance, or write-off, within revenue cycle management and billing workflow routing systems.

balance strengthbal_str

The magnitude or severity classification of an outstanding patient or claim balance, used in revenue cycle analytics to prioritize collection efforts, assess financial risk, and segment accounts by balance size within accounts receivable management systems.

balance surgery datebal_surg_dt

The date on which a surgical procedure was performed that is linked to an outstanding patient account balance, used in hospital billing systems to validate claim submission timelines, apply surgical modifiers, and reconcile operative charges in revenue cycle workflows.

bed admission datebed_admn_dt

The date a patient is officially assigned to a specific inpatient bed unit within a hospital or facility. Captured in EHR and ADT systems to track occupancy timelines, calculate length of stay, and support UB-04 institutional claims processing.

bed discharge datebed_dsch_dt

The date on which a patient was formally released from a specific accommodation unit in EHR and ADT systems. Critical for calculating unit-level length of stay, bed turnover rates, and capacity utilization metrics in clinical data warehouses, and used in UB-04 claims to validate inpatient accommodation revenue code billing periods.

bed labelbed_lbl

The identifying display text assigned to a specific inpatient bed unit within a facility, used in hospital information systems to designate bed location, type, or status across nursing units, enabling census tracking, patient assignment, and capacity management workflows.

bed procedure datebed_proc_dt

The date a clinical procedure was performed in association with a specific inpatient bed assignment, recorded in hospital information systems to support charge capture, clinical documentation, and length-of-stay analysis tied to bed-level care delivery.

bed surgery datebed_surg_dt

The date a surgical procedure was performed that is linked to a specific inpatient bed assignment, used in hospital information systems to coordinate post-operative bed placement, track surgical throughput, and support bed management and discharge planning workflows.

beneficiary admission datebenf_admn_dt

The calendar date on which a health insurance beneficiary was formally admitted to an inpatient facility, recorded in claims and enrollment systems to determine covered days, apply benefit limits, and calculate length-of-stay for Medicare, Medicaid, or commercial plan adjudication.

beneficiary blood pressurebenf_bp

The systolic and diastolic arterial pressure reading recorded for an insurance beneficiary, captured in clinical or claims data to support chronic condition management, HEDIS quality measures, and population health reporting for enrolled plan members.

beneficiary creatininebenf_cr

The serum creatinine laboratory value recorded for an insurance beneficiary, used as a marker of renal function in clinical and claims data to support chronic kidney disease staging, medication safety monitoring, and quality measure reporting for enrolled health plan members.

beneficiary discharge datebenf_dsch_dt

The calendar date on which an insurance beneficiary was formally released from an inpatient facility, recorded in claims and enrollment systems to calculate covered length of stay, trigger post-discharge benefits, and support readmission monitoring for health plan reporting.

beneficiary glucosebenf_gluc

The blood glucose laboratory or monitoring value recorded for an insurance beneficiary, used in clinical and claims data to track diabetes management, assess glycemic control, and support HEDIS and population health quality measure reporting for enrolled health plan members.

beneficiary hemoglobinbenf_hgb

The hemoglobin laboratory value recorded for an insurance beneficiary, used in clinical and claims data to assess anemia, monitor chronic conditions such as CKD or diabetes, and support population health quality reporting and care management programs for enrolled plan members.

beneficiary labelbenf_lbl

The display text or descriptive identifier assigned to an insurance beneficiary record, used in claims, enrollment, and member management systems to present beneficiary information in reports, correspondence, portal interfaces, and eligibility verification workflows for health plans.

beneficiary oxygen saturationbenf_o2sat

The peripheral blood oxygen saturation percentage recorded for an insurance beneficiary, used in clinical and claims data to monitor respiratory conditions, support COPD and heart failure care management programs, and inform population health quality reporting for enrolled health plan members.

beneficiary procedure datebenf_proc_dt

The calendar date on which a medical procedure was performed for an insurance plan beneficiary. Used in claims processing and clinical records to establish service timelines, verify coverage eligibility, and support coordination of benefits determinations.

beneficiary pulsebenf_pulse

The recorded heart rate in beats per minute for an insurance plan beneficiary at the time of a clinical encounter. Captured as a vital sign measurement in clinical and claims data to support medical necessity reviews, risk stratification, and longitudinal health monitoring.

beneficiary respirationbenf_resp

The recorded breathing rate in breaths per minute for an insurance plan beneficiary at the time of a clinical encounter. Captured as a vital sign in clinical documentation to support medical necessity determinations, acuity assessments, and population health analytics.

beneficiary surgery datebenf_surg_dt

The calendar date on which a surgical procedure was performed for an insurance plan beneficiary. Used in claims adjudication and clinical records to confirm service timelines, validate pre-authorization compliance, and coordinate post-operative benefit coverage.

PreviousPage 75 of 806Next