CALPADS Report

Verify with Aeries Reports/Queries

1.1 Enrollment - Primary Status by Subgroup
Run Student Counts (CBEDS) 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.
1.6 Graduates and Dropouts by Subgroup
Run the following query in the prior school year to verify graduates:
LIST STU CID ID NM GR STU.HSG DG IF GR = 12
1.17 FRPM/English Learner/Foster Youth - Count
Check Foster Youth information from County.

Run the following query to verify ELs:
TOTAL STU LF BY LF

Run the following query to verify Homeless:
LIST STU PGM STU.ID STU.CID STU.SC STU.NM STU.GR PGM.CD PGM.ESD PGM.EED BY STU.SC IF PGM.CD = 191 AND PGM.ESD # NULL AND PGM.EED = NULL

Run the following query to verify FRE:
LIST STU FRE STU.CID STU.ID STU.SC STU.NM FRE.CD FRE.ESD FRE.EED IF FRE.ESD > 06/30/20##

Change eligibility start date to applicable date for each school year.
2.1 Title III Eligible Immigrants - Count
Run the following query to verify for Title III:
LIST STU SSD LAC STU.CID STU.ID STU.NM STU.GR STU.BCY STU.BCU STU.LF SSD.SUS LAC.USE LAC.USS IF STU.BCU # US.

Extract to Excel to manipulate the data for totals.
2.8 English Language Acquisition Status - Count
Run the following query to verify home language counts by school:
LIST STU SC CID ID NM HL HL? LF BY SC HL LF IF LF # 'English program code'

Change the STU.LF code in the IF statement to the code that represents English Only in your district. Extract to Excel to manipulate the data for totals.
2.9 English Language Acquisition Status - Census Comparison
Run the following query to verify by school:
TOTAL STU SC LF BY SC LF
2.12 English Language Acquisiton Status - ELs Reclassified RFEP
Run the following query to verify dates for RFEPs:
LIST STU LAC STU.CID STU.ID STU.NM STU.LF LAC.RD1 IF LAC.RD1 # NULL

Extract to Excel to manipulate the data for totals.