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 |
101 | 504 Accommodation Plan | 3 - Participating | ||
108 | Opportunity Program | 3 - Participating | ||
113 | California Partnership Academy | 3 - Participating | ||
122 | NCLB Title 1 Part A Basic Targeted | 3 - Participating | ||
127 | Gifted and Talented Education (GATE) | 1 - Eligible | ||
135 | Title 1 Part C Migrant | 1 - Eligible | ||
144 | Special Education | 1 - Eligible | ||
162 | Pregnant or Parenting Programs | 3 - Participating | ||
174 | NCLB Title I Part A Neglected | 3 - Participating | ||
181 | Free Meal Program | 1 - Eligible |
| |
182 | Reduced-Price Meal Program | 1 - Eligible |
| |
185 | Transitional Kindergarten | 3 - Participating | ||
191 | Homeless Program | 1 - Eligible | ||
192 | Armed Forces Family Member | 1 - 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