After providing a prompt for an Entity Key, the query Get SAP ID for Equipment returns the record with the provided Entity Key. In the baseline GE Digital APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, GE Digital APM runs this query automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.
When GE Digital APM runs the query, GE Digital APM provides the prompt with the Entity Key of the predecessor record that is linked to the underlying Asset Strategy record:
If the Entity Key identifies a record that belongs to the query's source family, the Equipment field in the Notification and Maintenance Item records will be populated automatically with the ID of that record. GE Digital APM uses the value that is returned by the query as the ID. In the baseline query, the query returns the Equipment ID.
If the Entity Key does not identify a record that belongs to the query's source family, GE Digital APM runs the query Get SAP ID for Functional Location. If the Entity Key identifies a record that belongs to that query source's family (which is the Functional Location family if you have not modified the query), the Functional Location field in the Notification and Maintenance Item records will be populated automatically with the ID of that record.
For example, suppose an Asset Strategy record is linked to the Equipment record HX-112. If you build a Notification record from an Action that belongs to this Asset Strategy, GE Digital APM will:
You will not need to modify the baseline query if your Asset Strategy records are linked to records in the baseline Equipment or Functional Location family.
Copyright © 2018 General Electric Company. All rights reserved.