Report C/A 4.3: Staff Teaching Assignment - Detail¶
(Updated as of 01/15/2021)
Description: Report Type: Reports the teaching assignments for SEIDs reported as active for the Fall 2 Report Period. Included are SEIDs employed as of Census Day and, for school tracks that are not in session on Census Day, SEIDs employed as of the first day that a track is in session within 30 days after Census Day.
Data As Of:
- Census Day (First Wednesday in October)
Basic selection criteria:
-
SEID exists in the Course Section (CRSE) record and SASS Field 8.13 – Staff Job Classification Code = one of the following:
- 12 – Teacher
- 26 – Charter School Non Certificated Teacher
- 27 – Itinerant or Pull-Out/Push-In Teacher
-
Course Section (CRSE) data and Student Course Section (SCSE) data are selected for the Academic Year being reported.
- Includes Course sections with zero enrollments
- Includes Course sections with SEID = 999999999
- Includes 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
- SEID – Null is checked; to enter SEID, checkmark must be removed
- Content Area
- State Course Code
- Course Content Area Subcategory
- Departmentalized Course Standards Grade Level Range
- Content Standards Alignment
- Charter Non-Core, Non-College Prep Course
- AP/IB Course code Cross Reference
- Online Course Instruction Type
- Middle School Core Setting
- Local Assignment Option
- High Quality CTE Course
- CTE Course
- Employment Status
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 | CRSE Field 9.16 - 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 | CRSE Field 9.17 - Local Staff ID |
| 8 | SDEM Field 7.31 – Staff Service Years Total |
| 9 | CRSE Field 9.07 - State Course Code plus description |
| 10 | CRSE Field 9.08 - Local Course Code plus description |
| 11 | CRSE Field 9.28 – Course Content Area Subcategory |
| 12 | CRSE Field 9.29 – Departmentalized Course Standards Grade Level Range |
| 13 | CRSE Field 9.14 – Course Section ID |
| 14 | CRSE Field 9.15 – Academic Term Code |
| 15 | CRSE Field 9.18 - Class ID |
| 16 | CRSE Field 9.13 - UC/CSU Approved Y/N |
| 17 | CRSE Field 9.19 - Non-Standard Instructional Level |
| 18 | CRSE Field 9.20 - Education Service Code plus description |
| 19 | CRSE Field 9.21 – Language of Instruction plus description |
| 20 | CRSE Field 9.22 – Instructional Strategy description plus description |
| 21 | CRSE Field 9.23 – Independent Study Indicator |
| 22 | CRSE Field 9.31 – Charter Non-Core, Non-College Prep Course |
| 23 | CRSE Field 9.33 – Online Course Instruction Type |
| 24 | CRSE Field 9.34 – Middle School Core Setting |
| 25 | CRSE Field 9.35 – Local Assignment Option |
| 26 | EL Course Enrollment - Y indicates that the course has one or more ELs enrolled in the course section |