Requirement on Audit Trail

Hi Team,

Please could you suggest best way for the below requirement.

Requirement: Siebel 8.1.1.11 version(Audit Trail VBC)

In my requirement Account May have one or more Contact records(1:M) and 1Contact May have one or more Contract Roles (1:M).

So my requirement is to achieve whenever user deletes the Contract Roles Record(using Delete button) I need to capture the deleted records i.e one or more row_id values.

Please could you suggest may I use Workflow or Audit Trail BC or Script or something else ?

Note : The deleted record should be queried by SQL Query means that should exist physically….