Fix MGR for International Addresses

What Does It Do?

The OUD-DS3 best practice is for major gift region (MGR) to be aligned with the country of non-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 country 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 Country and MGR(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries all active non-US address records where the MGR address attribute is not in alignment with the MGR defined for that country 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