Report 4.2: Staff - Count and FTE by Job Classification Disaggregated

(Updated as of 01/14/2022)

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 – (Snapshot)
  • School Type
  • School
  • Employment Status
  • Group by
  • Ethnicity/Race
  • Gender
  • User Comments


Report Logic


Report 4.2:  Staff - Count and FTE by Job Classification Disaggregated

Column Rules
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.4 – Staff Profile
3 Ethnicity/Race – system defaults to All – plus sign reveals each reported ethnicity/race Ethnicity/Race used from SDEM and derived using the Ethnicity/Race (Federal Definition) business rules
4 Gender – system defaults to All – plus sign reveals each reported gender
5 Unduplicated Total Staff by School - Count of unique SEIDs at School of 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) or 26 (Charter School Non-certificated Teacher) or 27 (Itinerant or Pull-Out/Push-In Teacher) and SASS Field 8.15 - 8.21 - Support/Non Classroom Based Job Assignment code does not equal 6018 – (Employee on Leave)
6 Unduplicated Total FTE by School - Sum of FTE for all unique SEIDs at the School of 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) or 26 (Charter School Non-Certificated Teacher) or 27 (Itinerant or Pull-Out/Push-In Teacher) and SASS Field 8.15 - 8.21 - Support/Non Classroom Based Job Assignment code does not equal 6018 – (Employee on Leave), divided by 100
7 Unduplicated FTE (6) Divided by Unduplicated Total # Staff (5)
8, 10, 12, 14, 16, 18 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 equals
Column 8 = 12 (Teacher)
Column 10 = 10 (Administrator)
Column 12 = 11 (Pupil Services)
Column 14 = 26 (Charter School Non-Certificated Teacher with SEID)
Column 16 = 25 (Non-Certification Administrators with SEID)
Column 18 = 27 (Itinerant or Pull-Out/Push-In Teacher with SEID)
9, 11, 13, 15, 17, 19 Sum of FTE divided by 100 for all 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 equals
Column 8 = 12 (Teacher)
Column 10 = 10 (Administrator)
Column 12 = 11 (Pupil Services)
Column 14 = 26 (Charter School Non-Certificated Teacher with SEID)
Column 16 = 25 (Non-Certification Administrators with SEID)
Column 18 = 27 (Itinerant or Pull-Out/Push-In Teacher with SEID)
and sum of FTE percentages 8.14 divided by 100 for SEIDs 8.07 at School of Course Assignment 8.05 where SASS Field 8.15 – 8.21 – Non-Classroom Based Job Assignment Code does not equal 6018
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.
FTE: No calculation.
Unduplicated 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 for Unduplicated Total columns.
FTE: No calculation
FTE to Staff Ratio: Unduplicated Total – Selected Schools: FTE/Unduplicated Total – Selected Schools: # Staff. 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

Glossary References:

Full Time Equivalent (FTE),

Census Day