What is reconciliation?  Which reconciliation approach should be used? 

How often should an Enrollment Update be run? 

Many records were loaded into Aeries during the Enrollment Update Process why does the SENR extraction contain less records? 

What County, District, School code should be populated at the District School 0 for a database that contains more than one LEA?  


What is reconciliation?  Which reconciliation approach should be used? ↑

In Aeries, reconciliation is called Enrollment Update Process.


Aeries recommends using the Enrollment Update process that is located on a tab within CALPADS Extracts. The Enrollment Update Process is designed to take the CALPADS Real Time Extract files and validate the data against what is currently known in Aeries. This process will adjust CALPADS data to be aligned with Aeries data. As a result, subsequent submissions will be more successful. If you have many reoccurring errors for many students, this is an efficient method for updating CALPADS with your data. This process should be done on a regular basis in order to maintain accurate clean data.


There are three files that can be reconciled through this audit process:  SENR, SPRG, SELA. Use the following links for further information:


SENR Enrollment Update

SPRG Enrollment Update 

SELA Enrollment Update


How often should an Enrollment Update be run? ↑

All districts need to perform Enrollment Updates at the start of every school year and should continue maintenance throughout the school year.  This process should be done every few weeks and no longer than every month, thereafter. Please refer to the following article for more information:  

CALPADS Annual Maintenance - Ongoing 



Many records were loaded into Aeries during the Enrollment Update Process why does the SENR extraction contain less records? ↑

Only the records that need to be changed will be in the SENR extraction that will be uploaded to CALPADS.



What County, District, School code should be populated at the District School 0 for a database that contains more than one LEA?  ↑


When a database has multiple Districts within the LEA, they must choose one of those district county codes to use and populate in the Distict CDS code fields. Leaving this field blank or populating with zeros can cause the extract process to not properly generate records in many of the CALPADS extract processes.


It is suggested to populate the District School 0's CDS code with the value for the school records being generated. Then when processing the 2nd LEA, the CDS code for District School 0 must be changed to the other LEAs CDS code before generating the CALPADS extracts.