Our benefits report is a spreadsheet that allows for a more detailed analysis of benefits by average percent of salary, average expenditure, and total number of faculty covered.  The columns in the spreadsheet are included below:

Column Name Description
unit_id ipeds ID
state State abbreviation
statename State Name
institution_aaup_name Institution AAUP Name
ipeds_name Institution IPEDS Name
institution_aaup_cat AAUP Category
institution_control Institution Control
average_salary_professor Average Salary by Rank
average_salary_associate
average_salary_assistant
average_salary_instructor
average_salary_lecturer
average_salary_no_rank
average_percent_benefit_professor_fica Average Benefit as Percent of Salary by Rank and Benefit Type
average_percent_benefit_professor_medical
average_percent_benefit_professor_retirement
average_percent_benefit_professor_disability
average_percent_benefit_professor_group
average_percent_benefit_professor_tuition
average_percent_benefit_professor_unemployment
average_percent_benefit_professor_workers
average_percent_benefit_professor_other
average_percent_benefit_associate_fica
average_percent_benefit_associate_medical
average_percent_benefit_associate_retirement
average_percent_benefit_associate_group
average_percent_benefit_associate_tuition
average_percent_benefit_associate_disability
average_percent_benefit_associate_unemployment
average_percent_benefit_associate_workers
average_percent_benefit_associate_other
average_percent_benefit_assistant_fica
average_percent_benefit_assistant_retirement
average_percent_benefit_assistant_medical
average_percent_benefit_assistant_disability
average_percent_benefit_assistant_group
average_percent_benefit_assistant_tuition
average_percent_benefit_assistant_unemployment
average_percent_benefit_assistant_workers
average_percent_benefit_assistant_other
average_percent_benefit_instructor_fica
average_percent_benefit_instructor_medical
average_percent_benefit_instructor_retirement
average_percent_benefit_instructor_disability
average_percent_benefit_instructor_group
average_percent_benefit_instructor_tuition
average_percent_benefit_instructor_unemployment
average_percent_benefit_instructor_workers
average_percent_benefit_instructor_other
average_percent_benefit_lecturer_fica
average_percent_benefit_lecturer_medical
average_percent_benefit_lecturer_retirement
average_percent_benefit_lecturer_disability
average_percent_benefit_lecturer_group
average_percent_benefit_lecturer_tuition
average_percent_benefit_lecturer_unemployment
average_percent_benefit_lecturer_workers
average_percent_benefit_lecturer_other
average_percent_benefit_no_rank_fica
average_percent_benefit_no_rank_medical
average_percent_benefit_no_rank_retirement
average_percent_benefit_no_rank_disability
average_percent_benefit_no_rank_group
average_percent_benefit_no_rank_tuition
average_percent_benefit_no_rank_unemployment
average_percent_benefit_no_rank_workers
average_percent_benefit_no_rank_other
average_expenditure_professor_fica Average Expenditure by Rank an Benefit Type
average_expenditure_professor_medical
average_expenditure_professor_retirement
average_expenditure_professor_disability
average_expenditure_professor_group
average_expenditure_professor_tuition
average_expenditure_professor_unemployment
average_expenditure_professor_workers
average_expenditure_professor_other
average_expenditure_associate_fica
average_expenditure_associate_medical
average_expenditure_associate_retirement
average_expenditure_associate_disability
average_expenditure_associate_group
average_expenditure_associate_tuition
average_expenditure_associate_unemployment
average_expenditure_associate_workers
average_expenditure_associate_other
average_expenditure_assistant_fica
average_expenditure_assistant_medical
average_expenditure_assistant_retirement
average_expenditure_assistant_disability
average_expenditure_assistant_group
average_expenditure_assistant_tuition
average_expenditure_assistant_unemployment
average_expenditure_assistant_workers
average_expenditure_assistant_other
average_expenditure_instructor_disability
average_expenditure_instructor_fica
average_expenditure_instructor_medical
average_expenditure_instructor_retirement
average_expenditure_instructor_group
average_expenditure_instructor_tuition
average_expenditure_instructor_unemployment
average_expenditure_instructor_workers
average_expenditure_instructor_other
average_expenditure_lecturer_fica
average_expenditure_lecturer_medical
average_expenditure_lecturer_retirement
average_expenditure_lecturer_disability
average_expenditure_lecturer_group
average_expenditure_lecturer_tuition
average_expenditure_lecturer_unemployment
average_expenditure_lecturer_workers
average_expenditure_lecturer_other
average_expenditure_no_rank_fica
average_expenditure_no_rank_disability
average_expenditure_no_rank_medical
average_expenditure_no_rank_retirement
average_expenditure_no_rank_group
average_expenditure_no_rank_tuition
average_expenditure_no_rank_unemployment
average_expenditure_no_rank_workers
average_expenditure_no_rank_other
num_covered_professor_fica Number of Full Time Faculty Covered by Rank and Benefit Type
num_covered_professor_medical
num_covered_professor_retirement
num_covered_professor_disability
num_covered_professor_group
num_covered_professor_tuition
num_covered_professor_unemployment
num_covered_professor_workers
num_covered_professor_other
num_covered_associate_fica
num_covered_associate_medical
num_covered_associate_retirement
num_covered_associate_disability
num_covered_associate_group
num_covered_associate_tuition
num_covered_associate_unemployment
num_covered_associate_workers
num_covered_associate_other
num_covered_assistant_fica
num_covered_assistant_medical
num_covered_assistant_disability
num_covered_assistant_retirement
num_covered_assistant_group
num_covered_assistant_tuition
num_covered_assistant_unemployment
num_covered_assistant_workers
num_covered_assistant_other
num_covered_instructor_fica
num_covered_instructor_medical
num_covered_instructor_retirement
num_covered_instructor_disability
num_covered_instructor_group
num_covered_instructor_tuition
num_covered_instructor_unemployment
num_covered_instructor_workers
num_covered_instructor_other
num_covered_lecturer_disability
num_covered_lecturer_fica
num_covered_lecturer_group
num_covered_lecturer_medical
num_covered_lecturer_other
num_covered_lecturer_retirement
num_covered_lecturer_tuition
num_covered_lecturer_unemployment
num_covered_lecturer_workers
num_covered_no_rank_fica
num_covered_no_rank_medical
num_covered_no_rank_retirement
num_covered_no_rank_disability
num_covered_no_rank_group
num_covered_no_rank_tuition
num_covered_no_rank_unemployment
num_covered_no_rank_workers
num_covered_no_rank_other
average_total_percent_benefit_professor Average Total Benefits as Percent of Salary by Rank
average_total_percent_benefit_associate
average_total_percent_benefit_assistant
average_total_percent_benefit_instructor
average_total_percent_benefit_lecturer
average_total_percent_benefit_no_rank