Add Missing End Date to Emails

What Does It Do?

The OUD-DS3 best practice is for emails with a Do Not Email flag to also have an end date, unless they are a primary email address.

This integrity check identifies non-primary email records with a Do Not Email flag that are missing an end date so that the end date can be updated to the date that the email record was last modified.

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 End Date(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries non-primary email records that are marked as Do Not Email and which do not have an end date, and creates a batch to add an end date using the date that the record was last modified.

Resources and References

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

Snapshot GUID: BBDW.FACT_ConstituentEmailAddress.ConstituentEmailAddressSystemID