Page Comparison

...

The execution path is not trivial so I'll walk through the process in english (below).
By necessity I do a lot of generalizing but I also link to the code.

In case you are curious, the key parts of the EAS data model are here

• http://code.google.com/p/eas/source/browse/trunk/database/erd_20110901.jpeg

OK, off we go...

We start by doing to blanket validations and standardizing some values.
This is done in this db proc:

...

• http://code.google.com/p/eas/source/browse/trunk/etl/sql/migrate_1-0_beta_to_1-0_prod/tg_address_base_before_ddl.sql

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.