Report 15.2 - Cohort Outcome - Student Details

(Updated as of 04/23/2021)

Description: Reports a list of individual student data that supports aggregate view from the Cohort Outcome – Counts and Rates report.

Report Type: ODS

Data As Of: User Defined

Basic selection criteria:

2020/21 Four Year Cohort Membership Grade Level Academic Year Range

  • Grade 09 - July 1, 2017 - June 30, 2018
  • Grade 10 - July 1, 2018 - June 30, 2019
  • Grade 11 - July 1, 2019 - June 30, 2020
  • Grade 12 - July 1, 2020 - June 30, 2021

Students are determined in the cohort based on initial high school enrollment grade level record falling within the 2020/21 Membership date range above.

  • Grade Level = 9 -12
  • Membership Enrollment Date Range = 7/1/2017 - 6/30/2021
  • Outcome - Final Exit Date Range (Cohort Period) = 7/1/2017 - 8/15/2021
  • Cohort Report Processing Window = 4/11/2021 – 8/27/2021
  • Enrollment Status: - Primary (10) or - Short Term (if enrollment period is greater than 30 days)
  • Student Exit Category Code = All exit codes except N470, E125 or E170

Note: With the Cohort processing and reporting in CALPADS, LEAs can now view their current cohort counts and rates in CALPADS reports as well as future cohort counts and rates throughout the year up to four years.

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.

  • Cohort Expected Graduation Year
  • LEA
  • School Type
  • School
  • Gender
  • Ethnicity/Race
  • Title 1 Part C Migrant
  • Student with Disabilities
  • Socio Economically Disadvantaged
  • English Learner
  • Foster Youth
  • Homeless Program Eligible
  • Directly Certified
  • Seal of Biliteracy
  • Gold State Seal of Merit Diploma
  • CTE Completer
  • UC/CSU Requirements Met
  • Pre-Apprenticeship Certification Program Completion Indicator
  • Pre-Apprenticeship Program (non-certified) Completion Indicator
  • State or Federal Job Program Completion Indicator
  • Work-based Learning Internship
  • Work-based Learning through Enterprise
  • Simulated Work-based learning
  • Transition Work-based learning
  • Adult Age Student with Disabilities in Transition Status
  • Cohort Category

NOTE: The Cohort Expected Graduation Year filter enable users to select a future cohort year and see potential student cohort memberships for that year. This will allow users to see students who are expected to graduate in one-year, two-year, or three-years in the future and verify their first time 9th grade records sooner.

Report Logic


Report 15.2 column 1-11


Column Rule
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 – Student Legal First Name The Student Legal first name of the student identified from birth verification document or through legal adoption, or name change
SINF Field 2.13 – Student Legal Last Name The Student Legal last name of the student identified from birth verification document or through legal adoption, or name change.
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 SINF Fields 2.23 and 2.25 Ethnicity reported for students identified as Hispanic. Student who are not Hispanic have their race reported
8 SINF Field 2.18 - The month, day, and year of the student's birth.
9 SPRG Field 3.13 = Title I Part C Migrant (135) where enrollment and program span the Cohort Period.
10 SPRG Field 3.13 = Special Education (144) where enrollment and program span the Cohort Period.
OR SPED record in ODS with Education Plan Type (Field 14.24) = 100 (IEP/IFP), 150 (IFSP), or 200 (ISP) AND (Plan Set Start Date <= Reporting Period Through (End) Date and either ((Plan Set has no End date) or (Plan Set Exit Date >= Reporting Period From (Start) Date)))
11 A yes or no indication of whether the student meets socio-economically disadvantage criteria where enrollment and program span the Cohort Period.
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 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) or 191 (Homeless) 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 November results – OR
Student enrolled at a Juvenile Court School on Fall 1 Census

Report 15.2 column 12-22


Column Rule
12 SELA Field 12.13 - A yes or no indication of whether student's ELAS status on the as of date = EL AND SELA Field 12.15 is not equal to 00 or 37.
13 Meets Criteria for Foster Youth Eligible at any time during the Outcome Period
14 SPRG Field 3.13 = Homeless (191) where enrollment and program span the Cohort Period.
15 SENR Field 1.33 - A yes or no indication of whether students met requirements for Student Seal of Biliteracy Indicator.
16 SENR Field 1.29 - A yes or no indication of whether students met UC/CSU Requirements.
17 SENR Field 1.34 - A yes or no indication of whether or not a student with disabilities who is at least 17 years old is participating in a program to assist in the student’s transition from school to adult life.
18 WBLR Field 21.09 = Work Based Learning Code 25.
19 WBLR Field 21.09 = Work Based Learning Code 30.
20 WBLR Field 21.09 = Work Based Learning Code 35, 40, 45, 50 or 55.
21 WBLR Field 21.09 = Work Based Learning Code 10
22 WBLR Field 21.09 = Work Based Learning Code 15

