Report 4.3: Staff Teaching Assignments - Detail
(Updated as of 12/13/2023)
Description: Reports the teaching assignments for SEIDs reported as active for the Fall 2 Report Period.
Security Roles: Fall 2 Reports
Report Type: ODS and Snapshot / Certification (Fall 2)
Data As Of:
- Snapshot version only, 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
- LEA
- Status – (Snapshot)
- 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 | School code is derived from user ID permission and Expected Schools table |
| 2 | School Name is determined by #1 and the Expected Schools Table |
| 3 | CRSE Field 9.16 - SEID |
| 4 | 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. Teacher Name links to Report 4.4 Staff Profile – List |
| 5 | CRSE 9.17 - Local Staff ID |
| 6 | SDEM Field 7.31 – Staff Service Years Total |
| 7 | CRSE Field 9.07 - State Course Code plus description |
| 8 | CRSE Field 9.08 - Local Course Code plus description |
| Column | Rules |
|---|---|
| 9 | CRSE Field 9.28 – Course Content Area Subcategory |
| 10 | CRSE Field 9.29 – Departmentalized Course Standards Grade Level Range |
| 11 | CRSE Field 9.14 – Course Section ID |
| 12 | CRSE Field 9.15 – Academic Term Code |
| 13 | CRSE Field 9.18 - Class ID |
| 14 | CRSE Field 9.13 - UC/CSU Approved Y/N |
| 15 | CRSE Field 9.19 - Non-Standard Instructional Level |
| 16 | CRSE Field 9.20 - Education Service Code plus description |
| Column | Rules |
|---|---|
| 17 | CRSE Field 9.21 – Language of Instruction plus description |
| 18 | CRSE Field 9.22 – Instructional Strategy description plus description |
| 19 | CRSE Field 9.23 – Independent Study Indicator |
| 20 | CRSE Field 9.33 – Online Course Instruction Type |
| 21 | CRSE Field 9.34 – Middle School Core Setting |
| 22 | CRSE Field 9.35 – Local Assignment Option |
| 23 | EL Course Enrollment - Y indicates that the course has one or more ELs enrolled in the course section |