Address

This integrity check identifies addresses with an end date but not a Do Not Mail flag so that the DNM flag can be added.

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.

This integrity check identifies address records without a start date so that the start date can be filled in with the date that the record was added to DART.

This integrity check identifies address records that are missing a type so that it can be filled in with a generic type.

This integrity check identifies constituents without a primary address but with valid addresses in DART so that one of those addresses can be made the constituent’s primary address.

This integrity check identifies duplicate addresses on a constituent’s record so that the duplicated record(s) can be inactivated.

This integrity check identifies address records on household constituent records so that the address record can be deleted.

This integrity check identifies address records where the greater metro area (GMA) address attribute is not in alignment with the definition for the address’s zip5 so that the GMA address attribute can be updated.

This integrity check identifies address records where the international gift region (IGR) address attribute is not in alignment with the definition for the address’s country so that the IGR address attribute can be updated.

This integrity check identifies address records where the major gift region (MGR) address attribute is not in alignment with the definition for the address’s country so that the MGR address attribute can be updated.

This integrity check identifies address records where the major gift region (MGR) address attribute is not in alignment with the definition for the address’s zip5 so that the MGR address attribute can be updated.

This integrity check identifies active address records where the zip code and state combination do not align with USPS so that the address can be re-validated and corrected.

This integrity check identifies address records where the primary metro area (PMA) address attribute is not in alignment with the definition for the address’s zip5 so that the PMA address attribute can be updated.

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.

This integrity check identifies address records on constituents that have both (1) an address that is marked as primary but is invalid (i.e., has a Do Not Mail flag), and (2) a valid home address so that the valid address can be made into the primary and the old primary address can be end-dated and marked as Do Not Mail.

This integrity check identifies addresses on organization constituent records that have an address type that isn’t related to organizations so that the address type value can be updated to Business.

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.