Delete Error Phone Numbers

This integrity check identifies phone records that have an error message in the phone number field so that the phone record can be deleted.

Category: Phone

Frequency: Monthly

Platform: SQL Server

Developer: IDS

Analyst: DMT

This integrity check identifies phone records that have an error message in the phone number field so that the phone record can be deleted.

The OUD-DS3 best practice is for the length of phone numbers to match up with local standards. In the batch template, when phone numbers are not in alignment with standards, they are replaced with an error message.

This integrity check queries active phone records that have been overwritten with any of the following validation errors:

• Check the length of the local phone number

• Country code should not be in local number

• Please enter Country

The output of this integrity check is a batch to delete these phone records.