Supporting Reports Extracts
An LEA may request a Supporting Reports Extract file for specific Snapshot Reports. The LEA may select filter criteria prior to requesting the file based on the filters that currently exist in the respective Snapshot Report. Additionally, the data produced by the extract will contain data identical to the corresponding report.
User Roles needed
The functionality is only available to LEA level users. The following roles are required to be added to enable users to access and request any available extract reports associated to a submission.
- Data Certifier Role
- Fall 1 Reports Role
- Fall 2 Reports Role
- EOY 1 Reports Role
- EOY 2 Reports Role
- EOY 3 Reports Role
- EOY 4 Reports Role
- SELPA Reports Role
Available Supporting Reports
The following supporting reports are available for download as an extract. A user is required to have the appropriate reports roles associated to the submission.
Fall 1
LEA
- 1.2 - Enrollment - Primary Status Student List
- 1.18 - FRPM - English Learner - Foster Youth - Student List
- 1.20 - County Office LCFF - Student List
- 8.1 - Student Profile - List
- 8.1a - Student Profile Exits - List
- 16.3 - Students with Disabilities Profile - List
- 16.6 - Students with Disabilities - Student Services Student List
SELPA
- 16.3 - Students with Disabilities Profile – List (Fall 1)
- 16.6 - Students with Disabilities - Student Services Student List (Fall 1)
Fall 2
- 3.3 - Class Enrollment - Student List
- 3.7 - Course Section Enrollment - Count and Details
- 3.8 - Course Section Enrollment – Student List
- 4.3 - Staff Teaching Assignments – Detail
EOY 1
- 3.11 - Course Sections Completed - Student List for Departmentalized Courses
EOY 3
- 8.1 Student Profile - List (EOY3)
EOY 4
LEA
- 16.3 - Students with Disabilities Profile - List(EOY4)
- 16.6 - Students with Disabilities - Student Services Student List
SELPA
- 16.3 - Students with Disabilities Profile – List (EOY 4)
- 16.6 - Students with Disabilities - Student Services Student List (FEOY 4)
Requesting Supporting Reports Extracts
Click on Extracts link from the Left Navigation menu.
Locate and click the Supporting Reports Extracts option from the request CALPADS file buttons
Select the appropriate report extract from the dropdown menu
Supporting Extract Modals
The user will see varying versions of the extract request modal depending on the selected supporting report from the drop-down menu. Each modal will contain the same filters found in a normal report filter page. Below are samples of the report modals.
Supporting Report 8.1 Extract Modal
Academic Year filter
Select desired academic year
Status
Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.
Schools
Select the schools included on the report. To select one school at a time, click on school name and click on the single arrow button. To select all, click on the double arrow button.
Additional Report 8.1 filters
Make individual selections for each filter. If this is not the first time a request was made, the system will use prior cached request parameters made.
Request File button
Click on Request File button to execute the request.
Supporting Report 3.8 Extract Modal
Academic Year filter
Select desired academic year
Status
Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.
Schools
Select the schools included on the report. To select one school at a time, click on school name and click on the single arrow button. To select all, click on the double arrow button.
Additional Report 3.8 filters
Make individual selections for each filter. If this is not the first time a request was made, the system will use prior cached request parameters made.
Request File button
Click on Request File button to execute the request.
Supporting Report 3.11 Extract Modal
Academic Year filter
Select desired academic year
Status
Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.
Schools
Select the schools included on the report. To select one school at a time, click on school name and click on the single arrow button. To select all, click on the double arrow button.
Additional Report 3.11 filters
Make individual selections for each filter. If this is not the first time a request was made, the system will use prior cached request parameters made.
Request File button
Click on Request File button to execute the request.
Supporting Report 8.1 (EOY3 )Extract Modal
Academic Year filter
Select desired academic year
Status
Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.
Schools
Select the schools included on the report. To select one school at a time, click on school name and click on the single arrow button. To select all, click on the double arrow button.
Additional Report 8.1 filters
Make individual selections for each filter. If this is not the first time a request was made, the system will use prior cached request parameters made.
Request File button
Click on Request File button to execute the request.
Importing CALPADS Extract to Excel Format
CALPADS Supporting reports extracts, when downloaded are in .txt format. Opening the file brings up the Notepad application with some data that users might have difficulty reading. Users should instead convert the extract to Excel format. Below is a video tutorial on how to convert a extract file to Excel. Follow the instructions up to the 2 minute mark.
Click on image to play clip.