Database tables and columns

Edit online

Maximo® Health, Safety and Environment has database tables that are specific to Maximo Health, Safety and Environment. It also adds industry-specific columns to the Maximo Manage database tables. You can run SQL queries to list all of the tables and columns that are unique to Maximo Health, Safety and Environment.

Maximo Health, Safety and Environment tables and columns

The names of tables and columns that are unique to Maximo Health, Safety and Environment begin with PLUSG.
For example, following are the tables and columns unique to Maximo Health, Safety and Environment:
  • PLUSGBENEFIT.BENQUANTITY
  • PLUSGDRL.ASSETUSER
  • PLUSGPIMPROVE.ASSETNUM
The following tables and columns are examples of Maximo Health, Safety and Environment-specific tables and columns in Maximo Manage:
  • HAZARD.PLUSGREGULATIONID
  • JOBPLAN.PLUSGPOLICYID
  • JOBTASK.PLUSGRISKASSESSID

To list all of the Maximo Health, Safety and Environment tables and columns, you can use the following SQL query:

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

To list all of the persistent Maximo Health, Safety and Environment tables and columns, you can use the following SQL query:

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