IBM Maximo Spatial Asset Management, Version 7.6

Database tables and columns

IBM® Maximo® Spatial Asset Management has database tables that are specific to Maximo Spatial Asset Management. It also adds industry-specific columns to the Maximo Asset Management database tables. You can run SQL queries to list all of the tables and columns that are unique to Maximo Spatial Asset Management.

Maximo Spatial Asset Management tables and columns

The names of tables and columns that are unique to Maximo Spatial Asset Management begin with PLUSS.

For example, the following tables and columns are unique to Maximo Spatial Asset Management :

PLUSSGISFEATURE.PLUSSFEATURECLASS
PLUSSFEATURECL.PLUSSFEATURECLID

The following tables and columns are examples of Maximo Spatial Asset Management-specific tables and columns in Maximo Asset Management.

WORKORDER.PLUSSISGIS
QUERY.PLUSSLAYERID

To list all of the Maximo Spatial Asset Management tables and columns, you can use the following SQL query:

select objectname, attributename, required, maxtype, length
from maxattribute
where (attributename like 'PLUSS%' or objectname like 'PLUSS%')
order by objectname, attributename;

To list all of the persistent Maximo Spatial Asset Management tables and columns, you can use the following SQL query:

select objectname, attributename, required, maxtype, length
from maxattribute
where (attributename like 'PLUSS%' or objectname like 'PLUSS%')
and persistent = 1
order by objectname, attributename;

Feedback