Body
|
Category: Address
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for all address records to have an address type.
This integrity check identifies address 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-ADDRESS-Add Missing Type(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries address 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 address record was added to DART in alignment with other contact information data standards.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\ADDRESS\
Snapshot GUID: BBDW.FACT_ConstituentAddress.ConstituentAddressSystemID