Remove UAG Unengaged Constituent Attribute for Constituents Aged 96+ if Engaged

What Does It Do?

The OUD-DS3 best practice is for constituents aged 96 or older to be flagged with a uAG Unengaged Constituent attribute if they have no interactions or recognition credit in the last six fiscal years.

This integrity check identifies all constituents aged 96 or older who have interactions or recognition credit in the last six fiscal years so that the uAG Unengaged Constituent attribute can be removed from their record. 

How Is This Done?

This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ATTRIBUTE-Remove AG Exclusion 96+ without Recog or Interactions in 6FYs(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries all constituents aged 96 or older who have any gift recognition in the last six fiscal years or any interactions* in the last six fiscal years, and who have the Annual Giving Exclusion - uAG Unengaged Constituent attribute. It provides information for the attribute to be removed from the constituent’s record

* Interaction types included: Email (Introductory), Letter (Introductory), Phone Call (Introductory), Phone call, Visit (Campus), Visit (Introductory), Visit (Non-Campus), Visit (Phone/Virtual), Event Attendance, Internal Action-Faculty Contact, Internal Action, Email, Event, Text Massage, or Mail

Resources and References

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

Snapshot GUID: BBDW.DIM_CONSTITUENT.CONSTITUENTSYSTEMID