Body
|
Category: Address
|
Frequency: Monthly
|
Platform: SQL Server
|
Developer: IDS
|
Analyst: DMT
|
What Does It Do?
The OUD-DS3 best practice is for addresses with seasonal dates to have the type Seasonal.
This integrity check identifies address records with seasonal dates but where the type is not Seasonal so that the type can be updated to Seasonal.
How Is This Done?
This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ADDRESS-Update Type of Addrs with Seasonal Dates(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.
That view queries all address records with a seasonal start or end date where the type is not Seasonal, and creates a batch to update the type to Seasonal.
Resources and References
S:\IDS\MES\SQL Scripts\DATA QUALITY\ADDRESS
Snapshot GUID: BBDW.FACT_ConstituentAddress.ConstituentAddressSystemID