|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for all contact information to exist on individual constituent records, not on their household record.
This integrity check identifies email address records on household constituent records so that they can be deleted.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-EMAIL-Delete Emails from Households(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries any email address records, valid or invalid, on household constituent records so that they can be deleted from DART - they are deleted, not just inactivated.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL
Snapshot GUID: BBDW.Fact_ConstituentEmailAddress.ConstituentSystemID