The Import SELA ODS process will import CALPADS ELAS data into two new Aeries fields.  The data will then be evaluated when creating the Aeries SELA file.  Students with matching data in the new CALPADS fields and in Aeries will not be extracted.


Below are instructions for the Import SELA ODS Extract File process:


1.  Download the CALPADS Student  English Language Acquisition Status ODS Download file:

  • Reports > Extracts > Request CALPADS File > ODS Extracts > Record Type of Student English Language Acquisition Status ODS Download
    • Enter a date range with start date of 1/1/2000 and end date of today
    • Do not select the “Active Student” option
    • Enter an Extract File Name


2.  Retrieve the Student English Language Acquisition Status ODS Download files:

  • Reports > Extracts > Download Extract
  • Extract Type Student English Language Acquisition Status ODS Download
  • Download the files to a location on your hard-drive


3.  In Aeries, on the Create CALPADS Extracts form, ODS Reconciliation, SELA Import tab:

  • Click on the SELA Import tab
  • Click on the Select SELA ODS Extract File and browse to the CALPADS Student English Language Acquisition Status ODS Download file
  • Click on the Load Selected File button to load the file
  • Click on the Update LAC.EAC and LAC.EAD button.  The data from the CALPADS file will be updated in the two new LAC fields:    
    • English Language Acquisition Code (LAC.EAC)
    • English Language Acquisition Date (LAC.EAD)