Staffing ratios, median salaries, and the benefits squeeze
Source:R/tges_analysis.R
tges_staffing.RdReshapes the personnel tables (CSG16-CSG19) plus the benefits share (CSG14) into one row per district-year. This is the board's negotiation and "administrative bloat" dashboard in a single frame: students per teacher / special-service provider / administrator, faculty per administrator, the median salary for each role, and benefits as a share of total salaries.
Arguments
- tges
Output of
fetch_tges()orfetch_many_tges().- years
Optional numeric vector. Keep only these
end_yearvalues.
Value
A tibble with entity columns, end_year, the ratio columns, the
median-salary columns, and benefits_pct_salary.
Details
Sources, by friendly column:
student_teacher_ratio,teacher_salary(CSG16)student_special_service_ratio,special_service_salary(CSG17)student_admin_ratio,admin_salary(CSG18)faculty_admin_ratio(CSG19)benefits_pct_salary(CSG14, employee benefits as a fraction of total salaries)
CSG16-CSG19 report end_year - 1 and end_year; CSG14 also reports
end_year - 2, so the earliest year may carry a benefits share with no
ratios. The most recent year's benefits share is the budgeted figure.
Examples
if (FALSE) { # \dontrun{
library(dplyr)
# Is Newark administratively heavy, and competitive on teacher pay?
tges_staffing(fetch_tges(2024)) %>%
filter(district_id == "3570") %>%
select(end_year, student_admin_ratio, faculty_admin_ratio,
teacher_salary, admin_salary, benefits_pct_salary)
# Rank student/administrator ratio within enrollment-band peers
tges_staffing(fetch_tges(2024)) %>%
tges_percentile_rank("student_admin_ratio", peer = "tges_group")
} # }