Unifier 20.12.5 Audit Logs and DB table for all Record Numbers

Hi there,

I am trying to extract data from the BP Audit Log from the DB table UNIFIER_AUDITLOG.

For some BP record updates the field RECORD_NO is not always populated. I believe it should be possible to get the RECORD_NO using the fields: PROJECTID, SOURCEID & SOURCETYPE

Does anyone know of one central table that has all of the Record Numbers? Alternatively I will need to do joins for each Business Process that I need which will be a lot more work (and a lot more SQL)

Thanks in advance