CALPADS Report
Verify with Aeries Reports/Queries
5.1 Program ParticipantsRun Student Counts (Census Day) Report.

Run the following query to verify program data:
LIST STU PGM STU.ID STU.CID STU.SC STU.NM STU.GR PGM.CD PGM.PSD PGM.ESD PGM.PED PGM.EED IF PGM.CD = ### 

Change the code number in the IF statement to the applicable program codes provided in your district.
For a list of programs see SPRG-Calpads-Special-Programs-Chart
5.4 Homeless StudentsRun the following query to verify Homeless Student program data:
LIST STU PGM STU.ID STU.CID STU.SC STU.NM STU.GR PGM.CD PGM.PSD PGM.ESD PGM.PED PGM.EED IF PGM.CD = 191

1.17 Cert Report
FRPM/EL/Foster Youth – Count
Run the following query to verify Free and Reduced Meal (NSLP) students:
LIST STU FRE STU.ID STU.CID STU.SC STU.NM STU.GR FRE.CD FRE.ESD FRE.EED IF FRE.CD = "R" OR FRE.CD = "F"
or
LIST STU FRE STU.ID STU.CID STU.SC STU.NM STU.GR FRE.CD FRE.ESD FRE.EED IF FRE.ESD < MM/DD/YYYY AND FRE.EED = NULL AND ( FRE.CD = "R" OR FRE.CD = "F" )

CBEDS Day is always the first Wednesday in October.  Adjust the date accordingly to capture students that should be reported and counted for Calpads 1.17 Certification report. Applications received by Oct 31st, Student Eligible for NSLP.

5.1 Program Participants (504)If you are using the 504 table to tag your 504 students, run the following queries to verify:
LIST STU FOF STU.ID STU.CID STU.SC STU.NM STU.GR FOF.SD FOF.ED IF FOF.SD < *10/03/2019 AND ( FOF.ED = NULL OR FOF.ED > *10/02/2019 )

504 programs should be stored in FOF or PGM but not both simultaneously for an individual student.
*CBEDS Day is always the first Wednesday in October.  Adjust the date accordingly to capture students that should be reported and counted for Calpads. 
5.1 Program Participants (GATE)If you are using the Gate table to tag your GATE students, run the following queries to verify:
LIST STU GTE STU.ID STU.CID STU.SC STU.NM STU.GR GTE.ESD GTE.EED GTE.PL IF GTE.ESD < *MM/DD/YYYY

*CBEDS Day is always the first Wednesday in October.  Adjust the date accordingly to capture students that should be reported and counted in your Calpads 5.1 Program Participants report.
5.1 Program Participants (LIP)Run the following query to verify Language Instruction Program (LIP) students:
LIST STU PGM STU.ID STU.CID STU.SC STU.NM STU.GR PGM.CD PGM.ESD PGM.EED IF PGM.CD = 300 OR PGM.CD = 301 OR PGM.CD = 302 OR PGM.CD = 303 OR PGM.CD = 304 OR PGM.CD = 305 OR PGM.CD = 306



Note:  These reports are only for guidance in capturing students that would potentially be counted in your CALPADS Certification Reports and is not meant to give you exact matches. Be sure to include your inactive students when running queries/reports as they are also counted if they have primary enrollment in your district on CBEDS Day.