Entity field mapping is determining where information will be stored within CRM. For example, citizen input (location of a service request) or data (location of an active case) plotted on the map. The field mapping is referenced by the ESRI Map Layer. In addition, the mapping can be shared amongst multiple ESRI Map Layer records and records types with similar schema, i.e., Interaction Types.

To setup the ESRI Map Layer setting:

  1. Navigate to Connect 365 -> ESRI Entity Field Mappings. The ESRI Entity Field Mappings form displays.
  2. Click New. The New ESRI Entity Field Mappings form displays.
  3. Enter an intuitive name for the mapping in the Name field.
  4. Select an entity from the right-hand Entity Logical Name lookup field. The left-hand Entity Logical Name text field populates.
  5. Select an entity from the right-hand column field. The left-hand text field populates and is editable.
  6. Input information into the text fields on the left side of the form
  7. Select the destination fields from the look-ups on the right side of the form.

There are 2 field mapping scenarios with typical settings in the table below

Field Name

Typical Values for
Contact Field Mapping

Typical Values for Case Field Mapping

Location Field

abs_formattedaddress.

abs_location1_address1

Latitude Field

address1_latitude.

abs_location1_address1_latitude

Longitude Field

address1_longitude.

abs_location1_address1_longitude

Street Address Field

address1_line1.

abs_location1_address1_line1

City Field

address1_city.

abs_location1_address1_city

State / Province Field

address1_stateorprovince.

abs_location1_address1_stateorprovince

Postal Code Field

address1_postalcode.

abs_location1_address1_postalcode

County Field

address1_county

abs_location1_address1_county

Neighborhood Field

Not used on Contacts

abs_location1_address1_neighbourhood

Country Field

address1_country

abs_location1_address1_country

Polygon Field

Not used on Contacts

abs_polygonsettings