Body
|
Category: Phone
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for all phone records to have a phone type.
This integrity check identifies phone records that are missing a type so that it can be filled in with a generic type.
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 Type(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries phone records that do not have a type, and assigns the type based on the constituent type and seasonal information. Individuals will have a type of Home; unless seasonal dates are available and then the type is Seasonal; organizations will have a type of Business.
Additionally, any missing start date information is filled in with the date that the phone record was added to DART in alignment with other contact information data standards.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\PHONE\
Snapshot GUID: BBDW.FACT_ConstituentPhone.ConstituentPhoneSystemID