Hello Kevin and other interested parties. The following is from a Sage X3 ERP implementation and may have overlap with other product links.

As you discovered, there are some self-described tables in the SEI database where this metadata, information resides and then there are a series of tables with convention BIPxx. 

I found the following, but not sure if the Central Point Library Models come standard or only included in our training environment:

 In case this is not available.....

On a cursory look in my demo db for Sage X3 ERP implementation, I found the following tables have data; which looks like what you want (and also do not want) below:

Note: What I cannot easily tell you is how to link these tables, except that the process ID for a given data model, is a good starting place.

Of the self described tables, see if the following are useful for your needs:

security tables: SEC_*, especially SEC_USERS, *process authorization, *restrictions and *roles. 

*OLAP* tables describe Cubes and other OLAP objects such as Dimensions, Measures and other data model, design elements

*RPT* for SEI report configurations. those that can be scheduled / delivered

NEC* contains architectural metadata for a variety of uses such as the Excel Add-in, the Scheduler and history logs, notifications, Views and Global Parameter values to name a few.

BIP14 has the Process IDs (PRID14) with various attributes such as description (DESC14)

With the exception of BIP14, BIP01-BIP16 has a variety of other types of metadata, feel free to explore :-)

BIP43 and BIP44 includes metadata concerning Cubes

BIP45 includes metada concerning Fixed Assets link

The following tables were empty:
BIP30 - BIP42

Thanks Phil that data in the BIP14 table provided the information I needed!

Great to hear Kevin, When you have a chance, please mark this as 'Verified answer' so the community may benefit from this information.

Great to hear Kevin, When you have a chance, please mark this as 'Verified answer' so the community may benefit from this information.