Report 4.1: Staff – Count and FTE by Job Classification
(Updated as of 12/23/2023)
Description: Reports the number of staff and total FTE by job classification, as of the Fall 2 Report Period
Security Roles: Fall 2 Reports
Report Type: ODS and Snapshot / Certification (Fall 2)
Data As Of:
- Snapshot version, Census Day (First Wednesday in October)
Basic selection criteria:
-
SEID: Element 8.07 (SEID) must exist in CTC SEID table and NOT = 9999999999
-
Staff Demographics (SDEM) data are selected from the most recent SDEM record with:
- Effective Start Date on or before Census Day of the reporting year and Record Effective End Date (if exists) on or after Census Day and
- Employment Start Date on or before Census Day of the reporting year and Employment End Date (if exists) after Census Day
-
Staff Assignments (SASS) data are selected from the SASS record for the academic year and school reported and Non-Classroom Based or Support Assignment code NOT = 6018 (Employee on Leave).
Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed
- Academic Year
- LEA
- Status
- School Type
- School
Report Logic
| Column | Rules |
|---|---|
| 1 | 1. School code is derived from user ID permission and Expected Schools table |
| 2 | School Name is determined by #1 and the Expected Schools Table. School Name column leads to Report: 4.2 – Staff – count and FTE by Job Classification Disaggregated |
| 3 | Unduplicated Total Staff by School - SDEM Field 7.04 – Effective Start Date must be on or before 11- 1 of Reporting year, AND |
| SDEM Field 7.05 – Effective End Date must be blank or after Census Day, AND | |
| SDEM field 7.28 – Staff Employment Start Date must be on or before 11-1, AND | |
| SDEM 7.29 – Staff Employment End Date must be blank or after Census Day. | |
| Then - Count of unique SASS Field 8.07 – SEID at SASS Field 8.05 – School of Course Assignment where SASS Field 8.13 – Staff Job Class Code equals 10 (Administrator) or 11 (Pupil Services) or 12 (Teacher) or 25 (Non-Certification Administrators with SEID) or 27 (Itinerant or Pull-Out/Push-In Teacher with SEID) and SASS Field 8.15 - 8.21 - Support/Non Classroom Based Job Assignment code does not equal 6018 – (Employee on Leave) | |
| 4 | Unduplicated Total FTE by School - SDEM Field 7.04 – Effective Start Date must be on or before 11-1 of the reporting year, AND |
| SDEM Field 7.05 – Effective End Date must be blank or after Census Day, AND | |
| SDEM field 7.28 – Staff Employment Start Date must be on or before 11-1, AND | |
| SDEM Field 7.29 Staff Employment End Date must be blank or after Census Day | |
| Sum of FTE percentages SASS Field 8.14 – Staff Job Classification FTE Percentage per unique SASS Field 8.07 – SEID value at SASS Field 8.05 – School of Course Assignment where SASS Field 8.13 – Staff Job Class Code equals 10 (Administrator) or 11 (Pupil Services) or 12 (Teacher) or 25 (Non-Certification Administrators with SEID) or 26 (Charter School Non-Certificated Teacher with SEID) or 27 (Itinerant or Pull-Out/Push-In Teacher with SEID) and SASS Field 8.15 - 8.21 - Support/Non Classroom Based Job Assignment code does not equal 6018 – (Employee on Leave) divided by 100 | |
| 5 | Unduplicated Total FTE (4) Divided by Unduplicated Total # Staff (3) |
| 6, 8, 10, 12, 14, 16 | #STAFF Count of SEIDs at the School of Assignment where SASS Field 8.15 – 8.21 - Non Classroom Based Job Assignment Code does not equal 6018 and where SASS Field 8.13 Staff Job Class Code = |
| Column 6 = 12 (Teacher) | |
| Column 8 = 10 (Administrator) | |
| Column 10 = 11 (Pupil Services) | |
| Column 12 = 26 (Charter School Non-Certificated Teacher with SEID) | |
| Column 14 = 25 (Non-Certification Administrators with SEID) | |
| Column 16 = 27 (Itinerant or Pull-Out/Push-In Teacher with SEID) | |
| 7, 9, 11, 13, 15, 17 | FTE Sum of FTE for all SEIDs at School of Assignment where SASS Field 8.15 – 8.21 – Non-Classroom Based Job Assignment Code does not equal 6018 and where SASS Field 8.13 – Staff Job Class Code = |
| Column 7 = 12 (Teacher) | |
| Column 9 = 10 (Administrator) | |
| Column 11 = 11 (Pupil Services) | |
| Column 13 = 26 (Charter School Non-Certificated Teacher with SEID) | |
| Column 15 = 25 (Non-Certification Administrators with SEID) | |
| Column 17 = 27 (Itinerant or Pull-Out/Push-In Teacher with SEID) | |
| Duplicated Total – Selected Schools | : # Staff: Count of SEIDs at the Selected Schools of Assignments for each of the following Educational Service Job Classification Code columns: 12 – Teacher, 10- Administrator, 11 – Pupil Services, 26 – Charter School Non-certificated Teacher, 25 – Non-certificated Administrator, & 27 – Itinerant or Pullout/Push-In Teacher. Note: No Total available for Unduplicated Total columns. FTE: No calculation. |
| Unduplicated Total – Selected Schools | #Staff: Count of unique SEIDs at the Selected Schools of Assignments for each of the following Educational Service Job Classification Code columns: 12 – Teacher, 10- Administrator, 11 – Pupil Services, 26 – Charter School Non-certificated Teacher, 25 – Non-certificated Administrator, & 27 – Itinerant of Pull-out/Push-In Teacher. FTE: Sum of FTEs at the Selected Schools of Assignment for all unique SEIDs for each of the following Educational Service Job Classification Code columns: 12 - Teacher, 10 – Administrator, 11 - Pupil Services, 26 - Charter School Non-certificated Teacher, 25 - Non-certificated Administrator 27 – Itinerant or Pull-Out/Push-In Teacher. |
| FTE to Staff Ratio: Unduplicated Total – Selected Schools FTE divided by Unduplicated Total – Selected Schools # Staff | |