Report 18.2 Work-Based Learning – Student List
(Updated 04/15/2024)
Description: Reports the total number of students with a Work-Based Learning record and the count for each Work-Based Learning Type.
Report Type: Snapshot / (EOY 1)
Security Roles: EOY 1 Reports Role
Data As Of: EOY 1, July 1 – June 30
Basic selection criteria:
- Enrollment at a school of Attendance that overlaps the selected Academic Year
- Enrollment Status Code = 10, 20, or 30
- Grade Level = 09-12
- Work-Based Learning (WBLR) records in the selected Academic Year (Field 21.07) at the School of Attendance (Field 21.05) from the Enrollment record
- Student Information (SINF), Student Program (SPRG) and Student English Language Acquisition (SELA) and Foster Youth data used for selecting student subgroups (e.g. Race/Ethnicity, Homeless, EL, etc.) are selected from the most recent record that overlaps the qualifying enrollment.
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
- School Type
- School
- Grade
- Gender
- Ethnicity/Race
- Students with Disabilities
- Socio-economically Disadvantaged
- English Learner
- Foster Youth
- Education Program
- Work-Based Learning Type
Report Logic
| 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 | 3. SENR Field 1.08 – SSID |
| 4 | SINF Fields 2.11 - 2.13 for Student Legal Name |
| 5 | SINF Fields 2.10 – Local Student ID |
| 6 | SINF Field 2.19 – Student Gender Code |
| 7 | SINF Fields 2.23-2.29 Race Ethnicity determined per criteria: |
| 2.23 = Y (Hispanic) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 100 (Am Ind/Alaska Nat) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 201 - 208, 299, 400 (Asian) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 600 (Black/African Am) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 301, 303, 304, 399 (Nat Hawaii/Pac Isl) | |
| OR 2.23 = N and 2.29 = N and 2.25 = 700 (White) | |
| OR 2.23 = N and 2.29 = N and multi race categories in the most recent SINF (Multi) | |
| OR 2.24 = Y – OR - 2.23 = N and 2.30 = Y (Missing) | |
| 8 | SINF Field 2.18 – Student Birth Date |
| Column | Rules |
|---|---|
| 9 | SENR Field 1.24 – Grade Level Code |
| 10 | WBLR Field 21.09 – Work-Based Learning Type Code |
| 11 | WBLR Field 21.10 – Internship ID (if blank = N/A) |
| 12 | WBLR Field 21.11 – Work-Based Learning Hours-External (if blank = N/A) |
| 13 | WBLR Field 21.12 – State Course Code – Embedded Work-Based Learning (if blank = N/A) |
| 14 | WBLR Field 21.13 – Internship Employer Performance Evaluation Code (if blank = N/A) |
| 15 | WBLR Field 21.14 – Internship-LEA Sponsored Indicator (Y/N/if blank = N/A) |
| 16 | WBLR Field 21.15 – Internship-Certificated Supervisor Indicator (Y/N/if blank = N/A) |
Additional Resources
CALPADS File Specifications
Look for SSID Enrollment (SENR), Student Information (SINF) and Work-Base Learning (WBLR) tabs for the fields indicated in the report logic.
Work-Based Learning (WBLR) Data Population Training PowerPoint v1.1
Topics include: Name and definition changes for work-based learning indicator fields.
CALPADS Flash #174
Topics include: Name and definition changes for work-based learning indicator fields.
CALPADS Code Sets
This document contains the current code values referenced in the file specifications for the coded value data elements. The different course-related code definitions are listed in this document.