The SPRG ODS Reconciliation process is designed to analyze the SPRG data in CALPADS and provide the submission records necessary to upload program records into CALPADS aligning the data between the two systems.  


The Aeries SPRG Enrollment Update process can be run multiple times.  Each time the process will analyze the SPRG data in CALPADS and generate the submission records necessary to match CALPADS to your local data.  Subsequent files will have less and less records to post back to CALPADS. 


For information on processing SPRG records, see CALPADS Extracts - Enrollment Update documentation.


The following programs are used for CALPADS reporting and are identified as Participating or Eligibility. Refer to the documentation link for more information about the Education Program code.


Education
Program Code
Education
Program Name
Membership
Category Code/Name
  
Last Academic
Year Effective
Freshdesk
Documentation Link
101504 Accommodation Plan
3 - Participating

108Opportunity Program3 - Participating
113California Partnership Academy3 - Participating
122NCLB Title 1 Part A Basic Targeted3 - Participating
127Gifted and Talented Education (GATE)1 - Eligible
135Title 1 Part C Migrant1 - Eligible
144Special Education1 - Eligible
162Pregnant or Parenting Programs3 - Participating
174NCLB Title I Part A Neglected3 - Participating
181Free Meal Program1 - Eligible
182Reduced-Price Meal Program1 - Eligible
185Transitional Kindergarten3 - Participating
191Homeless Program1 - Eligible
192Armed Forces Family Member1 - Eligible




Program Extract Date Notes  


Participating Programs (Membership Category - 3) – Program dates will be extracted unless the program dates are not within the school enrollment ranges.  If the program dates are outside of the school enrollment range, the school enrollment dates will be extracted.


Eligibility (Membership Category - 1) – Program dates will be extracted.

  • The program start date can be before the enrollment date, but the end date has to be within the enrollment date range.
  • If the student’s school enrollment exit date is before the program date, the exit date will be extracted.
  • Eligibility programs can have overlapping records if the school School of Attendance is different.

For FRE (NSLP/Free and Reduced Meals) - Only FRE records with current year dates will be extracted.  FRE records without any Eligibility dates will not be extracted. 


Special Notes  


Education Program Code 101 - 504 Accommodation Plan:  Refer to the following documents for more information on 504 Plans in Aeries:  504 Plans - How does Aeries extract 504 Plan records?


Education Program Code 113 – California Partnership Academy:

  • CALPADS will only accept valid California Partnership ID. If there are invalid codes or blanks in the CALPADS SPRG ODS file, Aeries will extract the student’s code from PGM.CPA if available.


Education Program Code 135 – Title 1 Part C Migrant:  Beginning in 2025/26 academic year, the Migrant Ed program code 135 will no longer be reported in the SPRG extract. This information will be extracted using the MEPS extract in CALPADS ODS Extracts.


Note: Aeries is currently working on a future enhancement for importing the MEPS extract file into Aeries. An idea is available for users to follow:  https://ideas.aeries.com/forums/925735/suggestions/49916976