Security  

CALPADS File Download  

File Layout  

File Import Process 

Completion Email  

Program Record  

Queries  

Student Programs Report  


Overview 


Beginning in the 2025−26 Academic Year, CALPADS will receive students’ migrant statuses directly from the Migrant Student Information Network (MSIN), and will provide LEAs with a weekly extract identifying those students. LEAs should download this extract and then upload it into Aeries, as the extract is the authoritative source for students’ migrant statuses. Since the CALPADS extracts are updated weekly through the CDE-MSIN data exchange, LEAs should upload the MEPS extract into their SIS on a weekly basis.


Although Migrant records are no longer included in the SPRG extract starting with the 2025–26 academic year, it is still recommended to maintain these records in Aeries. They continue to support other important functions such as CCGI, Analytic Indicators, locally saved queries, and validations, helping to accurately identify students for LCFF and other purposes.


NOTE:  Since this is a new process, there may be future adjustments needed to handle the import process more effectively. The program records that are provided by CALPADS may have start dates that reflect previous years and may have end dates that end in the future, making it difficult to maintain accurate data moving forward when the PGM table has historical Migrant Ed data. Ending the prior year records may be helpful, however, there's no guarantee that the records will not overlap.


In Aeries, the MEPS Import tab has been added to the CALPADS extracts page to facilitate this import process. 

Navigate to School Info > Imports and Exports > CALPADS Extracts.



Security  

Table
Permission
Description
State ReportingAdminTo Import MEPS extract file, users must be admin or have state reporting permission.



CALPADS File Download  


Users must first download the Migrant Eligible Program Students download file (MEPS) using the ODS Extracts in CALPADS. This file will extract as a TXT file. If using the template provided by CALPADS, the file must be saved as text file in .txt format.



Users will need to select the type of record history that they plan to manage in Aeries. There are two options, selecting either Active Student or Date Range. When selecting Date Range, enter the Enrollment Start Date no earlier than 07/01/2025 and enter today for the Enrollment End Date.


Selecting 'All' will include all students that have been identified as Migrant Eligible. Selecting 'Most Recent Only' will only contain the most recent students identified as Migrant Eligible.



NOTE: It is recommended to select 'All' students initially, then it is up to the district if they would rather include 'Most Recent Only' or 'All' students each time the import process is requested. The Latest Update Date column will reflect the date the MEPS record was last updated in the weekly MSIN import. 


File Layout  

The File Layout from CALPADS is defined as follows:


File Import Process


On the CALPADS Extracts page, select the MEPS Import tab. Select the MEPS file using the Select MEPS file button. The file must be a .txt file and must adhere to the correct format provided by CALPADS. The file name will display under the button as it is selected. 





Next select the Load File, Match & Update PGM Table button. This process will match students based on the student's SSID number. The Eligibility Start Date and Eligibility End Date in the file is used to match against existing PGM records that have previously been imported. The import will include students regardless of the student's status tag (STU.TG).

  • Special Programs (PGM) table can have program 135 records added or updated during this process. At this time, records will not be deleted during this process.
    • Program 135 Migrant Ed - A Migrant Ed record will be added if the records from the MEPS import file does not match to an existing 135 record. No program 135 PGM records exist for the student.
    • If there is a perfect match, same start date and end date in the file compared to Eligibility Start Date (PGM.ESD) and Eligibility End Date (PGM.EED) for program 135 record: 
      • The PGM record will not be updated. 
      • The SSD.MID Migrant State ID will be updated.
    • If there is a partial match:
      • If a matched SSID has the same start date in the file compared to Eligibility Start Date (PGM.ESD) in the Special Programs table but PGM has no end date and the import file contains an end date: PGM.EED will be updated with the date from the MEPS import file. 
      • If a matched SSID has the same start date in the file compared to Eligibility Start Date (PGM.ESD) in PGM, however, different end dates when comparing the file to PGM records: the date from the MEPS import file will be used to update the PGM.EED-Eligibility End Date.
    • If there are existing 135 records in the PGM table when the import file is processed and the SSID IS NOT matching to a student in the file, the PGM record will NOT be updated or deleted.
    • If there are existing 135 records in the PGM table when the import file is processed and the SSID IS matching to a student in the file, and the Eligibility Start Date (PGM.ESD) does not match the Eligibility Start Date in the file, the PGM record will NOT be modified or deleted.
  • Retired Migrant State ID - If a record in the import file includes a retired Migrant State ID number, the comment section will be updated to note the retired ID and the date it was retired. However, if the matching record already contains a comment, the retired information will not be added or overwrite the existing comment. 


NOTE:  If there are existing 135 records in the PGM table when the import file is processed and the SSID is not matching to a student in the file, the PGM record will not be deleted during the process. Only records that contain a matching SSID and a matching start date will be updated to reflect the new information from the MEPS Import File. 



Completion Email  


An email will be sent when the process completes. The email will indicate the number of SSD and PGM records processed, updated and/or added. At this time, no records will be Delete-tagged.



Program Record  


Once the import process completes, the Special Programs table will be updated to include matching students from the file. All matches are based on a matching SSID from STU.CID. The State Migrant ID number is stored in the Secondary Student Data - State Migrant ID field (SSD.MID) and will be updated during this process. The State Migrant ID will also display on the Special Programs record. When more than one program 135 record exists, the State Migrant ID will display on all records, including prior year records. 




If the record contains a retired MSID number, the ID and Retired Date will be inserted into the Comment field if the field is empty.


Queries  


To effectively manage newly imported student data, it may be necessary to update or modify existing records in 2025/26. All records from the prior year should be closed out beforehand. While this does not guarantee that a record won’t be altered during the import process, any student with a matching SSID may have their existing record updated. Starting with a clean slate of closed records helps ensure a smoother and more accurate import.


Users are encouraged to verify that all student records from the 2024/25 school year have been properly closed with an end date of 06/30/2025 if no end date exists. In the 2025/26 database run the following queries to close out all prior year open records. This practice supports the integrity of the MEPS Import process by keeping prior year data finalized and allowing new records to be updated appropriately. Moving forward from year to year, users should rely on the MEPS import for managing the start and end dates of the Migrant Eligible students.


Run a list of all program 135 records - know who your students are or how many have program 135

LIST STU PGM STU.ID STU.NM STU.GR STU.TG STU.CID PGM.CD PGM.ESD PGM.EED IF PGM.CD = '135'


Keep all program 135 records and identify any blank end dates including inactive students

KEEP STU PGM IF PGM.CD = '135' AND PGM.EED = NULL


For users with Change permission, you may query change the Eligibility End Date to reflect the last day of school or 06/30 if it's currently blank.

CHANGE STU PGM PGM.EED TO 06/30/2025 IF PGM.CD = '135' AND PGM.EED = NULL




Student Programs Report  


The Student Programs Report can be used to get a complete printout of all Migrant Eligible Students from the Special Programs (PGM) table. Navigate to Reports > Student Programs


In Report Options, select PGM# 135 and choose from a status: Active Programs Only, Current Year Programs or All Programs.



Any student meeting the criteria will display on the report broken down by grade level.