Set up your data for IPEDS HR processing"

In IPEDSuploadables: Transforms Institutional Data into Text Files for IPEDS Automated Import/Upload

knitr::opts_chunk$set(
  collapse = TRUE,
  comment = "#>"
)

library(IPEDSuploadables)

To use the produce_hr_report function, your data must be in the format described below

• One row per person
• One IPEDS Unitid per file
• Columns with values and types as described below (additional columns are allowed)

Note

Starting in the 2022-2023 reporting cycle, we only report New Hires who are still 11/1 Current Employees. In other words, everyone in your starting data should have a CurrentEmployee flag of 1. In future years, we may drop the requirement of the CurrentEmployee column since it no longer carries valuable information. For this year, we have left it to avoid further structural changes.

library(magrittr)
specs_HR$ACCEPTABLE_VALUES <- stringr::str_replace_all(specs_HR$ACCEPTABLE_VALUES, pattern = "\\n", replacement = "<br>")
knitr::kable(specs_HR, 
            format = 'html',
             escape = FALSE,
             col.names = c('Column Name', 'Column Type', 'Acceptable Value - Definition')) %>%
    kableExtra::kable_styling(bootstrap_options = "striped") %>%
  kableExtra::column_spec(2, italic = TRUE, width = '8em')

Notes

• In OccCategory3, 21 is used for an intermediate total and is not a value in the upload file
• OccCategory3 values will be recoded in prep_hr_data_frame into all necessary rollups, including instructional staff (values 1-4)

IPEDSuploadables documentation built on April 3, 2025, 9:36 p.m.