The autojoin_control Table

The autojoin_control table is used to customize the data that is loaded into GE Digital APM. Each row in the table contains an SQL statement that defines the fields that must be imported to GE Digital APM. You can also specify the value to be used as Site Reference using the autojoin_control table. The following columns are available in the autojoin_control table:

Column	Description
AUTOJOIN_ID	An integer value used to identify each row in the table.
BATCH_NAME	The name of the batch to which the query belongs. When a job for loading data is processed, queries with the same BATCH_NAME are run together.
TABLE_NAME	The name specified in this column along with the unique ID for the job is used to define the name of the temporary table that is created to store the data extracted using the SQL statement specified in the row.
SQL_EXECUTION_ORDER	The sequence in which the SQL statements will be run when they are processed in batches. Within a batch, SQL statements for rows with lower numbers in this column will be run first.
SQL	An SQL SELECT statement that defines the data that will be loaded to GE Digital APM. The results of this statement are copied to the temporary table, whose name is defined by the unique ID of the job and the value in the TABLE_NAME column. The columns defined in the SELECT statement must match the column names in the GE Digital APM family to which the data is being loaded.
SITE_REFERENCE	The value used to determine the Site assigned to records generated for the corresponding SQL statement. You can configure this value to modify the Site Reference. The default value is #MI_FNCLOCOO_SITE_C# for Functional Location records and #MI_EQUIPOO_SITE_C# for Equipment records, indicating that the site assigned to the records is determined by the value in the SITEID field in the Maximo system.
APM_SITE_REFERENCE_COLUMN	The GE Digital APM field that is used to store the names of the Site. 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	Specifies whether the row is for an entity or a relationship family. If the row is used to populate a relationship family, the value is 1. Otherwise, the value is 0. This affects the way relationship references are defined in the resulting SQL statements.
DEFAULT_SITE_REFERENCE	A value that indicates the Site Reference that should be used in one of the following scenarios: The value in the site_reference column is null. -or- The value in the field specified in the site_reference column for indirect site reference is null. If you want to assign the site as global, in this field, you must enter Global. If you want to assign a site to the records, you must enter the name of a site.