The email is not visible in the UI, but it is still triggering the validation script

Summary:

We have a validation script that queries active contacts where Status = 'A' and Internal Flag = 'N'.
This validation is triggered in both scenarios — when a user enters an email for a new contact or modifies the email of an existing contact.

Currently, we are trying to create a new contact, but we're receiving a duplicate email validation error.

Here's what we've checked so far:

1. In the UI, we do not find any contact with this email.
2. In Analytics, the email is not present.
3. We exported contact data and searched for the email — not found.
4. We also exported records where