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 end dateped_end_dt

The date marking the conclusion of a pediatric record, care episode, or benefit period in EHR and member enrollment systems, used to close active designations, terminate eligibility, and define service date ranges for claims adjudication.

pediatric end timeped_end_tm

The exact time at which a pediatric clinical encounter, procedure, therapy session, or observation period concluded. Used in scheduling, clinical documentation, and billing workflows to record the precise completion timestamp for services rendered to patients under 18, supporting accurate duration and resource calculations.

pediatric entered byped_ent_by

The identifier of the user or system responsible for manually entering data into a pediatric patient or clinical record. Used in audit trail and data quality workflows to distinguish the data entry user from the record creator, supporting accountability and error tracking in pediatric care documentation systems.

pediatric ethnicityped_ethn

The self-reported or administratively assigned ethnicity classification for a pediatric patient. Used in member enrollment, population health analytics, and health equity reporting to identify ethnic background for patients under 18, supporting disparity analysis, culturally competent care planning, and regulatory reporting requirements.

pediatric expiration dateped_exp_dt

The date after which a pediatric authorization, benefit, or clinical designation is no longer valid in claims and member enrollment systems, used to enforce coverage limits, trigger renewal workflows, and flag lapsed eligibility for pediatric patients.

pediatric external identifierped_ext_id

A reference identifier assigned by an external system, such as a referring hospital, payer, or registry, to uniquely identify a pediatric patient or clinical record outside the primary system. Used in interoperability and care coordination workflows to link and reconcile pediatric records across multiple healthcare platforms.

pediatric faxped_fax

The facsimile telephone number associated with a pediatric patient, guardian, or pediatric care facility contact record. Used in care coordination, referral management, and clinical communication workflows to transmit documents related to patients under 18 when electronic or direct communication methods are unavailable.

pediatric feeped_fee

The monetary charge associated with a clinical service, procedure, or consultation rendered to a pediatric patient. Used in billing, claims adjudication, and revenue cycle management workflows to capture the amount billed or contracted for care delivered to patients under 18 years of age.

pediatric first nameped_first_nm

The legal given name of a pediatric patient as recorded in the health information system. Used in patient identification, clinical documentation, and member enrollment workflows to display and reference the first name of patients under 18, supporting accurate matching, communication, and record linkage across care settings.

pediatric flagped_flg

A binary indicator field applied to patient or claim records in EHR and claims systems to denote pediatric status, typically set when a patient is under 18 years of age, triggering age-specific rules for dosing, coding edits, and benefit adjudication.

pediatric frequencyped_freq

The prescribed dosing schedule or administration interval for a medication or treatment ordered for a pediatric patient. Captures how often a therapy is given, such as twice daily or every 8 hours, and is critical for safe pediatric medication management in clinical records.

pediatric full nameped_full_nm

The complete concatenated name of a pediatric patient, including first, middle, and last name components. Used in clinical documentation, patient matching, and identity verification workflows to display the child's full identity in a human-readable format across care settings.

pediatric genderped_gndr

The sex or gender classification recorded for a pediatric patient, typically using standard code sets such as HL7 or SNOMED. Used in clinical decision support, growth and developmental screening, and demographic reporting for children receiving healthcare services.

pediatric glucoseped_gluc

The measured blood glucose level for a pediatric patient, recorded as part of a clinical lab result or point-of-care test. Used to monitor and manage conditions such as neonatal hypoglycemia, juvenile diabetes, and metabolic disorders in children across inpatient and outpatient settings.

pediatric group numberped_grp_nbr

The insurance group identifier associated with a pediatric patient's health benefit plan, typically sourced from the member's insurance card or eligibility file. Used to verify coverage, coordinate benefits, and process claims for children enrolled in employer-sponsored or government health plans.

pediatric hemoglobinped_hgb

The measured hemoglobin concentration in the blood of a pediatric patient, recorded as part of a complete blood count or targeted lab test. Used to screen for anemia, monitor sickle cell disease, and assess nutritional status in children across clinical and population health programs.

pediatric history present illnessped_hpi

The structured or free-text narrative documenting the onset, duration, and progression of the current medical complaint for a pediatric patient. Captured during clinical encounters to support diagnosis and treatment decisions, often incorporating parent or guardian-reported observations for younger children.

pediatric identifierped_id

A unique alphanumeric key assigned to a pediatric patient record in EHR, claims, or member enrollment systems, used to consistently link clinical events, claims, and enrollment data across platforms for longitudinal pediatric care tracking and analytics.

pediatric indexped_idx

A sequential or positional numeric identifier assigned to a record within a pediatric specialty data structure in EHR or clinical data warehouse systems. Used by data engineers to establish row ordering, enable deterministic joins, and manage versioning within pediatric encounter or clinical panel datasets.

pediatric indicatorped_ind

A binary or boolean flag denoting whether a service, claim, or patient record is classified under a pediatric specialty in EHR, claims, or member enrollment systems. Used by data engineers to filter pediatric cohorts, apply age-based business rules, and segment CHIP or Medicaid pediatric populations.

PreviousPage 493 of 806Next