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 approval statusped_appr_sts

The current authorization state of a requested service, referral, or care plan for a pediatric patient, reflecting whether prior authorization has been approved, denied, or is pending insurer review. Used in utilization management systems to control access to covered pediatric services.

pediatric approved byped_appr_by

The name or identifier of the clinician, administrator, or system user who granted authorization for a pediatric patient's care request, order, or treatment plan. Captured in clinical workflows to maintain an audit trail of approval decisions and support accountability in pediatric care management.

pediatric arrival timeped_arrv_tm

The recorded clock time at which a pediatric patient arrived at a clinical facility, emergency department, or outpatient setting. Used in operational reporting to measure door-to-provider intervals, triage efficiency, and compliance with pediatric-specific throughput benchmarks in acute and ambulatory care settings.

pediatric arrived dateped_arrv_dt

The calendar date on which a pediatric patient presented to a healthcare facility for a scheduled or unscheduled visit. Used in encounter documentation, scheduling systems, and operational analytics to establish the episode start date for pediatric care delivery and subsequent billing workflows.

pediatric assessmentped_asmt

The clinician's structured evaluation of a pediatric patient's health status, incorporating physical examination findings, developmental screening results, and diagnostic impressions. Documents the clinical reasoning supporting diagnosis and treatment planning within pediatric encounter notes in EHR systems.

pediatric balanceped_bal

The outstanding financial amount remaining for a pediatric specialty service after payments or adjustments in billing or EHR systems. Used by data engineers to track pediatric accounts receivable, support CHIP or Medicaid reconciliation workflows, and identify unpaid pediatric claim balances.

pediatric billed amountped_bill_amt

The total dollar amount invoiced by a healthcare provider for services rendered to a pediatric patient prior to payer adjudication or contractual adjustment. Recorded in claims and revenue cycle systems as the gross charge submitted to insurance for pediatric encounters, procedures, and related services.

pediatric birth dateped_birth_dt

The recorded date of birth for a patient in a pediatric care context, used in EHR and member enrollment systems to calculate age-based eligibility, dosing thresholds, and developmental milestones for patients under 18 years of age.

pediatric blood pressureped_bp

The measured systolic and diastolic arterial pressure values recorded for a pediatric patient, interpreted against age, sex, and height-specific normative percentile tables. A critical vital sign in pediatric clinical documentation used to screen for hypertension and monitor cardiovascular health in children.

pediatric cancelled dateped_cncl_dt

The calendar date on which a scheduled pediatric appointment, procedure, or service was officially cancelled within the healthcare system. Used in scheduling and operational reporting to track cancellation patterns, measure no-show rates, and support capacity planning for pediatric care services.

pediatric categoryped_cat

A classification grouping applied to pediatric patient records or services in EHR and claims systems, used to segment care populations by age band such as neonate, infant, toddler, or adolescent for reporting and clinical decision support.

pediatric charge amountped_chrg_amt

The gross fee assessed by a healthcare provider for a specific service or procedure delivered to a pediatric patient before insurance adjustments or patient payments are applied. Used in revenue cycle management to establish the starting point for claims submission and payer contract reconciliation.

pediatric chief complaintped_cc

The primary symptom, concern, or reason for visit as reported by the pediatric patient or caregiver at the time of encounter. Documented in the patient's own or caregiver's words within clinical records, this element drives triage prioritization, clinical assessment, and coding for pediatric encounters.

pediatric childped_chld

A relational identifier linking a dependent minor to a parent or guardian record in member enrollment and EHR systems, supporting family unit tracking, benefits coordination, and dependent eligibility verification within pediatric care workflows.

pediatric cityped_city

The municipality name associated with a pediatric patient or pediatric care facility record. Used in member enrollment, claims processing, and care coordination to identify the city component of a mailing or service address for patients under 18 years of age.

pediatric classped_cls

A hierarchical classification tier assigned to pediatric records or service lines in EHR and claims systems, used to group patients or procedures into structured tiers for clinical analytics, billing categorization, and population health reporting.

pediatric codeped_cd

A standardized alphanumeric value applied to pediatric diagnoses, procedures, or specialties in claims and EHR systems, typically referencing ICD-10, CPT, or SNOMED coding sets specific to patients under 18 years of age in clinical workflows.

pediatric commentped_cmt

A free-text notation field associated with a pediatric patient record or encounter in EHR and care management systems, capturing clinical observations, caregiver notes, or administrative remarks not represented by structured data elements.

pediatric completed dateped_cmpl_dt

The date on which a pediatric clinical service, referral, care plan, or treatment episode was fully completed. Used in care management and utilization tracking to measure time-to-completion and monitor outcomes for patients receiving pediatric specialty care.

pediatric confidential indicatorped_conf_ind

A flag indicating that a pediatric patient record or associated clinical information is subject to heightened privacy restrictions. Used in EHR and health information systems to control access to sensitive data such as behavioral health, reproductive services, or abuse-related records for minor patients.

PreviousPage 491 of 806Next