|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for all contact information records to contain data and not be blank.
This integrity check identifies email address records where the email address is blank 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 Blank Emails(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries active email address records where the email address is blank so that these records can be deleted.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL
Snapshot GUID: BBDW.FACT_CONSTITUENTEMAILADDRESS.CONSTITUENTEMAILADDRESSSYSTEMID