|
Category: Address
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for major gift region (MGR) to be aligned with the zip5 for US addresses.
This integrity check identifies address records where the major gift region (MGR) address attribute is not in alignment with the definition for the address’s zip5 so that the MGR address attribute can be updated.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ADDRESS-Misaligned Zip5 and MGR(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries all active non-UM US address records where the MGR address attribute is not in alignment with the MGR defined for that zip5 range or where the MGR address attribute does not exist but should.
These addresses need to have any existing MGR attribute removed in DART, and then the addresses can be re-run through the built-in DART validation tool to re-add the correct MGR attribute.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\ADDRESS\
Snapshot GUID: BBDW.FACT_ConstituentAddress.ConstituentAddressSystemID