-
Using a database browser tool, access your Intermediate Repository.
A list of tables available in the repository appears.
-
In the list of tables, navigate to the autojoin_control table, and then, in the data available for the table, locate the site_reference column.
-
For each row in which you want to modify the Site Reference, in the site_reference column, modify the value using the following format: #FIELD_ID#, where FIELD_ID represents the ID of the GE Digital APM field from which you want to populate the site reference value.
For example, if you want the Site Reference for the Equipment and Functional Location records to be assigned with the name of the CMMS System from which the data was extracted, then modify the value in the site_reference column with the following values:
- Where the value #MI_EQUIPOO_SITE_C# occurs, replace the value with #MI_EQUIP000_SAP_SYSTEM_C#.
- Where the value #MI_FNCLOC00_SITE_C# occurs, replace the value with #MI_FNCLOC00_SAP_SYSTEM_C#.
MI_EQUIP000_SAP_SYSTEM_C and the MI_FNCLOC00_SAP_SYSTEM_C are fields in the Equipment and Functional Location records that store the name of the CMMS System.
-
Save the autojoin_control table.
Your changes are saved. When you import records into GE Digital APM from your Maximo system, the site assigned to the records will be based on the Site Reference that you specified in the autojoin_control table.