To assign site references to records using values other than those in the baseline configuration, you must modify the autojoin_control table in the Intermediate Repository.
IMPORTANT: Site Reference records corresponding to the site references that you specify must exist in GE Digital APM before you can transfer records.
Update the value in the site_reference column using the format #FIELD_ID#, where FIELD_ID represents the ID of the field from which you want to populate the site reference value.
For example, if you want the site reference value to be the value in the SAP Maintenance Plant field of the corresponding Equipment or Functional Location.
Where the value #MI_FNCLOC00_SAP_SYSTEM_C# occurs, replace the value with #MI_FNCLOC00_MAINT_PLNT_C#
Where the value #MI_EQUIPOO_SAP_SYSTEM_C# occurs, replace the value with #MI_EQUIP000_MAINT_PLANT_C#
When you import record into GE Digital APM from your SAP System, its Site Reference Key will be the value in the field that you specified. In the example above, the Site Reference Key will be the SAP Maintenance Plant of the corresponding Equipment or Functional Location.
Where the value #MI_FNCLOC00_SAP_SYSTEM_C# occurs, replace the value with the Site name as defined in a GE Digital APM Site Reference record.
Where the value #MI_EQUIPOO_SAP_SYSTEM_C# occurs, replace the value with the Site name as defined in a GE Digital APM Site Reference record.
When you import records into GE Digital APM from your SAP System, its Site Reference Key will be the name of the Site as defined in the APM Site Reference record.
In this example, the database browser tool used in this example is pgAdmin4, the IR database name is SAP_UDLP_EAMClient. You can use the database browser of your choice.
On your APM Connect server, open pgAdmin4, your database browser tool.
PgAdmin4 is open displaying your available servers.
Navigate the server tree to the appropriate IR database, access your tables.
In this example, the path is Servers(2)\roaperflabvm3\Databases\SAP_UDLP_EAMClient\Schemas(1)\public\Tables (81). The list of tables in your IR database are visible.
Locate the table autojoin_control, right click, and then select the View Data drop-down.
Select View All Rows.
The Query -1 tab is populated with the autojoin table.
In each row, in the site_reference column, enter #MI_EQUIP000_CST_CNR_C#
Tip: This example assumes that the existing values in the site_reference column correspond to values in the MI_EQUIP000 and MI_FNCLOC00 families. If they do not, you must also update the apm_site_reference_family column to the corresponding family.
The value in the MI_EQUIP000_CST_CNR_C field will be used to populate the Site Reference Key in corresponding records.
