Report C/A 4.1: Staff – Count and FTE by Job Classification

(Updated as of 01/15/2021)

Description: Reports the number of staff and total FTE by job classification, as of the Fall 2 Report Period

Security Roles: County or Authorizing LEA Reports

Data As Of: - 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
• County
• LEA
• School Type
• School
  

Report Logic

Column	Rules
1	LEA Code is derived from user ID permission and Expected Schools table
2	LEA Name is determined by #1 and the Expected Schools Table
3	School code is derived from user ID permission and Expected Schools table
4	School Name is determined by #3 and the Expected Schools Table.
5	Unduplicated Total Staff by LEA - Count of unique SEIDs at the Reporting LEA where SASS Field 8.13 – Staff Job Class Code = 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 LEA - Sum of FTE percentages for all unique SEIDs at the Reporting LEA 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, 9, 11, 13, 15, 17	# 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)
8, 10, 12, 14, 16, 18	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 County: # Staff:	Count of SEIDs at the Reporting LEAs 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 County: #Staff:	Count of unique SEIDs at the Reporting LEAs 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 LEAs FTE divided by Unduplicated Total – Selected LEAs # Staff