Report 3.3: Class Enrollment - Student List

(Updated as of 01/14/2022)

Description: Reports list of students, as of the Fall 2 Report Period, in each class by course section by school with teacher assignments listed.

Report Type: ODS and Snapshot / Certification (Fall 2)

Security Roles: Fall 2 Reports

Data As Of: - If ODS version, user defined - If Snapshot version, Fall 2 Census Day (First Wednesday in October)

Basic selection criteria:

Students Included: - Students with an open enrollment on the “Data As Of” date, where the Enrollment Status equals 10 (Primary), 20 (Secondary) or 30 (Short Term) and is in Grade Levels KN – 12.

Staff Included: - SEID in Course Section record, and SASS record for the academic year identifying the staff as 12-Teacher, 26-Charter School Non-Certificated Teacher, and/or 27-Itinerent or Pull-out/Push-In Teacher

Course Data Rules:

  • Course Section (CRSE) data and Student Course Section (SCSE) data are selected for the Academic Year being reported.
  • Course section with 0 enrollment: Not Included
  • Course section with SEID = 9999999999: Included
  • Course section where Independent Study Indicator = Y: Not Included

Report Filters: Filters can be selected resulting in only totals for the selected filter being displayed – legend on bottom of last page of report states which filter/s were selected

  • Academic Year
  • LEA
  • Status – (Snapshot)
  • School Type
  • School
  • Content Area
  • State Course Code
  • Course Content Area Subcategory
  • Local Course ID
  • CTE Course
  • UC/CSU Approved Course
  • Instructional Strategy
  • Term


Report Logic

Report 3.3:  Class Enrollment - Student List

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 Use CRS‐State Course Code (9.07) to look‐up value in Course Group Master Combos document, Valid Code Combo sheet/tab, to derive corresponding Content Area code and name.
See the Content Area Category Assignment Code column on the Course Group Master Combos tab of the CALPADS Valid Code Combinations
Leads to Content Area to Report 3.3 Classes Enrollment – Student List
4 CRSE Field 9.28 – Displays the Course Content Area Subcategory
5 CRSE Field (9.18) Displays Class ID. A unique identifier for a Class derived and assigned at the local educational agency. The Class ID must be unique within a school by Academic Year. A Class ID represents a unique class in a school for an academic year.
6 CRSE Field 9.07 - Displays name of each State Course Code with student enrollment.
7 CRSE field 9.08 – Displays Local Course ID
8 CRSE field 9.15 - Displays the Academic Term associated with the period of time during the course enrollment
9 CRSE Field 9.14 – Displays Course Section ID
10 SDEM Field 7.08 – Display SEID. If more than one SEID in Section display all.
11 SDEM Fields 7.10-7.10 – Display Teacher name.
12 SENR Field 1.08 – Display SSID number.
13 SENR Fields 1.10-1.13 – Display Student name.
14 SENR Field 1.09 – Display Student Local ID number.
15 SENR Field 1.24 – Display Student Grade Level.
16 SENR Field 1.18 – Display Student Gender
17 Ethnicity/Race - identified using SINF fields 2.23(Student Hispanic Ethnicity Indicator), SINF 2.24 (Student Ethnicity Missing Indicator), SINF 2.25-2.29 (Student Race 1-5 Code), and SINF 2.31 (Student Race Missing Indicator) and the following rules:
1) If the Student Hispanic Ethnicity Indicator (Field 2.23) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.30) = Y
2) If Student Hispanic Ethnicity Missing Indicator (Field 2.23) = N or null and the Student Ethnicity Missing Indicator (Field 2.24) = Y or null and Student Race 1 - 5 Codes (Fields 2.25 - 2.29) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing".
4) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = Y, then roll up to "Missing."
5) If the Student Hispanic Ethnicity Indicator (Field 2.23) = N or null, and the Student Race Missing Indicator (Field 2.30) = N or null, and Student Race 1-5 Codes (Field 2.26 - 2.30) is indicated, then roll up as follows:
• If a single race = American Indian or Alaska Native (100), roll up to American Indian or Alaska Native
• If there is one or more of any of the Asian subgroups: ((201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian, and no other race category (100, 301, 302, 303, 304, 399, 400, 600, 700, 302, 303, 304, 399, 400, 600, 700) then roll up to Asian
• If a single race = Filipino (400) roll up to Filipino(400)
• If race includes Filipino (400) AND one or more of any of the Asian subgroups, [(201) Chinese, (202) Japanese, (203) Korean, (204) Vietnamese, (205) Asian Indian, (206) Laotian, (207) Cambodian, (208) Hmong, (299) Other Asian) and no other race category roll up to Filipino(400)
• If there is one or more of any of the Native Hawaiian/Pacific Islander subgroups ((301) Hawaiian, (302) Guamanian, (303) Samoan, (304) Tahitian, (399) Other Pacific Islander) and no other race category (100, 201, 202, 203, 204, 205, 206, 207, 208, 299, 400, 600, 700) then roll up to Hawaiian/Pacific Islander.
• If a single race = (600) Black or African American, roll up to Black or African American
• If a single race = (700) White, roll up to White
• If more than one of the following races: American Indian or Alaska Native, Asian, Black or African American, Native Hawaiian/Pacific Islander, White, roll up to "Multiple"


Glossary References:

Class,

Census Day,

Open Enrollment,