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