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

physician blood pressurephys_bp

Systolic and diastolic arterial blood pressure measurement recorded by a licensed physician during a patient encounter. This vital sign supports hypertension diagnosis, cardiovascular risk assessment, and ongoing chronic disease management, and is documented as part of the physician's clinical examination findings.

physician creatininephys_cr

Serum or plasma creatinine laboratory value ordered or reviewed by a licensed physician to assess renal filtration function. Used in clinical decision-making for chronic kidney disease staging, medication dosing adjustments, and monitoring of patients with diabetes or cardiovascular conditions.

physician glucosephys_gluc

Blood glucose concentration measured or reviewed by a licensed physician, used to evaluate metabolic status and screen for or manage diabetes mellitus. Values may reflect fasting, random, or post-prandial measurements and inform treatment decisions, medication adjustments, and care plan updates.

physician hemoglobinphys_hgb

Hemoglobin concentration in the blood, measured or reviewed by a licensed physician to assess oxygen-carrying capacity and screen for anemia or related hematologic conditions. Used to guide treatment decisions including iron supplementation, transfusion thresholds, and chronic disease management protocols.

physician oxygen saturationphys_o2sat

Records the peripheral oxygen saturation (SpO2) percentage measured for a physician during a clinical encounter, typically captured via pulse oximetry. Used in clinical documentation to track the treating physician's own vital signs when they are also a patient receiving care.

physician pulsephys_pulse

Records the heart rate in beats per minute measured for a physician who is receiving clinical care. Captured as part of vital sign documentation during encounters where the physician is the patient, supporting clinical decision-making and longitudinal health monitoring in EHR systems.

physician respirationphys_resp

Records the respiratory rate in breaths per minute measured for a physician receiving clinical care. Captured during vital sign assessment when the physician is the patient, supporting clinical documentation, triage decisions, and longitudinal health tracking within EHR platforms.

plan admission datepln_admn_dt

Date a member is admitted to a facility under a specific health benefit plan, captured in claims and enrollment systems to align inpatient authorization records, apply plan-specific cost-sharing rules, and initiate concurrent review workflows tied to the applicable coverage structure.

plan discharge datepln_dsch_dt

Date a member is discharged from a facility under a specific health benefit plan, recorded in claims and care management systems to close inpatient authorization periods, calculate length-of-stay metrics, trigger post-discharge follow-up protocols, and finalize plan-level adjudication.

plan emergency indicatorpln_emerg_ind

A binary flag within benefit plan records indicating whether an encounter or service request qualifies as an emergency under the terms of a specific health benefit plan. Drives adjudication logic, cost-sharing calculations, and coverage determination rules in claims processing systems.

plan history present illnesspln_hpi

Stores the History of Present Illness (HPI) narrative associated with a specific benefit plan clinical encounter. Documents the chronological description of a patient's chief complaint and symptom progression, used in clinical coding, care planning, and utilization management workflows.

plan labelpln_lbl

The human-readable display name or descriptive text assigned to a health benefit plan in enrollment and claims systems. Used to identify and distinguish plan offerings across member-facing portals, EOB documents, eligibility transactions, and internal reporting dashboards.

plan procedure datepln_proc_dt

Records the scheduled or actual date on which a clinical procedure is planned or performed under a specific health benefit plan. Used in prior authorization workflows, claims adjudication, and care coordination to validate service timing against plan coverage periods and benefit rules.

plan rangepln_rng

Defined minimum and maximum value boundaries associated with a health benefit plan, such as allowable charge limits, covered day ranges, or benefit maximums. Used in claims adjudication and PBM systems to validate submitted values against plan-specific coverage parameters during processing.

plan resultpln_rslt

Outcome or determination produced by applying health benefit plan rules to a claim, authorization, or clinical event. Captured in claims adjudication and EHR systems to record payment decisions, coverage findings, or clinical program outcomes tied to a specific benefit plan configuration.

plan surgery datepln_surg_dt

Records the scheduled or actual date of a surgical procedure associated with a specific health benefit plan. Used in pre-authorization approvals, claims adjudication, and surgical coordination workflows to verify that the operative service falls within the applicable plan coverage period.

policy admission datepol_admn_dt

Date a member covered under a specific insurance policy is admitted to an inpatient facility, stored in claims and enrollment systems to verify active policy coverage at time of admission, apply deductible and out-of-pocket accumulators, and initiate utilization management reviews.

policy discharge datepol_dsch_dt

Date a member is discharged from an inpatient facility under an active insurance policy, recorded in claims and utilization management systems to finalize coverage verification, calculate policy-level length-of-stay, and trigger post-discharge benefit coordination and claims adjudication steps.

policy emergency indicatorpol_emerg_ind

A binary flag on an insurance policy record indicating whether a specific claim or service event meets the emergency criteria defined within the policy terms. Directly influences benefit adjudication, out-of-network cost-sharing waivers, and real-time eligibility responses in claims processing.

policy history present illnesspol_hpi

Stores the History of Present Illness (HPI) narrative linked to a specific insurance policy encounter. Provides the chronological clinical context documenting symptom onset and progression, supporting medical necessity determinations, claims review, and utilization management under the associated policy.

PreviousPage 505 of 806Next