dms_audt column value lookups

Good day, all.

I am trying to do some querying in the dms_audt table to provide to my clients some data that will help them to understand the types and counts of objects that are being audited so that we can review the vast number of audit records that are being kept in the system.

Would somebody be able to help me find the cross-reference/lookup tables that go with the following columns so that I can translate the ID number to an actual English definition?




I'd like to translate these codes into the values that can be seen in the audit trail when viewed through PW Explorer/Administrator (e.g. "Action Name" of "Checked Out", "User Comment", and Object type of "Document", "Folder).

We are using PW SS4 version on a SQL*Server database.

Thanks in advance.