...
If make it past finding or creating the the ETL finds or creates a base address, we it will then insert the unit address if it is specified.
Again, we do not allow multiple active duplicates.
...
At the end of all this processing we compile results at the summary and detail detailed level and provide a QA report on the data.report results in three ways
- summary results
- detail on all AVS rows
- quality assurance on selected data
An example of this attached here: avs_load_report.zip
The summary results are shown in the table below.
These results are from 2011-12-07.
The first row represents rows from AVS that were successfully inserted from AVS.