|
Category: Phone
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for all contact information to exist on individual constituent records, not on their household record.
This integrity check identifies phone number records on household constituent records 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-PHONE-Delete Phones from Households(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries any phone records, valid or invalid, on household constituent records so that they can be deleted from DART - they are deleted, not just inactivated.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\PHONE
Snapshot GUID: BBDW.Fact_ConstituentPhone.ConstituentPhoneSystemID