Field mapping

The flow generates a CSV map that displays the values that the IBM® Maximo® Real Estate and Facilities fields are mapped to.

Table 1. Field-mapping buildings
CSV headers Maximo Real Estate and Facilities fields Comments
CITY spi:triCityTX  
COUNTRY spi:triCountryTX  
DESCRIPTION spi:triDescriptionTX  
GROUPNAME1 spi:cstEnviziParentOneTX The value for this field is available only after Location Hierarchy mapping for Envizi groups is completed in Maximo Real Estate and Facilities.
GROUPNAME2 spi:cstEnviziParentTwoTX The value for this field is available only after Location Hierarchy mapping for Envizi groups is completed in Maximo Real Estate and Facilities.
GROUPNAME3 spi:cstEnviziParentThreeTX Value for this field is available only after Location Hierarchy mapping for Envizi groups is completed in Maximo Real Estate and Facilities.
LATITUDEY spi:triGisLatitudeNU  
LOCATION spi:triNameTX  
LOCATIONCLOSEDATE spi:triActiveEndDA  
LOCATIONID spi:triIdTX  
LONGITUDEX spi:triGisLongitudeNU  
POSTALCODE spi:triZipPostalTX  
STATEPROVINCE spi:triStateProvTX  
STREETADDRESS spi:triAddressTX  
Table 2. Field mapping accounts
CSV headers Maximo Real Estate and Facilities fields
ACCOUNT spi:triIdTX + (_HEADCOUNT or _FLOORAREA)
DATATYPE HEADCOUNT or FLOORAREA
LOCATION spi:triNameTX
LOCATIONID spi:triIdTX
MEASUREUNITID spi:triAreaUO
METERNAME HEADCOUNT or FLOORAREA
READING spi:triHeadcountNU or spi:triTotalAreaOccupiedCalcNU
READINGDATE spi:triModifiedSY