Report 15.2 column 12-22


Column Rule
23 WBLR Field 21.09 = Work Based Learning Code 20
24 WBLR Field 21.09 = Work Based Learning Code 60 or 65
25 SENR Field 1.24 Grade Level Code. Initial High School Grade level record that fell within Membership Date Range and determined Cohort Membership.
26 The year the student was first identified in the cohort.
27 Removed from Cohort, Promoted/Matriculated, Graduate, CHSPE Completer, Adult Ed HS Diploma, Dropouts, Still Enrolled, Special Education Certificate of Completion, GED Completer, Other Transfer.
See 15.1 Cohort Outcome – Count and Rates mapping guide Rules for each definition.
28 SENR Field 1.23 = 10 or 30 (If 30 > 30 days).
29 SENR Field 1.22 = The final enrollment record within the Outcome Period that determines what LEA the SSID will report under.
30 SENR Field 1.25 = The final exit within the Outcome Period that determines final cohort outcome.
31 SENR Field 1.26 = A coded value representing the Student Exit Category and final Outcome in the Cohort.
32 SENR Field 1.27 = A coded value representing a School Completion Status and Outcome.

Field Code Legend

Field Code Name
SENR 1.05 School of Attendance
SENR 1.08 SSID
SENR 1.09 Local Student ID
SENR 1.17 Student Birth Date
SENR 1.22 Enrollment Start Date
SENR 1.23 Enrollment Status
SENR 1.24 Grade Level Code
SENR 1.25 Enrollment Exit Date
SENR 1.26 Student Exit Reason Code
SENR 1.27 Student School Completion Status
SINF 2.19 Student Gender Code
SINF 2.23 Student Hispanic Ethnicity Indicator
SINF 2.24 Student Ethnicity Missing Indicator
SINF 2.25-2.29 Student Race Code
SINF 2.30 Student Race Missing Indicator
SINF 2.11 -2.13 Student Legal Name
SINF 2.50 2.50(Parent/Guardian Highest Education Level Code
SPRG 3.13 Education Program Code
SELA 12.13 ELAS Code
SELA12.15 Primary Language

Exit Code Legend

Exit Code Name
E125 PriorComplSpecEd
E130 Died
E140 NoKnownEnrollTruant
E150 MidYearEnrollmentUpdate
E155 YearEndEnrlmntExitSameSchl
E170 SecEnrlExit
E230 CompleterExit
E300 ExpellNoKnownEnroll
E400 OtherOrUnknown
E410 MedicalRsns
E450 PreK-6Exit
E490 Summer or Intersession Exit
N420 NoShowSameSchl
N470 NoShow
T160 TransCASchlRegular
T165 TransSpecDiscRsnsOrJudg
T167 TransAltSchlPrgm
T180 TransPrivate
T200 TransUS
T240 TransOutUS
T260 TransInAdult
T270 TransDropAdult
T280 TransCollege
T310 TransHealthFacil
T370 TransInstHSDipl
T380 TransInstNoHSDip
T460 TransHomeSch

Completion Code Legend

Completion Code Name
100 Graduated, standard HS diploma
104 Completed all local and state graduation requirements, failed CAHSEE
106 Grad, CAHSEE mods & waiver
108 Grad, CAHSEE exempt
120 Special Education certificate of completion
250 Adult Ed High School Diploma
320 Received a High School Equivalency Certificate (and no standard HS diploma)
330 Passed CHSPE (and no standard HS diploma)
360 Completed grade 12 without completing graduation requirements, not grad

User Roles for Access:

SENR View Role

LEA or School level org type with SENR View can access report.


Additional Resources

Cohort Glossary

List of glossary terms relevant to Cohort reporting.

ACGR Cohort Training Powerpoint

Current year ACGR Training Powerpoint deck.

ACGR Cohort Training Workbook

Current year ACGR Training Workbook.

CALPADS File Specifications

Look for Student Enrollment (SENR), Student Program (SPRG) and Special Education (SPED) tabs for the fields indicated in the report logic.

CALPADS Data Guide

Chapter 3.1.9 provides additional information on Graduates and completers and the Cohort count calculation. Chapter 5.3 Appendix C provides additional information on Student Exit Reason code and Student School Completion status descriptions

CALPADS Code Sets

This document contains the current code values referenced in the file specifications for the coded value data elements. The Exit codes and completion code definitions are listed in this document.