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 instructionped_instr

Structured or free-text guidance associated with a pediatric specialty service in EHR or care management systems, including age-adjusted dosing or developmental care notes. Used by data engineers to parse clinical directives, support NLP workflows, and populate pediatric care plan data marts.

pediatric keyped_key

The surrogate or natural key value used to uniquely identify a pediatric patient record within a database or data warehouse. Serves as the primary lookup reference for joining clinical, claims, and enrollment data across healthcare information systems for children.

pediatric labelped_lbl

The human-readable display text or descriptive tag associated with a pediatric patient record, code value, or data element. Used in user interfaces, reports, and clinical dashboards to present coded or system-generated values in a meaningful format for clinical and administrative staff.

pediatric languageped_lang

The preferred spoken or written language of a pediatric patient or their parent and guardian, recorded to support effective communication and care coordination. Used to identify interpreter needs, deliver language-appropriate patient education, and meet health equity reporting requirements for pediatric populations.

pediatric last nameped_last_nm

The family surname of a pediatric patient as recorded in the medical or enrollment record. Used in patient identity matching, clinical documentation, and eligibility verification workflows to distinguish children within a household or family unit across healthcare systems.

pediatric legal nameped_legal_nm

The officially registered name of a pediatric patient as it appears on legal documents such as a birth certificate or government-issued ID. Used for identity verification, insurance enrollment, consent documentation, and compliance with regulatory requirements in clinical and administrative systems.

pediatric levelped_lvl

The hierarchical tier or classification rank assigned to a pediatric specialty record in EHR or clinical taxonomy systems, such as acuity or care complexity levels. Used by data engineers to structure parent-child data relationships, apply pediatric severity scoring, and support tiered reimbursement logic in claims pipelines.

pediatric license numberped_lic_nbr

The state-issued professional license identifier associated with a clinician who provides care to pediatric patients, such as a pediatrician or pediatric nurse practitioner. Used in credentialing, claims adjudication, and provider enrollment processes to validate clinical qualifications.

pediatric marital statusped_mar_sts

The recorded marital or domestic relationship status for a pediatric patient, which for minors is typically noted as single or not applicable. Used in demographic data collection, social determinants of health assessments, and administrative enrollment workflows for pediatric populations.

pediatric master identifierped_mstr_id

The enterprise master patient index identifier assigned to a pediatric patient to uniquely represent them across all systems within a health network. Enables accurate patient matching, longitudinal record linkage, and coordinated care management for children receiving services at multiple facilities.

pediatric maximumped_max

The upper boundary value defined for a clinical parameter, dosage, or measurement applicable to a pediatric patient, such as maximum allowable medication dose by weight. Used in clinical decision support rules and safety checks to prevent dosing errors in pediatric care settings.

pediatric medical record numberped_mrn

The facility-assigned medical record number that uniquely identifies a pediatric patient within a specific healthcare organization's clinical system. Used to retrieve longitudinal clinical history, link encounters, and manage records for children across inpatient, outpatient, and specialty care settings.

pediatric middle nameped_mid_nm

The middle name or initial of a pediatric patient as recorded in the clinical or enrollment record. Used in combination with first and last name to improve patient identity matching accuracy and reduce duplicate record creation across pediatric healthcare systems and registries.

pediatric minimumped_min

The lower boundary value defined for a clinical parameter, dosage range, or measurement threshold applicable to a pediatric patient. Used in clinical decision support, lab reference ranges, and weight-based dosing calculations to ensure safe and appropriate care delivery for children.

pediatric mobileped_mob

The mobile phone number associated with a pediatric patient's parent, guardian, or caregiver, recorded to facilitate appointment reminders, care coordination communications, and telehealth outreach. Supports patient engagement and contact tracing workflows within pediatric clinical and administrative systems.

pediatric modified byped_mod_by

Identifies the user who last updated a pediatric patient record, clinical observation, or specialty-specific data entry. Captured as a user ID or system identifier to support audit trails, data governance, and accountability in pediatric clinical workflows.

pediatric modified dateped_mod_dt

The timestamp recording the most recent update to a pediatric specialty record in EHR or clinical data warehouse systems. Used by data engineers to implement incremental data loads, track audit trails, and detect late-arriving changes in pediatric encounter or claims integration pipelines.

pediatric modified timeped_mod_tm

Records the exact timestamp when a pediatric patient record or clinical data element was last modified. Used in audit logging, version control, and data reconciliation processes to ensure accuracy and traceability of changes within pediatric care documentation systems.

pediatric nameped_nm

The display label or descriptive text identifying a pediatric specialty service, program, or record entity in EHR or clinical data systems. Used by data engineers to map pediatric terminology to standard code sets, support data lineage documentation, and enable user-facing reporting within pediatric analytics platforms.

pediatric noteped_nt

Clinician-authored or system-generated annotation text associated with a pediatric specialty encounter or service in EHR systems. Used by data engineers to support NLP extraction, clinical documentation integrity workflows, and unstructured data ingestion into pediatric quality and outcomes data warehouses.

PreviousPage 494 of 806Next