Report C/A 5.9 Former Foster Youth– Student List
Updated 10/7/2026
Description: Reports the TK-12 (TK, 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: C/A Only
Security Roles: County or Authorizing LEA Reports
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 = TK, KN, 01-12
The qualifying enrollment must also take into consideration the following County of Jurisdiction filters.
-
All - Any student with a qualifying enrollment regardless of enrollment county code with a County of Jurisdiction Code in the FosterYouthMatchResults table that matches the county code for the county user running the report OR any student with a qualifying enrollment that is within the county code for the county user running the report regardless of County of Jurisdiction Code in the FosterYouthMatchResults table.
-
Enrolled in my county/placed by my county - Any student with a qualifying enrollment with a County of Jurisdiction Code in the FosterYouthMatchResults table that matches the county code for the county user running the report that is enrolled within the county code for the county user running the report.
-
Enrolled in my county/placed by another county - Any student with a qualifying enrollment that matches the county code for the county user running the report with a County of Jurisdiction Code in the FosterYouthMatchResults table that does NOT match the county code for the county user running the report.
-
Enrolled in another county/placed by my county - Any student with a qualifying enrollment with a County of Jurisdiction Code in the FosterYouthMatchResults table that matches the county code for the county user running the report that is NOT enrolled within the county code for the county user running the report.
NOTE: If a student has multiple, open (no LCFF End Date) CaseIDs per one Client ID, the student would be displayed for each CaseID/ClientID combo.
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)
- County
- County of Jurisdiction
- Enrollment Status
- Grade
- Gender
- Ethnicity/Race
- English Language Acquisition
- Title I Part C Migrant
- Students with Disabilities
- Gifted and Talented Education
Report Logic
Click image to expand
| Column | Rules |
|---|---|
| 1 | County of Jurisdiction - CountyOfJurisdiction.FosterYouthMatchResults Name |
| 2 | County of Enrollment - Use data element name from CALPADS Security Model |
| 3 | LEA Code - Educational Service Institution.Identifier Reporting LEA |
| 4 | LEA Name - Use data element name from CALPADS Security Model |
| 5 | School code is derived from user ID permission and Expected Schools table |
| 6 | School Name is determined by #1 and the Expected Schools Table. |
| 7 | SENR Field 1.08 - SSID |
| 8 | SENR Field 1.10 - Student Legal First Name; SENR Field 1.11 - Student Legal Middle Name; SENR Field 1.12 - Student Legal Last Name |
| 9 | SENR Field 1.09 Local Student ID |
| 10 | SINF Field 2.18 - Student Birth Date |
| 11 | SINF Field 2.19 - Student Gender Code |
| 12 | SINF Field 2.25 – Ethnicity/Race |
| 13 | SELA Field 12.13 – ELAS Status |
| 14 | Provided by MSIN Weekly file - Migrant ED |
| 15 | SWDS Field 2.12 = 1-Eligible and Participating - Student With Disabilities |
| 16 | SENR Field 1.24 - Grade Level Code |
| 17 | SENR Field 1.22 - Enrollment Start Date |
| 18 | SENR Field 1.23 – Enrollment Status is 10 (Primary) or 30 (Short Term) |
| 19 | Indicator that it was locally matched in CALPADS (“Y” or “N”) |
| 20 | Indicator that results were from Statewide Match (“Y” or “N”) |
| 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 | Derived from CDSS Database |
| 27 | Derived from CDSS Database |
| 28 | Derived from CDSS Database |
| 29 | Derived from CDSS Database |
| 30 | Derived from CDSS Database |
| 31 | Derived from CDSS Database |
| 32 | Derived from CDSS Database |
| 33 | Derived from CDSS Database |
| 34 | Reflects Last Updated Date of Foster Youth Match Results |