|
Category: Email
|
Frequency: Monthly
|
Platform: SQL Server
|
Owner: IDS
|
What Does It Do?
The OUD-DS3 best practice is for all email address records to have a type.
This integrity check identifies active email address records that do not have a type so that the default type value “E-mail Address” 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 Type(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries email address records that are missing a type. It inserts the email address type value of 'E-mail Address'.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\EMAIL