Report C/A 4.5: Staff Non Classroom Based or Support Assignment - Detail
(Updated as of 01/15/2021)
Description: Reports the non-classroom based/support assignments for each SEID by Job Classification Code as of the Fall 2 Report Period
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
- Exclude Support/Non-Classroom Based Job Assignment Code = 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
| 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 |