Report C/A 4.5: Staff Non Classroom Based or Support Assignment - Detail

(Updated as of 12/17/2024)

Description: Reports the non-classroom based/support assignments for each SEID by Job Classification Code 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

  • Staff Assignments (SASS) data reported are selected from the SASS record for the Academic Year and school reported where Non-Classroom Based Job Assignments is populated

    • Note: Report versions prior to AY 2024-25, DO NOT include staff where SASS Field 8.15 – 8.21 - Support Assignment Codes equal to 6018 (Employee on Leave)

  • 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

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed

  • Academic Year
  • County
  • LEA
  • School Type
  • School
  • Gender
  • Ethnicity/Race
  • Job Classification
  • Employment Status
  • Non Classroom Based Job Assignment

Report Logic

Report 4.5


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 SASS Field 8.07 SEID
6 SDEM Field 7.12 – Staff Legal Last Name and SDEM Field 7.10 – Staff Legal First Name and SDEM Field 7.11 Staff Legal Middle Name
7 SASS Field 8.08 - Local Staff ID
8 SASS Field 8.13 - Job Classification Code plus description of code
9 SASS Field 8.14 - Staff Job Classification FTE Percentage
10 SASS Field 8.15 - Non Classroom Based or Support Assignment code plus description of code