To allow information that has been deleted in the ATO’s Integrated Core Processing system to be accurately reflected in the data warehouse, the ANAO recommends that the ATO more regularly performs the data extraction and reconciliation routines between the Integrated Core Processing system and the data warehouse.
We agreed with this recommendation and implementation was completed on 20 June 2014.
Data replication routines have been enhanced and updated to better reflect the content of the Integrated Core Processing System. These routines are now able to detect and deal with changes in the data that previously went undetected.
Data reconciliation is run on a daily basis and is used as a measure of the accuracy of the replication process.