Body
|
Category: Address
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for primary metro area (PMA), greater metro area (GMA), and major gift region (MGR) to be aligned with the zip code of the address.
This integrity check identifies address records where the primary metro area (PMA), greater metro area (GMA), or major gift region (MGR) address attributes are not in alignment with the definition for the address’s zip code so that the address attributes 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 PMA GMA or MGR(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries all active US address records with a zip code where the PMA, GMA, or MGR address attributes are not in alignment with the PMA, GMA, and MGR defined for that zip code.
These addresses need to have these attributes removed in DART, and then the addresses can be re-run through the built-in DART validation tool to re-add the correct address attributes.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\ADDRESS\
Snapshot GUID: BBDW.FACT_ConstituentAddress.ConstituentAddressSystemID