Report 1.2: Enrollment - Primary Status Student List

(Updated as of 10/13/2020)

Description: Lists the students included in Report 1.1 Enrollment - Primary Status by Subgroups by school. The report lists student level detail as a supporting certification report.

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

Data As Of:

  • If ODS version, user defined
  • If Snapshot version, Fall 1 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) and is in Grade Levels KN – 12
  • Note - Snapshot: Must have a SINF record that wholly or in part overlaps a qualified enrollment. Default Grade Level does not include PS since PS does not have to be certified.

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
  • Grade
  • Gender
  • Ethnicity/Race
  • Student School Transfer Code
  • Adult Age with Students with Disabilities Transition

Report Logic

Image of report 1.2

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 SSID Field 1.08 - Unique identifier for the student assigned by the first California district of enrollment. This number follows the student throughout their enrollment within the California educational system
4 SINF Field 2.11 and 2.13 - The Student Legal first and last name of the student identified from birth verification document or through legal adoption, or name change. School Name column leads to Report 8.1 Student Profile - List
5 SENR Field 1.09 - Identifier assigned to the student by a local educational agency.
6 SINF Field 2.19 - A coded value representing the person's gender
7 Ethnicity/Race - identified using SINF fields 2.24 (Student Hispanic Ethnicity Indicator), SINF 2.25 (Student Ethnicity Missing Indicator), SINF 2.26-2.30 (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.24) = Y, always roll up to Hispanic, even if one or more races are selected or the Student Race Missing Indicator (Field 2.31) = Y
2) If Student Hispanic Ethnicity Missing Indicator (Field 2.24) = N or null and the Student Ethnicity Missing Indicator (Field 2.25) = Y or null and Student Race 1 - 5 Codes (Fields 2.26 - 2.30) is indicated, then roll up per rules outlined in 5 below.
3) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing".
4) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = Y, then roll up to "Missing."
5) If the Student Hispanic Ethnicity Indicator (Field 2.24) = N or null, and the Student Race Missing Indicator (Field 2.31) = 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"
8 SENR Field 1.24 - Reflects the grade level of a given student

Image of report 1.2

Column Rules
9 SPRG Field 3.13 - Ed Program Code equal to 185 (Transitional KN) and SPRG Field 3.15 - Program Membership Start Date greater than or equal to 7/1/of reporting year and equal to or less than Fall 1 Census Day and SPRG Field 3.16 - Program Membership End Date is blank or equal to or greater than Fall 1 Census Day
10 SELA Field 12.15 - Primary Language not equal to 00 (English) or 37 (American Sign Language) and SELA Field 12.13 - English Language Acquisition Status Code equal to EL (English Learner) status effective during the report period (using effective date) regardless of Reporting LEA
11 SENR Field 1.25 - Grade Level Code equal to KN -12, and SINF Field 2.18 - Student Birth Date equal to (determines age to be 3-21) and SINF Field 2.22 – Student Birth Country not equal to US (United States) or PR (Puerto Rico) and SINF Field 2.46 - Enrolled in US School less than 3 Cumulative Years equal to Y
Title III Eligible Immigrants column leads to Report 2.2 Title III Eligible Immigrants by Birth Country
12 SPRG Field 3.13 - Ed Program Code equal to 127 (Gifted and Talented) and SPRG Field 3.15 - Program Membership Start Date equal to or less than Fall 1 Census Day and SPRG Field 3.16 Program Membership End Date equal to blank or equal to or greater than Fall 1 Census Day
13 SPRG Field 3.13 - Ed Program Code equal to 135 (Migrant) and SPRG Field 3.15 - Program Membership Start Date equal to or less than Fall 1 Census Day and SPRG Field 3.16 - Program Membership End Date equal to blank or greater than Fall 1 Census Day
14 Count of primary enrolled students receiving Special Education Services. See CALPADS Glossary: Students with Disabilities
15 SINF Field 2.50 – Parent Guardian Highest Grade Level Code equal to 14 - OR
SPRG Field 3.13 - Ed Program Code equal to 181 (Free NSLP) or 182 (Reduced NSLP) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than 7/1/ of reporting year and equal to or less than 12/31 of the reporting year and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR
SPRG Field 3.13 - Ed Program Code = 135 (Migrant), 191 (Homeless) or 193 (Tribal Foster Youth) and SPRG 3.15 – Ed Program Membership Start Date equal to or greater than Fall 1 Census Day and SPRG 3.16 – Ed Program Membership End date blank or equal to or greater than Fall 1 Census Day – OR
Foster Youth Indicator equal to Y AND Episode Start date less than or equal to Fall 1 Census Day and Episode End Date is blank or greater than or equal to Fall 1 Census Day – OR
Direct Certification Indicator equal to Y AND Direct Certification Date less than or equal to January results – OR
Student enrolled at a Juvenile Court School on Fall 1 Census
16 Adult Age with Students with Disabilities Transition = Y/N

User Roles for Access:

Fall 1 Reports Role

Glossary References:

Accountability Subgroup Data,

English Learner Subgroup,

Gifted and Talented Education Program (GATE) Subgroup,

Socio-economically Disadvantaged Subgroup,

Students with Disabilities,

Title 1 Part C Migrant Subgroup,

Title III Eligible Immigrant Subgroup