Accessed from the navigation tree under the Student Data then the Programs node. If an Aeries table is available for the Educational Program, use the table instead of the Special Programs (PGM Table) form. Examples are Special Education and Free and Reduced Meals. For GATE either the GATE page or the Special Programs form can be used, but not both.  For 504 program, either the 504 page or the Special Programs form can be used, but not both.


Note: The logic to autoclose a participation program 30 days prior to the end of the school year is being removed in a future enhancement that will be available at the end of the 2025/26 academic year. New logic will require the SPRG extract to be run after the last day of school in order for a Participation Program to extract with an end date in SPRG files.


Open participation programs will continue to extract in the subsequent years.  If the start date of the participation record is prior to the current year, Aeries will pull the start dates from the enrollment record.


NOTE: CDE now requires all program 191 records to be closed at the end of the school year. Users must end records in Aeries by the end of each academic year and create new records for the following academic year after Homeless statuses have been reverified to avoid the new SPRG errors. CALPADS EOY Reporting Roadmap


Click on the More Info button to view any additional fields that have data. 



Click on the pencil icon to view/edit all the possible fields on this page:



Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Program Code
PGM.CD
03.13
Education Program Code
Many program codes will be used by CALPADS. Refer to the CALPADS Code Set: Education Program for a list of codes that will need to be populated and reported. Special Ed is reported by the Special Ed vendor. NSLP is populated in the Free and Reduced Meals area of Aeries. GATE can be populated in PGM or the GATE area of Aeries but not both. 504 can be populated in 504 or PGM but not both.
Participation Start Date/
Eligibility End Date
PGM.PSD
PGM.ESD
03.15
Education Program Membership Start Date
Dates will be extracted as they are in Aeries unless they extend beyond the enrollment. If the date is before the Enrollment date, the Enrollment date will be used. Eligibility Start Date will be extracted for certain programs.
Participation End Date/
Eligibility End Date
PGM.PED
PGM.EED
03.16
Education Program Membership End Date
Eligibility End Date can also be extracted for certain programs
Services Received
PGS.SR
03.18
Education Service Code
CALPADS Code Set: Education Service Title I Part A Basic (Education Program code = 122). If School Wide Program (SWP) Title 1, SPRG records do not need to be submitted per CALPADS.
School Taken
PGM.SCL
03.05
School of Attendance
Link to Information on PGM.SCL Field
CA Partnership Academy
PGM.CPA
03.19
California Partnership Academy ID
For Education Program Code = 113 this field was recently changed to be a 5-character field, enter the Academy ID in the COD table and select in this field



Aeries Field Name
Aeries Table.Field

CALPADS

FldNum

CALPADS Name

Comment

Dwelling Type
PGM.HDT
03.23
Homeless Dwelling Type
For Education Program Code = 191 – Homeless. CALPADS Code Set: Homeless Dwelling Type
Unaccompanied Youth
PGM.UY
03.24
Unaccompanied Youth Indicator
For Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless is not in the direct care of their parent or guardian.
Runaway Youth
PGM.RA
03.25
Runaway Youth Indicator
For Education Program Code = 191 – Homeless. An indication of whether or not a student who has been identified as homeless who is less than 18 years of age who has left home without parental/caregiver permission and stay away for one or more nights.
Note: Once a student is reported as a runaway youth for a given school year, even if the student is no longer a runaway, the indicator (PGM.RA) should not be changed to N unless a correction is being made.
Note, as of Sept, 2021, this indicator has been retired.
State Foster ID
SSD.FID
03.26
Student Foster Identifier
Not required at this time. Can also be populated on the Student Secondary Data form.