Where Document Revisions are Stored

[Paul_Ivany]

I am trying to find the latest Revision date of a document and I've been told the best way to find this is through querying the OnBase Database as the information is not exposed through the API.  I was wondering which table document revisions are stored in.

Thanks,

Paul

[Paul_Ivany]

I think I may have found the table. It looks like it's the REVNOTETABLE table. Would the REVNOTETABLE.DOCREVDATE give me the latest revision date of a document?

Thanks,
Paul