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

pediatric numberped_nbr

A numeric reference value assigned to identify a pediatric specialty record, order, or transaction in EHR, billing, or claims systems. Used by data engineers to perform deterministic record linkage, validate referential integrity, and support cross-system reconciliation within pediatric data integration pipelines.

pediatric onset dateped_onset_dt

Captures the date when symptoms, diagnoses, or conditions first appeared in a pediatric patient. Critical for determining disease progression, treatment timelines, and clinical decision-making in pediatric care settings, including inpatient, outpatient, and specialty visits.

pediatric oxygen saturationped_o2sat

Records the peripheral blood oxygen saturation level (SpO2) measured for a pediatric patient, typically via pulse oximetry. A key vital sign used in monitoring respiratory status, guiding intervention decisions, and assessing clinical stability in pediatric care encounters.

pediatric paid amountped_pd_amt

Represents the dollar amount paid on a claim or service rendered for a pediatric patient, including insurer payments, copays, or capitation settlements. Used in healthcare financial reporting, claims adjudication, and reimbursement reconciliation for pediatric service lines.

pediatric paid dateped_pd_dt

Records the date on which payment was issued or posted for a pediatric patient claim or healthcare service. Used in claims processing, accounts receivable tracking, and financial reporting to monitor reimbursement cycles within pediatric billing operations.

pediatric parentped_prnt

The superior or parent entity in a hierarchical relationship associated with a pediatric specialty record in EHR or clinical data warehouse systems. Used by data engineers to model parent-child data structures, resolve rollup logic in pediatric program hierarchies, and maintain referential integrity across related clinical datasets.

pediatric percentageped_pct

Ratio of pediatric patients or services relative to a total population or service volume within a healthcare specialty. Used in EHR analytics, provider profiling, and claims systems to assess pediatric case mix, specialty utilization, and network adequacy for child health services.

pediatric periodped_prd

Defined time span during which a patient qualifies as pediatric, typically age 0-17, used in EHR, claims, and member enrollment systems to apply age-specific clinical protocols, benefit structures, reimbursement rates, and quality measure denominator logic for child healthcare specialties.

pediatric phoneped_ph

Telephone contact number associated with a pediatric specialty provider, clinic, or department. Stored in provider directories, EHR systems, and claims reference data to facilitate care coordination, referral routing, and member services communication for child healthcare specialty services.

pediatric preferred nameped_pref_nm

Stores the name a pediatric patient or their guardian prefers to use in clinical communications and care settings. Supports person-centered care, accurate patient identification, and respectful engagement across EHR displays, appointment scheduling, and care coordination workflows.

pediatric priceped_prc

Represents the billed or contracted cost of a healthcare service, procedure, or supply provided to a pediatric patient. Used in charge capture, claims submission, fee schedule management, and cost analysis reporting within pediatric clinical and financial systems.

pediatric primary indicatorped_prim_ind

A flag designating whether a record, diagnosis, insurance coverage, or care relationship is the primary one associated with a pediatric patient. Used to establish billing priority, clinical focus, and data hierarchy in claims processing and care coordination workflows.

pediatric priorityped_prty

Importance ranking assigned to pediatric-specific services, diagnoses, or workflows within EHR and care management systems. Used to triage and sequence child healthcare encounters, referrals, and clinical alerts, ensuring age-appropriate care protocols are applied in downstream processing and reporting pipelines.

pediatric procedure dateped_proc_dt

Records the date on which a clinical procedure, treatment, or surgical intervention was performed on a pediatric patient. Essential for claims adjudication, clinical documentation, care timeline tracking, and quality reporting within pediatric inpatient and outpatient settings.

pediatric pulseped_pulse

Captures the heart rate in beats per minute recorded during a pediatric patient encounter or monitoring event. A core vital sign used to assess cardiovascular status, guide clinical decisions, and track physiological trends across pediatric inpatient and outpatient care settings.

pediatric quantityped_qty

Count or volume metric associated with pediatric-specific services, medications, or procedures recorded in EHR, pharmacy, or claims systems. Used to validate dosage calculations, supply dispensing, and utilization reporting for patients under 18, ensuring age-appropriate quantity thresholds are applied in adjudication and analytics workflows.

pediatric raceped_race

Records the self-reported or guardian-reported racial identity of a pediatric patient as defined by standardized classifications such as OMB categories. Used in health equity reporting, population health analytics, and meeting regulatory requirements for demographic data collection in pediatric care.

pediatric rangeped_rng

Acceptable value span for clinical measurements, dosages, or utilization metrics specific to pediatric patients in EHR and pharmacy systems. Defines minimum and maximum thresholds used during claims adjudication, drug utilization review, and clinical decision support to flag out-of-range values for patients under 18.

pediatric rateped_rt

Unit price or reimbursement value assigned to pediatric-specific services, procedures, or medications within claims, PBM, or fee schedule systems. Used during adjudication to apply age-tiered pricing rules, ensuring correct payment calculation for providers rendering services to members under 18 years of age.

pediatric ratingped_rtg

Stores a scored or categorical assessment value applied to a pediatric patient, condition severity, service quality, or clinical tool result. Used in risk stratification, quality measurement, and clinical decision support processes within pediatric care management and reporting systems.

PreviousPage 495 of 806Next