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

patient glucosept_gluc

The measured blood glucose concentration for a patient, recorded in mg/dL or mmol/L. Used in clinical data systems to monitor diabetes management, screen for hypoglycemia or hyperglycemia, guide insulin dosing, and assess metabolic status during inpatient and outpatient encounters.

patient hemoglobinpt_hgb

The measured hemoglobin concentration in a patient's blood, expressed in g/dL. Recorded in laboratory and clinical information systems to assess anemia severity, monitor response to treatment, evaluate surgical readiness, and support transfusion threshold decision-making in care management.

patient oxygen saturationpt_o2sat

The measured peripheral oxygen saturation level for a patient, expressed as a percentage of oxygenated hemoglobin. Captured as a vital sign via pulse oximetry in clinical systems to monitor respiratory status, detect hypoxemia, and guide oxygen therapy decisions during care encounters.

patient pulsept_pulse

The recorded heart rate measurement for a patient, expressed in beats per minute. Documented as a vital sign in clinical information systems to assess cardiovascular status, detect arrhythmias, monitor response to treatment, and establish baseline physiological data across care settings.

patient respirationpt_resp

The recorded respiratory rate for a patient, expressed in breaths per minute. Captured as a vital sign in clinical systems to monitor pulmonary function, detect respiratory distress, assess deterioration in acutely ill patients, and support early warning scoring in inpatient settings.

payer admission datepyr_admn_dt

The inpatient admission date associated with a payer record on a healthcare claim or authorization. Used in claims processing and utilization management systems to establish the covered service period, validate prior authorization windows, and calculate inpatient benefit eligibility and reimbursement.

payer discharge datepyr_dsch_dt

The inpatient discharge date associated with a payer record on a healthcare claim or authorization. Used in claims adjudication and utilization management systems to determine the end of a covered inpatient stay, calculate length of stay, and finalize reimbursement calculations for the episode.

payer emergency indicatorpyr_emerg_ind

A flag on a payer record or claim indicating that the associated service was rendered under emergency conditions. Used in claims adjudication to apply appropriate benefit rules, waive prior authorization requirements, and ensure correct reimbursement when a member seeks urgent unplanned care.

payer history present illnesspyr_hpi

Narrative description of a patient's current condition as documented in relation to a specific insurance payer's records. Captures the chronological account of symptom onset, duration, and progression used in claims adjudication and clinical documentation tied to payer-specific encounters.

payer labelpyr_lbl

Display name or descriptive text identifying a specific insurance payer within claims processing and billing systems. Used to render the correct payer name on remittance advice, explanation of benefits documents, and member-facing communications across healthcare billing workflows.

payer procedure datepyr_proc_dt

The calendar date on which a clinical procedure was performed as reported to and recognized by the insurance payer for claims adjudication. This date drives timely filing determinations, coordination of benefits sequencing, and reimbursement eligibility validation in claims processing systems.

payer rangepyr_rng

The defined minimum and maximum value boundaries established by an insurance payer for reimbursable amounts, contractual allowances, or fee schedule thresholds. Used in claims adjudication systems to validate submitted charges and apply payer-specific payment rules during remittance processing.

payer resultpyr_rslt

The adjudication outcome returned by an insurance payer following claims review, indicating payment approval, denial, partial payment, or pending status. Captured in claims management systems to reconcile billed charges against remittance advice and drive accounts receivable follow-up workflows.

payer surgery datepyr_surg_dt

The calendar date on which a surgical procedure was performed as submitted to and recorded by the insurance payer for claims processing. This date is used to verify medical necessity timelines, apply correct procedure billing periods, and support prior authorization validation in surgical claims adjudication.

pediatric active indicatorped_actv_ind

A binary flag indicating whether a pediatric patient record, care plan, or clinical episode is currently active within the healthcare system. Used in EHR and care management platforms to filter active versus inactive pediatric patients for scheduling, reporting, and population health workflows.

pediatric active statusped_actv_sts

A categorical status value describing the current activity state of a pediatric patient's record, enrollment, or treatment episode. Supports care coordination workflows by distinguishing actively enrolled, discharged, or suspended pediatric cases within clinical and administrative healthcare systems.

pediatric admission dateped_admn_dt

The inpatient facility entry date for a patient receiving care under a pediatric specialty service in EHR or hospital ADT systems. Used by data engineers to segment pediatric encounter records, calculate age-adjusted length of stay, and support PHIS or pediatric quality reporting pipelines.

pediatric ageped_age

The calculated age of a pediatric patient, typically expressed in years, months, or days depending on clinical context. Age is critical in pediatric care for applying age-appropriate reference ranges, developmental milestone assessments, vaccine schedules, and weight-based dosing calculations in clinical systems.

pediatric allowed amountped_alwd_amt

The maximum reimbursable dollar amount approved by the insurance payer for a pediatric patient's healthcare service under the applicable fee schedule or contract terms. This value is used in claims reconciliation to calculate patient cost-sharing obligations and provider payment amounts for pediatric encounters.

pediatric amountped_amt

The monetary value associated with a pediatric specialty service or claim in EHR, billing, or payer systems. Used by data engineers to calculate pediatric cost-of-care metrics, reconcile CHIP or Medicaid pediatric payments, and support financial reporting within pediatric service line analytics.

PreviousPage 490 of 806Next