About Site Filtering Configuration in the Context File

Note: This site filtering configuration applies only to SAP PI deployment. If you are deploying the SAP Adapters, site filtering is handled by modifying the autojoin_control table.

IMPORTANT:

Site Reference records must exist in your GE Digital APM system, before you can use the EAM Adapters to populate the Site Reference Key. Additionally, the site entered into the context file must match the exact value in the corresponding Site Reference record.
The user who is running the EAM Adapters jobs must be assigned, in GE Digital APM, to the site to which the records being loaded will be assigned. Additionally, the credentials for that user must be entered into the context file. If the user is not a member of the appropriate site, then the data load will fail, and an error message will appear.

The EAM Adapters are used to populate the Site Reference on Equipment, Functional Location, and Work History records in GE Digital APM. The adapters populate the MI_SITE_KEY system field with the ENTY_KEY system field associated with the Site Reference value to be populated. On asset records, the Site Reference is stored in the MI_SITE_KEY field, a system field in GE Digital APM. The EAM Adapters use the Site Name (MI_SITE_NAME) to translate the value to the corresponding Site Reference Key and populate the MI_SITE_KEY field; therefore, you do not need to know the key to be able to populate the site reference. This functionality is important because this value can change from one database to another.

When records are loaded using the Equipment, Function Location, and Work History Adapters, the system will assign the Site Reference Key (MI_SITE_KEY) to the assets using the value designated in the applicable context file (i.e., the file for SAP or for Maximo). The following parameters are used to designate the Site Reference Key value:

SITE_REFERENCE_EQUIP: Used to populate the Site Reference Key on Equipment records being loaded into GE Digital APM. The Site Reference Key determines the Site to which the Equipment record(s) will be assigned.
SITE_REFERENCE_FLOC: Used to populate the Site Reference Key on Functional Location records loaded into GE Digital APM. The Site Reference Key determines Site to which the Functional Location record(s) will be assigned.

Note: The values entered into these parameters should match, because Equipment records are linked to Functional Location records. Therefore, they should have the same site.

These parameters accept three types of values to determine the site reference value.

Site Name: You can enter the site name directly as defined on the preexisting Site Reference record (i.e., Site 100).
Column Name: You can enter a column value between two pound symbols (#) to set the site reference. The following columns can be used:
- SAP columns:
  - MI_EQUIP000_SAP_SYSTEM_C
  - MI_EQUIP000_MAINT_PLANT_C
  - MI_FNCLOC00_MAINT_PLNT_C
  - MI_FNCLOC00_SAP_SYSTEM_C
For example, if you wanted to use your SAP maintenance plant field as your GE Digital APM site reference, you would enter #MI_EQUIP000_MAINT_PLANT_C#.

After the adapters are run, records designated to be transferred into GE Digital APM will be assigned to the site defined in the Site Reference parameters.

In addition to Equipment and Functional Location records loaded by the EAM adapters, Work History records and shell records are impacted by site reference functionality as detailed in the following table.

Action	Result
If the Work History Adapter is run after the Equipment or Functional Location Adapter...	The Work History records will inherit the Site Reference Key of their parent Functional Location or Equipment records.
If the Work History Adapter is run before the Equipment or Functional Location Adapter...	The Site Reference Key will be inherited from the shell record that will be created for Equipment and Functional Location.
If a shell record is created while loading data...	The Site Reference Key will be the value set in the context parameters.

Note: If you are using multiple SAP Systems, you must set up a context file for each system, and then designate the appropriate site(s) for each EAM Systems.