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

How often should an ODS Reconciliation/Audit Process be run?

Many records were loaded into Aeries during the ODS Audit/Reconciliation Process, why does the SENR extraction contain less records?



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

In Aeries, reconciliation is called ODS Audit/Reconciliation Process.  


Aeries recommends using the ODS Audit/Reconciliation Process that is located on a tab within CALPADS Extracts.  The ODS Audit/Reconciliation Process is designed to take the CALPADS ODS Extract file 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 re-occurring errors for many students, this is an efficient method for updating CALPADS with your data. 


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


SENR Reconciliation

SPRG Reconciliation 

SELA Reconciliation


How often should an ODS Reconciliation/Audit Process be run? ↑

All districts need to perform an ODS Reconciliation/Audit Process when first using CALPADS.  This process should be done at least every two months, thereafter.  Please refer to the following article for more information:  

CALPADS Annual Maintenance - Ongoing 



Many records were loaded into Aeries during the ODS Audit/Reconciliation 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.