|
Category: Phone
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for phones with an end date to also be marked as Do Not Call.
This integrity check identifies phone records with an end date but not a Do Not Call flag so that the DNC flag 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-PHONE-Add Missing DNC Flag(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries phone records with a past end date that are not marked as Do Not Call and creates a batch to add the DNC flag.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\PHONE
Snapshot GUID: BBDW.FACT_ConstituentPhone.ConstituentPhoneSystemID