About Site Filtering Configuration via the autojoin_control Table

Site Reference values are managed in the Intermediate Repository, specifically in the autojoin_control table as shown in the following image.

About the Baseline Site Reference Configuration

The baseline configuration of the SAP Adapters uses the SAP System to determine the site to which a record should be assigned. More specifically, the value in the site_reference column in the autojoin_control table is #MI_FNCLOCOO_SAP_SYSTEM_C# for Functional Location records and #MI_EQUIPOO_SAP_SYSTEM_C# for Equipment records.

Additionally, if SAP System value is null or empty on a record in SAP, once transferred into GE Digital APM, it will be assign the site reference defined in the defaut_site_reference column in the autojoin_control table. The default value is *Global*.

If you want to use your SAP System as the site for all records transferred from SAP to APM then no additional configuration is needed. However, if necessary, you can configure different site reference values.

IMPORTANT: A Site Reference record corresponding to your SAP System(s) must exist in GE Digital APM before you can transfer records.

About the autojoin_control Table

You can specify site references using the autojoin_control table. The columns in this table are described in the following table.

Column	Description
AUTOJOIN_ID	Surrogate ID used to uniquely identify a row; i.e., the primary key.
BATCH_NAME	When a load is processed, queries defined in this table are run together in batches. All queries with the same BATCH_NAME are executed together.
TABLE_NAME	The name of the temporary table that will be created for this row. This name will be concatenated by the load UUID.
SQL_EXECUTION_ORDER	Within a batch, the value in this column defines the order in which the SQL statements will be executed. Lower numbers will be executed first.
SQL	The SQL SELECT statement to be executed. The results of this statement will be copied to the temporary table defined by the load UUID and the TABLE_NAME column. Columns defined in the SELECT statement should match exactly the column names in the GE Digital APM family for which data is being loaded.
SITE_REFERENCE	This column specifies the value to use for the corresponding record's Site Reference Key. This can be a direct site reference (i.e., a specific site reference name) or it can contain an indirect site reference (i.e., a field that contains the site reference name to use). See the topic Configure Site Reference Values for details. Note: The baseline value is `#MI_FNCLOCOO_SAP_SYSTEM_C#` for Functional Location records and `#MI_EQUIPOO_SAP_SYSTEM_C#` for Equipment records. This means the SAP System will determine to which site records are assigned.
APM_SITE_REFERENCE_COLUMN	The GE Digital APM column used to store Site Reference values. Unless you have customized the GE Digital APM database, this value should be `MI_SITE_NAME`.
APM_SITE_REFERENCE_FAMILY	The GE Digital APM family to which the site reference will be applied. When the relationship is being built within the records of the same entity, the value is <PRED_FAMILY_ID>. Unless you have customized the GE Digital APM database, you do not need to modify this value.
USE_RELATIONSHIP_LOOKUP	This column specifies whether the row is for an entity or relationship. If this row is populating a relationship, the value should be 1. If not, the value should be 0. This affects the way relationship references are defined in the resulting SQL statements.
DEFAULT_SITE_REFERENCE	If an indirect site reference is specified, this value defines the Site Reference Key that should be used if the value in the specified indirect site reference column is NULL. Enter `Global` to assign the site as global Enter the name of a site to assign records to that site.

What's Next?

Return to the SAP Adapter workflow for the next step in the deployment process.