Phone

This integrity check identifies phone records that are missing a country so that the country can be filled in using contextual information like the constituent’s primary address or the phone number format.

This integrity check identifies phone records with an end date but not a Do Not Call flag so that the DNC flag can be added.

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

This integrity check identifies phone 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 phone 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 phone number but with valid phone records in DART so that one of those phone numbers can be made the constituent’s primary phone.

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

This integrity check identifies phone number records where the phone number is blank so that they can be deleted.

This integrity check identifies phone number records on household constituent records so that they can be deleted.

This integrity check identifies phone numbers that do not match up with local standards for telephone number length so that the phone record can be inactivated.

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