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 subtotalped_subtot

Intermediate sum of charges, services, or clinical counts associated with a pediatric patient encounter before final adjustments or additions. Used in pediatric billing workflows, cost reporting, and financial analytics to track partial totals within claims or care episodes.

pediatric surgery dateped_surg_dt

Calendar date on which a surgical procedure was performed on a pediatric patient. Used in surgical scheduling, operative records, post-operative follow-up tracking, and claims adjudication to establish timelines for pediatric surgical care and recovery monitoring.

pediatric targetped_tgt

A reference value, benchmark, or destination system identifier associated with a pediatric patient or service record. Used in EHR interoperability, care management, and quality reporting platforms to define goal thresholds or route pediatric data to receiving systems or care teams.

pediatric taxonomy codeped_tax_cd

NUCC Health Care Provider Taxonomy code identifying the specialty or subspecialty of the clinician delivering pediatric services. Used in claims routing, credentialing, and network management to classify pediatric care providers such as general pediatricians or pediatric subspecialists.

pediatric temperatureped_temp

Recorded body temperature vital sign measurement for a pediatric patient, captured during clinical assessments. Used in fever detection, sepsis screening protocols, and longitudinal vital sign trending within pediatric inpatient, emergency, and outpatient clinical documentation workflows.

pediatric termination dateped_term_dt

Date on which a pediatric patient's enrollment, care plan, program participation, or service authorization ends. Used in managed care, Medicaid, and CHIP eligibility tracking to determine coverage lapses and ensure continuity of care for pediatric populations.

pediatric timeped_tm

The time-of-day value, typically in HH:MM:SS format, associated with a clinical event, procedure, or data transaction for a patient under 18 years of age. Used in EHR and hospital information systems to support pediatric scheduling, event sequencing, and time-sensitive clinical documentation.

pediatric timestampped_ts

A combined date and time value recorded at the moment of a clinical event, system transaction, or data entry for a pediatric patient. Used in EHR, claims, and interoperability platforms to establish audit trails, event sequencing, and time-based compliance reporting for patients under 18 years of age.

pediatric titleped_ttl

Formal honorific or professional title associated with a clinician or staff member involved in pediatric care delivery. Used in provider directory records, correspondence generation, and clinical documentation to ensure accurate identification within pediatric healthcare administrative systems.

pediatric totalped_tot

An aggregated numeric sum representing costs, units, encounters, procedures, or services accumulated for pediatric patients within a defined reporting period. Used in claims adjudication, pharmacy benefit management, and population health systems to support financial reconciliation and pediatric utilization reporting.

pediatric total countped_tot_cnt

Aggregate count of pediatric patients, encounters, services, or clinical events within a defined reporting period or population cohort. Used in pediatric quality reporting, capacity planning, utilization management, and public health surveillance to measure volume and care delivery trends.

pediatric typeped_typ

A categorical classification code identifying the nature of a pediatric record, service, encounter, or data element for patients under 18 years of age. Used in EHR, claims, and managed care systems to distinguish pediatric sub-specialties, care settings, service categories, or program enrollment types.

pediatric updated dateped_upd_dt

Date on which a pediatric patient's record, enrollment, clinical data, or administrative information was most recently modified. Used in audit trails, data governance, and care management workflows to track record currency and ensure data integrity across pediatric health systems.

pediatric urgencyped_urg

Clinical urgency or acuity level assigned to a pediatric patient's condition or service request, indicating the time-sensitivity of required care. Used in triage workflows, prior authorization, and care coordination to prioritize treatment and allocate pediatric clinical resources appropriately.

pediatric valueped_val

A discrete, measured data point captured from a clinical observation, lab result, assessment tool, or administrative field for a patient under 18 years of age. Used in EHR and population health systems to populate pediatric quality measures, growth tracking, and risk stratification models.

pediatric versionped_ver

Sequential version number assigned to a pediatric patient record, clinical document, or care plan to track revisions over time. Supports data lineage, audit compliance, and record management by identifying the iteration of a document within pediatric health information systems.

pediatric zipped_zip

Five or nine-digit postal ZIP code associated with a pediatric patient's residential or service address. Used in geographic analysis, Medicaid eligibility determination, social determinants of health assessments, and care access reporting for pediatric populations across service areas.

pharmacist admission datephrm_admn_dt

Date a licensed pharmacist is recorded as admitted in a hospital or clinical facility, captured in EHR and claims systems to support medication reconciliation workflows, inpatient pharmacy consult tracking, and billing event sequencing for pharmacist-involved episodes of care.

pharmacist discharge datephrm_dsch_dt

Date a licensed pharmacist's inpatient involvement concludes or a patient under pharmacist-managed care is discharged, recorded in EHR and claims systems to close medication management episodes, trigger transition-of-care pharmacy reviews, and finalize billing records.

pharmacist labelphrm_lbl

Display text or printed label generated by a pharmacist for a dispensed medication, including drug name, dosage instructions, and patient details. Used in pharmacy dispensing systems to ensure accurate medication identification, patient counseling support, and regulatory labeling compliance.

PreviousPage 497 of 806Next