|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for all email addresses to contain an “@” symbol.
This integrity check identifies email address records that do not contain an “@” so that they can be given a Do Not Email flag and end-dated (inactivated).
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-EMAIL-Emails without @(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries email address records that are not marked as Do Not Email and are active (no end date or end date is in the future) and do not contain an “@” symbol. It adds a Do Not Email flag to these records and inserts an end-date of the integrity check run date to inactivate the record.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL