I'm working on one of the requirements where I need to separate the drafted,spam,hidden from the total public documents coming from JIVE_ENGAGE.JIVEDOCUMENT table?
If you are looking at DB tables, I would recommend checking this out:
SchemaSpy - Table setoopif.public.jivedocument
Has all the relationships outlined. In part, some of this would be jiveDocVersion.status and then using the containerType/containerID to determine location.
hope that helps.
Retrieving data ...