Unable to fetch old data from oks_level_elements_a(Audit table)

Hi All,

We have enabled audit for around 5 fields in oks_level_elements table in service contracts. Which will create a copy of this table with table name oks_level_elements_a having the fields.

The old data will be stored in audit tables and can be used to identify changes done to contract billing schedules.

Issue:

Old data is available in audit table but there is no join for base table to compare or validate the data. The old data is having a audit transaction type of 'D' and its ID doesn't match with any of the ID in base table oks_level_elements.