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:  A change to the SPRG extract on May 5th 2018 should alleviate the overlapping Participation errors for the next school year.  The SPRG extract has been adjusted to close all open participation program codes of: 108, 113, 122, 174 and 185 and also 101 (504 Accommodation Plans).  The programs will auto-populate an end date in the extract 30 days before the end of the school year, using the last day of school.  The actual program records in Aeries will not be closed.  


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.





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 populated in the Special Ed page; 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
PGM.PSD
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 can also be extracted for certain programs.
Participation End Date
PGM.PED
03.16
Education Program Membership End Date
Eligibility End Date can also be extracted for certain programs
Services Received
PGM.SR
03.18
Education Service Code
CALPADS Code Set: Education Service Title I Part A Basic (Education Program code = 122). If School Wide Title 1 (Education Program code =
121) 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
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.