What the budgetary per-pupil figure leaves out (incl. on-behalf TPAF pension)
Source:R/tges_analysis.R
tges_excluded_costs.RdNJ's headline comparative measure, Budgetary Per Pupil Cost (CSG1), deliberately excludes a long list of spending, most notably the state-paid on-behalf TPAF pension, post-retirement medical, and social security contributions, which by law are paid by the state and never appear in a district's own budget. This helper joins the Total Spending Detail workbook (a 2024+ TGES table) to CSG1 so you can see, per district-year, every component that sits between budgetary cost and total spending.
Arguments
- tges
Output of
fetch_tges()orfetch_many_tges()for a 2024+ guide.- years
Optional numeric vector. Keep only these
end_yearvalues.Numeric in [0, 1]; the maximum sent-pupil share for which the per-pupil differences are treated as reliable. Default 0.02.
Value
A tibble with one row per district-year: entity columns,
end_year, budgetary_pp, the six Detail components,
total_spending_pp, excluded_total_pp, gce_excess_pp,
enrollment_plus_sent, budgetary_denom, sent_pupil_share,
and the logical residual_reliable.
Details
The Detail workbook splits Total Spending Per Pupil into six components that sum to the published total; this helper returns them as clean per-pupil columns:
general_current_expense_pp– general-fund current expense (this is where on-behalf TPAF, transportation, tuition, and judgments live)capital_outlay_pp,grants_entitlements_pp,food_services_pp,debt_service_local_pp,debt_service_sda_pp– the other five components
It then computes two differences against the budgetary per-pupil cost:
excluded_total_pp=total_spending_pp - budgetary_pp. This is the full wedge of everything excluded from the budgetary figure: on-behalf TPAF pension/PRM/social security plus transportation, capital outlay, grants/entitlements, food service, tuition, debt service, and judgments.gce_excess_pp=general_current_expense_pp - budgetary_pp. A narrower residual: general-fund items excluded from budgetary cost, i.e. roughly transportation + on-behalf TPAF + tuition + judgments.
Neither difference isolates pension. No public TGES file breaks out
the on-behalf TPAF line; it is buried inside General Current Expense alongside
transportation and tuition. An itemized per-district pension figure exists
only in NJDOE's login-gated AudSum submission. Treat gce_excess_pp as
an upper bound on pension, not a measurement of it.
Denominator caveat. Budgetary per-pupil cost divides by resident
enrollment; the Detail per-pupil amounts divide by enrollment plus sent
pupils. For districts that educate all their own pupils the two agree within
~1%, but for sending districts (including big cities that place special-ed or
vocational pupils out of district) the denominators diverge and the per-pupil
subtraction breaks down. sent_pupil_share reports
(enrollment_plus_sent - resident_enrollment) / enrollment_plus_sent, and
residual_reliable is TRUE only when that share is at or below
reliable_max_sent_share. Filter to residual_reliable before
reading anything into gce_excess_pp.
Total Spending Detail tables ship only in the 2024 guide onward, so this needs
fetch_tges(2024) or later (each guide carries two prior fiscal years).
Examples
if (FALSE) { # \dontrun{
library(dplyr)
# All excluded-cost components for the latest two fiscal years
tges_excluded_costs(fetch_tges(2025)) %>%
select(district_name, end_year, budgetary_pp, total_spending_pp,
excluded_total_pp, gce_excess_pp)
# Only districts where the residual is denominator-reliable (self-contained),
# ranked by the general-fund excess (~ transportation + on-behalf TPAF)
tges_excluded_costs(fetch_tges(2025)) %>%
filter(residual_reliable, end_year == 2024) %>%
arrange(desc(gce_excess_pp)) %>%
select(district_name, budgetary_pp, gce_excess_pp, sent_pupil_share)
# Track one district's excluded-cost wedge across guides
tges_excluded_costs(fetch_many_tges(2024:2025)) %>%
filter(district_id == "3570") %>%
select(end_year, budgetary_pp, gce_excess_pp, excluded_total_pp)
} # }