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.


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

Supporting Reports Extracts

Number 1 Click on Extracts link from the Left Navigation menu.

Number 2 Locate and click the Supporting Reports Extracts option from the request CALPADS file buttons

Number 3 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

Supporting Reports Extracts 8.1 Modal

Number 1 Academic Year filter

Select desired academic year

Number 2 Status

Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.

Number 3 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.

Number 4 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.

Number 5Request File button

Click on Request File button to execute the request.


Supporting Report 3.8 Extract Modal

Supporting Reports Extracts 3.8 Modal

Number 1 Academic Year filter

Select desired academic year

Number 2 Status

Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.

Number 3 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.

Number 4 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.

Number 5Request File button

Click on Request File button to execute the request.


Supporting Report 3.11 Extract Modal

Supporting Reports Extracts 3.11 Modal

Number 1 Academic Year filter

Select desired academic year

Number 2 Status

Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.

Number 3 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.

Number 4 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.

Number 5Request File button

Click on Request File button to execute the request.


Supporting Report 8.1 (EOY3 )Extract Modal

Supporting Reports Extracts 8.1 Modal

Number 1 Academic Year filter

Select desired academic year

Number 2 Status

Select the version of the report from the revision status (e.g. Revised uncertified, LEA Approved) dropdown menu.

Number 3 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.

Number 4 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.

Number 5Request 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.