The ones that start with CMS are for … well, the CMS. You will NOT be able to use these tables directly. See this post … Querying the CMS … for an explanation. The remaining tables are used by the auditing function. The schema is explained in the Auditor guide available (along with all documentation) here. That said, there is already an audit universe built for these tables included in the default installation.
Dwayne Hoffpauir 
(BOB member since 2002-09-19)