Review Donors with $10K+ Gifts with No Known Address Information

What Does It Do?

The OUD-DS3 best practice is for donors of large gifts to be able to be identified if they are a foreign entity, in alignment with HEA 117.

This integrity check identifies constituents who have given a $10,000+ one-time gift who have no known addresses so that GRA can research the constituent's address for auditing purposes (HEA 117 / NSF). 

How Is This Done?

This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[INTEGRITY_REVENUE_Review 10K Donors with No Known Addr(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries constituents without any addresses in DART (valid or invalid) with a financial transaction of $10,000+ (may be a split gift) that was added to DART in the last six months; no counting methodology or transaction-related filters are applied to this. Constituents are given categorical flags based on whether they have any valid, any invalid, or no email or phone in DART; phone country and email domains can help to provide clues about whether the constituent is a foreign entity.

Resources and References

S:\IDS\MES\SQL Scripts\DATA QUALITY\REVENUE

Snapshot GUID: BBDW.USR_FC_FTL_CURR.ConstituentDIMID -> Constituent SystemID