Add Missing End Date to Addresses

What Does It Do?

The OUD-DS3 best practice is for addresses with a Do Not Mail flag to also have an end date, unless they are a primary address.

This integrity check identifies non-primary addresses with a Do Not Mail flag that are missing an end date so that the end date can be updated to the date that the address record was last modified.

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 End Date(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries non-primary address records that are marked as Do Not Mail and which do not have an end date, and creates a batch to add an end date using the date that the record was last modified.

Resources and References

S:\IDS\MES\SQL Scripts\DATA QUALITY\ADDRESS

Snapshot GUID: BBDW.FACT_ConstituentAddress.ConstituentAddressSystemID