Student-Based Experience Export

Use this report to export your student-based WBL experiences with employer, student, hours, pay and enrollment form details. You choose the columns, so it works for everything from a quick roster to a full data pull.

Last updated About 3 hours ago

Available in: Jobready CTE, Jobready CCR, Jobready WBL

File type	CSV
Default access	Cooperative Education Coordinators, Work Based Learning Observers, School Accounts and administrators (change who has access)

Filters

All filters are optional. Leave the dates blank to include every experience. The form has three sets of dates, and each does something different.

Filter	What it does
Start On / Start By (Experiences Started Between)	Include only experiences with a start date on or between these dates
Start On / End On (Experiences Active Between)	Include experiences that were active at any point between these dates. An experience counts if it started on or before End On and hadn't ended before Start On.
Start On / End On (Summary Data Between)	Limit the hours, pay and work log count columns to these dates. It doesn't change which experiences are listed.
WBL Types	Include only experiences of these WBL types
Experience Behind on Hour Reporting Only	Choose Yes to include only experiences that are behind on hours. See Good to know.
Include Archived Experiences	Choose Yes to also include archived experiences
School Tags	Include only experiences for students at schools with any of these tags
WBL Tags	Include only experiences with any of these tags
Columns	The columns to include in the file. Most are selected for you.

What's in the file

One row per experience, sorted by student last name and first name. You only get the columns you selected, in the order below. Columns marked "off by default" aren't selected until you add them.

Column	What it shows
Employer Business Name	The employer
Employer Industry	The employer's industry
Employer Address 1, Address 2, City, State, Zip	The employer's address (off by default)
Employer Contact Name	The employer contact on the experience
Employer Contact Title	The contact's title
Employer Email	The contact's email
Employer Work Phone	The contact's work phone
Employer Cell Phone	The contact's cell phone
Employer Career Cluster, Career Cluster Code, Career Pathway, Career Pathway Code	The employer's career cluster and pathway (off by default)
Student First Name	The student's first name
Student Last Name	The student's last name
Student Grade Level	The student's grade level
Student SIS Number	The student's local ID
Student Email	The student's email
Student Address 1, Address 2, City, State, Zip	The student's address (off by default)
Student Career Cluster, Career Cluster Code, Career Pathway, Career Pathway Code	The student's career cluster and pathway
Guardians	Each guardian with an email, as "Name (email)"
Start Date	The experience start date
End Date	The experience end date, or Present if there isn't one
WBL Coordinator Assigned	The coordinator on the experience
WBL Type	The experience's WBL type
WBL General Type	The general type of that WBL type
Job Title	The job title
SOC Code	The occupation code on the experience
Pay Stub Hours	Hours from approved pay stubs
Work Log Hours	Hours from approved work log entries, minus breaks
Hourly Rate	The experience's hourly rate
Gross Pay	Gross pay from approved pay stubs
Sending School	The student's sending school
School	The student's school during the experience
Course/Program	The course on the experience's section, or the experience's class, or the student's class. The header uses your site's name for classes.
Section	The section name and number on the experience
Teacher	The teacher for the experience's section
Special Education	Yes if the student is marked special education
IEP	Yes if the student has an IEP
Is Archived	Yes or No
Is Complete	Yes if the experience is marked complete or its end date has passed
Non-Traditional	Yes if the experience is marked non-traditional
Economically Disadvantaged	Yes if the student is marked economically disadvantaged
Notes	Notes on the experience
Tags	The experience's tags, separated by \|
Working Days	The days the student works, such as "M W F"
Termination Reason	The termination reason, if one was entered
Work Log Count	The number of approved work log entries, or N/A if there are none
Enrollment Form Statuses	One column per enrollment form template, named after the template. See below.

Enrollment form status values

Value	Meaning
Complete	The enrollment form is complete
In Progress	The form was started but isn't complete yet
Needs Attention	The experience's WBL type uses this form, but no form has been started
Not Required	The experience's WBL type doesn't use this form, or the form was marked not required

Good to know

Hours and pay are approved only. Pending and rejected work log entries and pay stubs aren't included in Pay Stub Hours, Work Log Hours, Gross Pay or Work Log Count.
"Behind on hour reporting" means no recent hours. An experience is behind if its WBL type requires pay stubs and none has been added in the last 14 days, or requires work logs and none has been added in the last 7 days. A new experience counts from its start date.
Archived experiences are left out by default. Choose Yes under Include Archived Experiences to add them, then use the Is Archived column to tell them apart.
Your access applies. The report only includes students you have access to. It also uses your selected school and class. School Accounts only see students from their own sending school.

Student data: This report can include student names, emails, addresses, local IDs, guardian names and emails, special education, IEP and economically disadvantaged flags, and pay. Leave out the columns you don't need.

Related reports

Work-Based Learning Export: one row per student per experience in a state reporting layout
Work Logs (CSV): every work log entry behind the Work Log Hours column
Pay Stub - All WBL Experiences: every pay stub behind the Pay Stub Hours and Gross Pay columns

Was this helpful?

Still need help? Ask the team