Defining field mappings for attributes in Esri

Define field mappings for attributes stored within GIS and Infor EAM at the layer level. The fields are populated based on the mappings during equipment/feature creation and synchronization.

Note: To define field mappings, you must have OEGGMP permissions.

During equipment/feature creation, the fields are populated based on the mapping relationship, e.g, to create an equipment record based on an existing feature, map data from a GIS attribute to an Infor EAM attribute.

Infor EAM populates the field with the data contained in GIS. You can also define field mappings based on constant values, e.g., enter a GIS value of HYDRANT and map it to the category field in Infor EAM. During equipment creation, the system always populates the category field with HYDRANT.

During synchronization, the system accesses field mappings to ensure corresponding equipment records and features reflect accurate data. If there is a discrepancy in data, the system copies data from one system to the other.

Note: You do not have to define field mappings for a feature’s layer, location X, or location Y. These values are automatically populated in the EAM equivalent fields during creation and synchronization. You may, however, define additional field mappings for these GIS attributes if you want the values of these fields copied into other EAM fields.

You may map more than one GIS attribute to a single Infor EAM attribute. During creation and synchronization, the system concatenates the data into the single field based on the Sequence and Delimiter.

Likewise, you can map an Infor EAM attribute that contains concatenated data into more than one GIS attribute. During creation and synchronization, the data is parsed based on the Sequence. If the system must parse data because one field is mapped to multiple fields, it verifies that the number of fields to which to map data matches the instances of concatenated data in the source field. If it does not, the data is not synchronized. If, however, the source field in the owner system contains a null value, the null value is copied to the multiple fields in the other system, overwriting any data that those fields originally contained.

Identify a Source system, which controls creation, and an Owner system, which controls synchronization. The data is mapped from the Source system during equipment/feature creation. The data is copied from the Owner system during synchronization. See the following example.

You define the following field mapping for the Hydrant layer:

GIS Attribute	Infor EAM Attribute	Source	Owner
ADDRESS	Description	GIS	Infor EAM

During synchronization of the Hydrant layer, the system discovers that a feature with the ADDRESS attribute of 156 Main Street does not have a corresponding equipment record. The system creates an equipment record and automatically populates its description field with 156 Main Street because GIS is the Source.

Later, you update the same equipment record’s description to 256 Main Street in EAM. During the next synchronization of the Hydrant layer, the system updates the GIS feature’s ADDRESS attribute to 256 Main Street because Infor EAM is the Owner of this attribute.

Note: The system only compares attribute data for EAM and GIS if the attribute has a defined field mapping and the Action is set to Copy.

Open ArcMap to an existing map.

Note: The map must contain an integrated layer to access the Map Feature Attributes pop-up.
Click Display Map.
Select the layer for which to define field mappings.
Click Add Mapping.
Specify this information:
Type

Specify the mapping type for the record as Equipment or Work Orders.

Infor EAM Grid

If you selected Work Orders as the value for Type, specify the EAM user defined grid to use for mapping. The fields available for mapping are based upon the EAM grid selected here.

Note: The user defined grid must be Active and have the GIS WO Attribute Mapping Grid check box selected to show in this lookup.
Type and Infor EAM Grid fields only display when an event layer is selected to define field mappings.

Source
Select the system from which data should be mapped during equipment/feature creation. Choose one of the following options:
- GIS
  
  Select to map data from GIS when creating new equipment records based on an existing GIS feature.
- Infor EAM
  
  Select to map data from Infor EAM when creating new features based on an existing Infor EAM equipment record.
- Both
  
  Select to apply this mapping when creating new equipment records/features regardless of which system the object originally resides. The system maps data from Infor EAM when creating new features and maps from ESRI’s GIS when creating new equipment records.
Select the attribute (GIS attribute or Infor EAM attribute) from which data should be mapped or enter the value (GIS value of Infor EAM value) that should be mapped. The attribute or value should coincide with the source system, e.g., if you selected GISas the Source system, select a GIS attribute of GIS value to map.

Note: If you select Layer, Location X, Location Y, or Feature Length as the GIS Attribute from which to map data, the system automatically populates Source as GIS, Action as Copy, and Owner as GIS.

Select the attribute (GIS attribute or Infor EAM attribute) to which data should be mapped.

See the following table to understand the relationship between Mapped From and Mapped To, e.g., if you select a GIS attribute in Step 6, you must enter an Infor EAM attribute in Step 7:

Mapped From	Mapped To
GIS attribute	Infor EAM attribute
GIS Value	Infor EAM attribute
Infor EAM attribute	GIS attribute
Infor EAM value	GIS attribute

Note: For linear features, map the GIS attribute feature length to the Infor EAM attribute equipment length, and then map the GIS attribute for the feature’s unit of measure to the Infor EAM attribute equipment length unit of measure to enable linear equipment capabilities in Infor EAM. You must create your own GIS attribute in Esri for the feature’s unit of measure.

Specify this information:
Action
Choose one of the following options:
- Copy
  
  Select to copy the attribute data from the Source system.
- Move
  
  Select to move the attribute data from the Source system. After the move is completed, the data will only exist in one system.
  Note: If you select Move, the system protects Owner. Defining an Owner implies the data exists in both systems.
Owner

Select the system that controls synchronization when a discrepancy exists between a corresponding feature and equipment record. Data is copied from the Owner system to the field of the other system.

Sequence

Select the sequence number of the mapping. If you select any number other than 1, the system enables Delimiter.
Note: You must select a Sequence number greater than 1 in the event that you map more than one GIS attribute to a single attribute within Infor EAM, e.g., if you map HYDRANT and HYDRANT_ID from GIS to Asset EAM within , the system must know which data to list first in the EAM Asset field.

Delimiter

Specify the delimiter value to use in the event that you map more than one GIS attribute to a single EAM attribute.
Click Submit.