Via the HPD:Associations form, can you look at the 'Last Modified By' field to see whether its a user or a system account that is changing the status of these records?
There is a defect on this # SW00429725
There is an escalation that goes out and cleans up all records in a Delete status is SYS:Application Clean Up. There's workflow involved that fires on many different forms to clean up the data.
Refer KB # KA369680 which will help.
Please Mark this reply helpfull or correct if this helps.
Thanks a lot Akash.
Glad i could help Chandrakala and thanks for marking the answer correct