|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for emails with an end date to also be marked as Do Not Email.
This integrity check identifies email records with an end date but not a Do Not Email flag so that the DNE flag can be added.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-EMAIL-Add Missing DNE Flag(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries email records with a past end date that are not marked as Do Not Email and creates a batch to add the DNE flag.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL
Snapshot GUID: BBDW.FACT_ConstituentEmailAddress.ConstituentEmailAddressSystemID