Body
|
Category: Address
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
This integrity check identifies duplicate addresses on a constituent’s record so that the duplicated record(s) can be inactivated.
The OUD-DS3 best practice is for contact information to exist one time in DART and not be duplicated.
The integrity check queries valid addresses (not marked as Do Not Mail) on active individual and organization records. If any addresses have the same address block (lines 1-4), city, state, zip code, and country, they are identified as duplicates. Only one copy of the duplicate address will be kept, and the best one is determined with the following sort order:
-
Information Source: Self-Reported > Web-Self Reported > Bio Acquisition Project uAG > Gift > Conveyed through UM Rep. > Constituent > (all others)
-
Address Type: Seasonal > Home > Business > (all others)
-
Address added date – ascending
-
Address start date – ascending, where nulls are replaced with 2100-01-01
-
Address ID – tiebreaker
The output of this integrity check is three batches.
-
If any of the address records which were not the best one to keep were marked as primary, the “keeper” address will be updated to as primary.
-
If any of the addresses have the same type as the one that will be kept, they are batched for deletion; it is not possible to batch update these to inactive if there is another copy of that address with the same type.
-
Any remaining duplicates will be inactivated with a Do Not Mail flag, a DNM reason of “Duplicate on DART Record”, and given an end date. These duplicates are kept so that processes which may try to re-add them see that this address with this type is already on the record and is not valid for the constituent.