Year for Census Queries is used for CALPADS historical estimates.
If you have need for official Fall 1 or EOY 4 counts, those should to be obtained by the 16.14 reports in CALPADS directly.
SIRAS census estimates use the archived record history within the SIRAS database, which can have minor discrepancies from CALPADS depending on what was actually reported and when.
SIRAS Fall 1 estimates are based on a query for the most recent archive occurring within a period July 1 from the prior academic year through the Fall CALPADS census date, with Active status only. This should capture the most recent IEP record that is effective as of the Fall census date.
SIRAS EOY 4 estimates are based on a query for the most recent archive occurring within within a period July 1 from the prior academic year through the end of the current academic year, including Active Status as well as Inactive Status with Inactive Date within the current year.
Potential discrepancies from CALPADS counts can arise due to enrollment timelines, which SIRAS does not have complete access to.
Using VLOOKUP with an SIS enrollment file can help identify if there were any missing records in the SIRAS estimate.