Report 5.9 Former Foster Youth– Student List

Description: Reports the K-12 (KN, 01-12) students who were formerly foster by school. Students are considered former foster when they had been identified as foster at some point during the current academic year but are no longer foster on the report “as of” date. Former foster are identified in the FosterYouthMatchResults table by the presence of an LCFF Foster End Date.

Report Type: ODS Only

Data As Of:

  • Current Date

Basic selection criteria:

Students Included:

  • SSID Enrollment (e.g. Enrollment Status, grade) for a student is associated with the most recent Open enrollment at the school that overlaps the report “As of” date (“As of” date for this report is the current date) OR where most recent enrollment record for a student includes an E155 exit code, regardless of exit date.

  • Enrollment status = Primary (10), or Short Term (30)

  • Grade levels = KN, 01-12

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 (Snapshot)
  • School Type
  • School
  • Grade
  • Gender
  • Ethnicity/Race
  • English Language Acquisition
  • Gifted and Talented Education
  • Title I Part C Migrant
  • Special Education
  • Enrollment Status

Report Logic

Report 5.9

Column Rules
1 School code is derived from user ID permission and Expected Schools table
2 School Name is determined by #1
3 SENR Field 1.08 - SSID
4 SENR Field 1.10 - Student Legal First Name; SENR Field 1.11 - Student Legal Middle Name; SENR Field 1.12 - Student Legal Last Name
5 SENR Field 1.09 Local Student ID
6 SINF Field 2.18 - Student Birth Date
7 SINF Field 2.19 - Student Gender Code
8 SENR Field 1.25 - Grade Level Code equal to KN -12. SENR 1.24 – Enrollment Status is 10 (Primary) or 30 (Short Term) and SENR 1.26 – Enrollment Exit Date is null or where most recent enrollment record for a student includes an E155 exit code. This field can be expanded to show by Grade within Foster categories.
9 SENR Field 1.22 - Enrollment Start Date
10 SENR Field 1.24 – Enrollment Status is 10 (Primary) or 30 (Short Term)
11 Indicator that it was locally matched in CALPADS (“Y” or “N”)
12 Indicator that results were from Statewide Match (“Y” or “N”)
13 Derived from CDSS Database
14 Derived from CDSS Database
15 Derived from CDSS Database
16 Derived from CDSS Database
17 Derived from CDSS Database
18 Derived from CDSS Database
19 Derived from CDSS Database
20 Derived from CDSS Database
21 Derived from CDSS Database
22 Derived from CDSS Database
23 Derived from CDSS Database
24 Derived from CDSS Database
25 Derived from CDSS Database
26 Reflects Last Updated Date of Foster Youth Match Results

Glossary References:

Foster Youth

Former Foster Youth

Open enrollment

CDE Foster Youth Resource

User Roles for Access:

Foster Youth role