Table of Contents

Overview  

Security  

File Downloads  

Enrollment Update Tab  

Identifiers Tab  

ODS Reconciliations, SELA Import Tab  

Fall 2 Tab  

EOY tab  

Direct Certification  

Other Options  

Code Translations  

LTEL Import  

Schools  


Overview  

Navigate to School Info > Imports and Exports > CALPADS Extracts


The CALPADS Extracts page in Aeries Web version is designed to create various CALPADS files for CALPADS submissions and perform other CALPADS functions. The CALPADS Extracts page can be accessed from the school or district login.  


CALPADS Extracts page


The CALPADS Extracts page can also be added to My Favorites to provide easy access to the page.


Favorites Menu


Security  

Only Admin users or Users with the Admin function to State Reporting can access the functions on this page. 

Security


File Downloads  

All extracts created on this page are available in the File Download section at the bottom of the page. Here is a link to the documentation for this area:   


File Downloads


Each function area has it's own tab in the menu on the left side of the CALPADS Extracts page. For each tab listed below there are embedded links to the separate documentation for each area.


Enrollment Update Tab  

The Enrollment Update Tab is used to create the following files to submit to CALPADS:

  • Create Enrollment Update Files button:
    • SENR - Student Enrollment
    • SINF - Student Information
    • SPRG - Student Programs
  • Create Student Language Acquisition File (SELA)


Identifiers Tab  

The Identifiers Tab is used to obtain SSID numbers from CALPADS for students new to the district: 

  • Create SSID Request File (SENR) and Import New and Replacement SSID files.  The import will update the students' new SSID and other existing CALPADS data (i.e. ELAS, SWD, etc) into Aeries.


ODS Reconciliations, SELA Import Tab  

The ODS Reconciliations, SELA Import Tab is used to create the following files to submit to CALPADS: 

  • SENR (Enrollment) ODS Reconciliation - The SENR ODS Reconciliation process is designed to analyze the enrollment data in CALPADS and provide the submission records necessary to match CALPADS to your local data.  
  • SPRG (Program Data) ODS - This process is designed to analyze the SPRG data in CALPADS and provide the submission records necessary to match CALPADS to your local data.  The SPRG ODS Reconciliation is not a required process but can be used to align CALPADS records with Aeries. 
  • SELA Import (Student Language Acquisition ELAS) - This process will import CALPADS ELAS data into two Aeries fields: ELAS Code (LAC.EAC) and ELAS Date (LAC.EAD), this process should be run at the beginning of the school year before the first SELA file is submitted to CALPADS.


Fall 2 Tab  

The Fall 2 Tab is used to create the following files to submit to CALPADS: 

  • Create Staff Files button will create the following files
    • SDEM - Staff Demographics
    • SASS - Staff Assignments
  • Create Course Files button will create the following files
    • CRSE - Course Section Enrollment
    • SCSE - Student Course Section Enrollment
  • Create Post Secondary File will create the following file.  
    • PSTS - The PSTS file is a new file for the 2019/2020 school year


EOY tab  

The EOY - End of Year Files tab is used to create the following files to submit to End-Of-Year files to CALPADS: 

  • Create Course and Staff Files button will create the following files:
    • CRSC - Course Section Completion
    • SCSC - Student Course Section Completion
    • SDEM - Staff Demographics
  • Create Incident Files button will create the following files:
    • SINC - Student Incident 
    • SIRS - Student Incident Result
    • SOFF - Student Offense
  • Create Career Technical Education File
    • SCTE - Career Technical Education File
  • Create Work-Based Learning File
    • WBLR - Work-Based Learning Records file
  • Create Absence Summary File
    • STAS - Student Absence Summary

     

Direct Certification  

The Direct Certification tab is used to load the CALPADS Direct Certification File into the FRE table.


Other Options  

The Other Options tab holds various options that are available that need to be configured before creating extracts.

 

Code Translations  

The Code Translations tab is used to translate Aeries codes to CALPADS codes when different. This MUST be set up before creating extracts.


LTEL Import  

The LTEL Import tab used to import CALPADS Language Assessment data into Aeries.


Schools  

The Schools tab displays schools to select for the extracts.


Summer ELPAC Testing  

The Summer ELPAC Testing tab displays functions to facilitate Initial ELPAC testing during the summer of for English Learners. This process can be started either before or after a new year database has been created.