Tool Search: CALPADS LEA Programs
The CALPADS LEA Programs Extract reports the days a student has participated in a Program 194 (Expanded Learning Opportunities).
Refer to the CALPADS LEA Programs (September 2025) for details on reporting logic and report layout information.
CALPADS LEA Programs ExtractReport Editor
| Data Element | Description |
|---|---|
| Set Up | |
| Search Calendars | Use the search field to narrow the list of calendars to select. Use the Expand All/Collapse All option. Place a checkbox next to the desired school and calendars.
As noted previously, all calendars are automatically selected because this is a school-wide report. |
| Report Options | |
| Effective Date
Required |
All Program 194 participation records from the start of the calendar up to and including the entered date are reported. |
| Start Date | Entered date indicates the date the student began receiving Program 194 services. |
| End Date | Entered date indicates the last day the student received Program 194 services. |
| Transaction Type
Required |
Indicates the type of transaction that occurs:
|
| Ad hoc Filter | A selection in this field causes the extracts to only include students included in the Ad hoc filter. For example, if an Ad hoc filter is selected that lists all 9th grade students, only those students are included in the extract. |
| Select one or more Grade Levels
Required |
Only students in the selected grade levels who meet the other report requirements are included in the report. The list of grade levels includes only those that are in the selected calendar. |
| Output Options | |
| Report Processing | To generate the report immediately, select Generate Now option. To choose when the report generates, use the Submit to Batch option.
The Batch Queue processing can be used for both the report generation and the report review, allowing results to be reviewed later. |
| Format Type | Determines in which format the report generates - Caret Delimited (State Format), CSV, or HTML.
CSV Best Practice
CSV files usually open with the Microsoft Excel application. The default handling of date values in Excel removes leading zeros. This causes issues with reporting. To prevent this issue, perform edits to CSV files through a text editor application such as Notepad, Notepad++, etc. Or, to use Excel, ensure that all date fields are set to format MM/DD/YYYY with leading zeros (e.g., 8/4/2024 should display as 08/04/2024). |
Generate the Extract
See the blue callout above for details on report logic and report layout.
- Select the applicable Calendar(s) to include in the report.
- Select the Effective Date for the report.
- Select the Start Date and End Date for the report.
- Select an Ad hoc Filter from the dropdown list, if desired.
- Select the desired Transaction Type.
- Select at least one Grade Level to include in the report, or leave the selection at All.
- Select the desired Report Processing option of Generate Now or Submit to Batch Queue.
- Select the desired Format Type.
- Click Generate. The report displays in the selected format.
