With respect to Volume/Snapshot policy - you are correct that the data is present. The publically available tables/views includes the "volume" table which has a "snapshotPolicyId" that links to the matching "objid" entry in the "snapshot_policy" table.
Almost everything in OCUM links together this way.
I hope this helps you.
Lead Storage Engineer | Consilio, LLC
NCIE SAN Clustered, Data Protection
Kudos and accepted solutions are always appreciated.