The Student Counts (Census Day) Report can be run to help identify various summarized data as of Census day by subgroups.
CALPADS Report | Verify with Aeries Reports/Queries | 1.1 Enrollment - Primary Status by Subgroup
| 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.16 Graduates and Dropouts (retired)
| Run the following query in the prior school year to verify graduates:
LIST STU CID ID NM GR STU.HSG DG IF GR = 12
(Seniors with Completion Status)
| 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 Acquisition Status - ELs Reclassified RFEP (retired)
| 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.
|
|
