okay so the table in question has the following columns

DateTime

Acct_Number

SSN

Script_Code

Div_indicator

first_name

last_name

ani

terminate_area

transfer_area

Periodically we are getting records in this table where ani = 614xxxxxxx

We want to prevent all records with the ani = 614xxxxxxx from ever being inserted into the table.

We thought about doing a scheduled job and purging those records out on a schedule but we thought that if there was a large number of records it could cause some issues with performance and we also have a sync process where this table is being synced to another server which is used for reporting and we don't want to risk having a sync catch these records before our scheduled job had a chance to run and purge the records. It seemed like purging these records in realtime was the best option for us.