CALPADS ReportVerify with Aeries Reports/Queries
2.4 English Learner Education Services - Student Count Unduplicated
At an elementary school environment, run the following query to verify English Learner Services:
LIST STU TCH STU.ID STU.NM STU.LF TCH.TE TCH.ESR TCH.LI TCH.INS IF STU.LF = 'English Learner code'

At a secondary school environment, run the following query to verify English Learner Services:
LIST STU SEC MST TCH STU.ID STU.NM STU.LF TCH.TE MST.SE MST.ESR MST.LI MST.INS IF STU.LF = 'English Learner code'

Change the code number in the IF statement to the applicable code for EL.  Extract to Excel to manipulate the data for totals.

Flex:
LIST STU SEC MST CRS SSE STF STU.ID STU.NM STU.LF STF.LN STF.FN MST.SE MST.ESR MST.LI MST.INS IF STU.LF = 'English Learner code'  
2.5  English Learner Education Services - Unduplicated Count of Teachers Providing EL ServicesAt an elementary school environment, run the following total query to verify teacher services:
TOTAL TCH ESR LI INS BY ESR LI INS

At a secondary school environment, run the following total query to verify teacher services:
TOTAL MST ESR LI INS BY ESR LI INS
3.6 Course Section Enrollment - Count by Content Area At an elementary school environment, run the following total query to verify the number of sections offered:
TOTAL TCH CB BY CB

To include teacher enrollment counts, run the following total query:
TOTAL TCH CB TS BY CB TS

At a secondary school environment, run the following total query to verify the number of sections offered:
TOTAL MST CRS MST.CN CRS.C3 BY MST.CN CRS.C3

To include teacher enrollment counts, run the following total query:
TOTAL MST CRS MST.CN CRS.C3 MST.TS BY MST.CN CRS.C3 MST.TS
4.1 Staff - Count by FTE by Job ClassificationRun the following query to verify staff information:
LIST STF STJ STF.PSC STF.ID STF.SID STF.LN STF.FN STF.PS STF.TP STJ.JC STJ.JC? STJ.NC1 STJ.NC1? STJ.FTE STJ.SCL BY STF.PSC STF.ID STF.JC IF STF.TG # I

Extract to Excel to manipulate the data for totals.