Report 18.1 Work-Based Learning - Count

(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.1 Column 1-8


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.
Links to Report 18.2 Work-Based Learning – Student List
3 SENR Field 1.24 – Grade Level Code (Expandable/Collapsible column)
4 SINF Field 2.19 – Student Gender Code (Expandable/Collapsible column).
Note: A gender code will only display if there is at least one corresponding WBLR record.
5 Total Unduplicated count of SSIDs at each aggregate level
- If a student was reported under more than one Work-Based Learning Type or Grade for the same school, count the student only once, with the priority for highest Grade.
- If the student was reported under more than one school, count the student in each school once.
6 Duplicated count of SSIDs with Work-Based Learning Type Code = 10-Internship
7 Duplicated count of SSIDs with Work-Based Learning Type Code = 15-Student-led Enterprise
8 Duplicated count of SSIDs with Work-Based Learning Type Code = 20-Simulated Work-Based Learning

EOY 1 Report 18.1 Column 9-16


Column Rules
9 Duplicated count of SSIDs with Work-Based Learning Type Code = 25-Registered Pre-Apprenticeship Program
10 Duplicated count of SSIDs with Work-Based Learning Type Code = 30-Non-registered Pre-Apprenticeship Program
11 Duplicated count of SSIDs with Work-Based Learning Type Code = 35-Job Corps
12 Duplicated count of SSIDs with Work-Based Learning Type Code = 40-Workforce Innovation and Opportunity Act (WIOA)
13 Duplicated count of SSIDs with Work-Based Learning Type Code = 45-YouthBuild
14 Duplicated count of SSIDs with Work-Based Learning Type Code = 50-California Conservation Corps
15 Duplicated count of SSIDs with Work-Based Learning Type Code = 60-Transition Work-Based Experience
16 Duplicated count of SSIDs with Work-Based Learning Type Code = 65-Transition Classroom-Based Work Exploration

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.