questions about audit trail value in siebel 81

Hello,

We have upgrade siebel from 7.7 to 8.1, before we have some external application need to get the SR audit trail value in database level.

But in siebel 81, the audit trail table structure totally changed, seems all the field value updated at the same time will be saved in only one record with some special code.

We got several questions about this:

1. is there any way to get the audit trail value for specified field in database level?

2. if the value cannot be got directly, is there any decode method?

3. we are thinking to create a customized table to load the audit trail values and we need the value almost real time, is there any way to track if the value was loaded sucessfully?