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?
Has all the relationships outlined. In part, some of this would be jiveDocVersion.status and then using the containerType/containerID to determine location.