The trigger just inserts a copy of data into a backup table that has same structure.

Yes, data is updated after commit.

Thanks @ratbak.

I do not know about transaction isolation level. Grateful if you can throw more light.

There is a trigger on table Transfer, that happens on Insert of record.

Thanks