Inactivate Incomplete Addresses

What Does It Do?

The OUD-DS3 best practice is for addresses which are not complete and mailable to be marked as ‘Do Not Mail’.

This integrity check identifies address records that are missing the street information (known as the address block) so that they can be marked with a ‘Do Not Mail’ flag. 

How Is This Done?

This integrity check is run using a SQL Server view called [INTEGRITY_CHECKS].[dbo].[IDS.V-INTEGRITY CHECK-ADDRESS-Inactivate Incomplete Addresses(DW)], which is located in DB-OUD > Databases > INTEGRITY_CHECKS > Views.

That view queries address records for active constituents which are missing the address block (street information) and which do not have a DNM flag. It excludes addresses with an information source of ‘Intentionally Incomplete’. All of these addresses are given a ‘Do Not Mail’ flag with a reason of ‘Incomplete’, and those that are not marked as primary addresses are given an end date of the report date.

Resources and References

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

Snapshot GUID: BBDW.FACT_CONSTITUENTADDRESS.CONSTITUENTADDRESSSYSTEMID