Monthly Staffing Report July 2026.xlsx

This is a Monthly Staffing Report for July 2026 from what appears to be the Indiana Department of Correction or a related state corrections healthcare agency, documenting full-time equivalent (FTE) staffing levels across multiple correctional facilities, work release centers, juvenile detention facilities, regional offices, and police department transitions units. The report compares staffing matrices against actual worked and paid FTEs across a comprehensive range of healthcare and support positions including medical directors, nurses, addiction recovery specialists, behavioral health professionals, administrative staff, and dental personnel. The data is organized by facility type—including major correctional facilities such as Indiana State Prison, Pendleton Correctional Facility, Wabash Valley Correctional Facility, and multiple women's facilities—as well as juvenile facilities at LaPorte, Logansport, and Pendleton, along with reception and diagnostic centers and vendor-staffed parole liaison positions.

The report reveals significant staffing variances across the organization, with total matrix FTEs at 813.84 compared to 772.02 worked FTEs and 852.74 paid FTEs, indicating a worked variance of 41.81 FTEs and a paid variance of -38.9 FTEs. The data is disaggregated into three comparison sections: total staffing, non-locum staff, and locum (temporary physician) staff. Notable observations include chronic understaffing in nursing positions (RNs and LPNs showing negative variances ranging from -5 to -20 FTEs per facility), consistent underfilling of addiction recovery and mental health specialist roles, and several positions maintained entirely by matrix allocations with zero actual staffing (including behavioral health activities therapists and various licensed professional positions at multiple facilities). The report provides detailed position-by-position analysis enabling oversight of recruitment challenges, vacancy rates, and reliance on locum providers, particularly for optometry services, which account for most temporary physician FTE usage.