Report 18.2 Work-Based Learning – Student List

(Updated as of 05/10/2021)

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)

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


EOY 1 Report 18.2 Report image


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.24-2.31 Race Ethnicity determined per criteria:
2.24 = Y (Hispanic)
OR 2.24 = N and 2.31 = N and 2.26 = 100 (Am Ind/Alaska Nat)
OR 2.24 = N and 2.31 = N and 2.26 = 201 - 208, 299, 400 (Asian)
OR 2.24 = N and 2.31 = N and 2.26 = 600 (Black/African Am)
OR 2.24 = N and 2.31 = N and 2.26 = 301, 303, 304, 399 (Nat Hawaii/Pac Isl)
OR 2.24 = N and 2.31 = N and 2.26 = 700 (White)
OR 2.24 = N and 2.31 = N and multi race categories in the most recent SINF (Multi)
OR 2.25 = Y – OR - 2.24 = N and 2.31 = Y (Missing)
8 SINF Field 2.18 – Student Birth Date

EOY 1 Report 18.2 Report image


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)

User Roles for Access:

EOY 1 Reports


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.