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

out of pocket rangeoop_rng

The defined minimum and maximum thresholds for a member's out-of-pocket cost exposure under a health plan, such as annual deductible range or OOP maximum limits. Used in benefit design, member cost estimation tools, and actuarial modeling to communicate and calculate cost-sharing boundaries.

out of pocket resultoop_rslt

The calculated patient cost-sharing amount resulting from claims adjudication, reflecting the actual out-of-pocket expense owed by the member after insurance payments are applied. Used in EOB generation, member billing, and OOP maximum accumulator tracking within health plan systems.

out of pocket surgery dateoop_surg_dt

The date on which a surgical procedure was performed that triggered member out-of-pocket cost obligations under their health plan. Used in claims adjudication to assign cost-sharing responsibility, apply deductibles and coinsurance, and track progress toward the member's annual OOP maximum.

outcome admission dateoutc_admn_dt

The inpatient hospital admission date associated with a clinical outcome measurement, used to anchor outcome tracking to the start of a care episode. Applied in quality reporting, readmission analysis, and population health programs to evaluate care effectiveness from point of admission.

outcome discharge dateoutc_dsch_dt

The date a patient was discharged from an inpatient facility, marking the end of a care episode used to measure clinical outcomes. Used in quality measurement, readmission rate reporting, and post-acute care tracking to evaluate treatment results and inform value-based care programs.

outcome labeloutc_lbl

The descriptive text assigned to a clinical outcome category, such as recovered, improved, readmitted, or deceased. Used in quality reporting systems, disease management programs, and population health analytics to classify and communicate treatment results in a standardized, reportable format.

outcome procedure dateoutc_proc_dt

The date on which a clinical procedure was performed that is associated with a recorded patient outcome. Used in outcomes tracking systems to correlate specific interventions with results, supporting quality measurement, clinical research, and longitudinal care analysis.

outcome surgery dateoutc_surg_dt

The date on which a surgical intervention was performed that is directly linked to a documented patient outcome. Used in surgical outcomes registries and clinical data systems to measure recovery timelines, complication rates, and procedure effectiveness over time.

panel admission datepnl_admn_dt

The inpatient facility entry date associated with a grouped set of related diagnostic tests or lab orders in EHR or LIS systems. Used by data engineers to align panel ordering events with encounter timelines, DRG assignment logic, and inpatient clinical data mart structures.

panel discharge datepnl_dsch_dt

The facility release date linked to a grouped set of related diagnostic tests or lab orders in EHR or LIS systems. Used by data engineers to bound inpatient panel activity within encounter records, support length-of-stay calculations, and validate claims adjudication timelines.

panel labelpnl_lbl

The human-readable display name assigned to a laboratory or diagnostic test panel grouping multiple related tests ordered together. Used in lab information systems and clinical workflows to identify and present bundled test orders such as a Basic Metabolic Panel or Lipid Panel.

panel procedure datepnl_proc_dt

The date on which a grouped set of diagnostic or laboratory procedures within a test panel was performed. Used in lab information systems to timestamp panel execution, enabling result tracking, turnaround time analysis, and alignment with clinical episodes of care.

panel surgery datepnl_surg_dt

The date of a surgical procedure associated with a grouped diagnostic or laboratory panel order. Used in clinical data systems to link panel-level test results with a specific operative event, supporting perioperative monitoring and surgical outcome documentation.

pathologist admission datepath_admn_dt

The date a pathologist was admitted or formally associated with a patient encounter or case in a clinical or hospital setting. Used in case management and laboratory information systems to track pathologist involvement timelines for anatomic or clinical pathology consultations.

pathologist discharge datepath_dsch_dt

The date a pathologist's involvement in a patient case or hospital encounter was formally concluded. Used in laboratory information systems and case tracking workflows to document the duration of pathology consultation and finalize case disposition records.

pathologist labelpath_lbl

The human-readable display name or identifier assigned to a pathologist in a laboratory or clinical information system. Used to attribute diagnostic findings, tissue analyses, and case reviews to the responsible pathologist for reporting, accountability, and audit purposes.

pathologist procedure datepath_proc_dt

The date on which a pathologist performed a diagnostic procedure such as a tissue biopsy review, autopsy, or cytology examination. Used in laboratory information systems to timestamp pathology work, supporting case tracking, turnaround benchmarking, and clinical reporting.

pathologist surgery datepath_surg_dt

The date of a surgical procedure for which a pathologist provided intraoperative consultation or post-operative specimen analysis. Used in laboratory and surgical information systems to link pathology findings with operative events for case documentation and outcomes tracking.

patient blood pressurept_bp

The recorded arterial blood pressure measurement for a patient, typically expressed as systolic over diastolic values in mmHg. Captured as a vital sign in clinical encounters, this value supports hypertension monitoring, cardiovascular risk assessment, and chronic disease management workflows.

patient creatininept_cr

The measured serum or urine creatinine level for a patient, used as a primary biomarker of renal function. Documented in clinical and lab information systems to assess kidney health, stage chronic kidney disease, monitor nephrotoxic drug dosing, and evaluate acute kidney injury.

PreviousPage 489 of 806Next