Report 4.3: Staff Teaching Assignments - Detail

(Updated as of 01/14/2022)

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

Report 4.3:  Staff Teaching Assignments - Detail

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

Report 4.3:  Staff Teaching Assignments - Detail

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

Report 4.3:  Staff Teaching Assignments - Detail

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

Glossary References:

Teacher,

Census Day,

Providing EL Education Service,

User Roles for Access

Fall 2 Reports role