Asset mapping

Edit online

You use the asset mapping to send asset data from Maximo® Health, Safety and Environment to the external system.

Table 1. Asset mapping
Maximo Oil & Gas table.column MIMOSA attribute segmentTYPE MIMOSA interface reference
ASSET.ASSETNUM user_tag_ident
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd
ASSET.DESCRIPTION name
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd
SITE.PLUSGOPENOMUID (look up from ASSET.SITE) asset_org_site
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd
ASSET.PLUSGOPENOMUID (look up from ASSET.LOCATION) segment_site
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd
ASSET.PLUSGOPENOMUID (look up from ASSET.ASSETNUM) asset_id
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd
LOCATIONS.STATUS

lcinfo

attr_name: status

value:

1: operating

2: not ready

3: decommissioned

rstat_type_code

value:

0: not ready or decommissioned

1: operating
  • V3-2-5043-01UpdateAs.xsd
  • V3-2-5042-01UpdateSg.xsd

The following attributes are sent with values set to undefined.

Table 2. Attributes set to undefined
Attribute Undefined value
as_db_id 0
as_type_code 0