|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for all email addresses to only contain one ending (e.g., “.com”).
This integrity check identifies active email address records containing “.com.com”, “.gov.gov”, “.edu.edu”, “.net.net”, “.org.org” so that the repeated domain extension can be removed.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-EMAIL-Emails with Double Ending(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 contain “.com.com”, “.gov.gov”, “.edu.edu”, or “.net.net”, or ".org.org". It updates the email address to remove the repeated domain extension so that it only contains one domain extension.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL
Snapshot GUID: BBDW.FACT_CONSTITUENTEMAILADDRESS.CONSTITUENTEMAILADDRESSSYSTEMID