Queries Folder

The queries listed in the following table are provided in the Catalog folder \\Public\Meridium\Modules\Asset Strategy Management\Implementation\Queries. In this table, the values listed in the Query column refer to the query names. The baseline captions are the same as the names.

IMPORTANT: With the exception of the Get SAP ID for Equipment and Get SAP ID for Functional Location queries, you should not modify these queries in any way or move them to another Catalog folder. Also, while modifying the design of the Get SAP ID for Equipment and Get SAP ID for Functional Location queries is allowed, if you are using the baseline Equipment and Functional Location families, it is not necessary.

Query	Behavior and Usage
Asset Is Equipment	This query is not used by ASI.
Get Equipment for SAP ID	Returns the Equipment record that contains the ID corresponding to the value supplied for the SAP Equipment ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline Meridium Enterprise APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, the Meridium Enterprise APM system runs this query automatically to determine which Equipment record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the Meridium Enterprise APM system runs this query, it performs several actions automatically: It passes the Equipment ID of the imported SAP item to the SAP Equipment ID prompt in the query. It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query. If the query returns a record using the provided values, the Meridium Enterprise APM system links that record to the new Asset Strategy record. If the query does not return a record using that value, the Meridium Enterprise APM system runs the Get Functional Location for SAP ID query. Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Equipment for SAP ID query to include a family other than the baseline Equipment family.
Get Functional Location for SAP ID	Returns the Functional Location record that contains the ID corresponding to the value supplied for the SAP Functional Location ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline Meridium Enterprise APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, the Meridium Enterprise APM system runs this query automatically to determine which Functional Location record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the Meridium Enterprise APM system runs this query, it performs several actions automatically: It passes the Functional Location of the imported SAP item to the SAP Functional Location ID prompt in the query. It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query. If the query returns a record using the provided values, the Meridium Enterprise APM system links that record to the new Asset Strategy record. Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Functional Location for SAP ID query to include a family other than the baseline Functional Location family.
Get SAP ID for Equipment	After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline Meridium Enterprise APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, Meridium Enterprise 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.
Get SAP ID for Functional Location	After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline Meridium Enterprise APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, it is run automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.
Locate Packages for Navigation	Returns all existing the Implementation Packages that contain one or more of the Asset Strategies that belong to the current Implementation Package. This query is not meant to be run on its own. Instead, it is run automatically when you select the Navigate link on the Packaging page.
Locate Strategies to Package	Returns a list of Active Asset Strategy records that are not linked to an Implementation Package record. This results of this query are displayed on the Select Asset Strategy to Add to Package window, which you can access via the Implementation Package Update page. You can add criteria to this query, but you should not remove any criteria from the query.
Locate_Packages	After providing a prompt for State and Implementation Role, returns a list of all Implementation Package records that meet the specified criteria. This query is run when you select the Packaging link on the Asset Strategy Implementation Overview Page.
Locate_Packages_for_Execution	This query is not used by ASI.
Locate_Packages_for_System_Strategy	Returns a list of all Implementation Package records that are linked to the Asset Strategy record to which a given System Strategy record is linked. This query is run when you select the Strategy Implementation link on the Navigation menu when you are viewing a System Strategy.
Locate_Packages_for_Unit_Strategy	Returns a list of all Implementation Package records that are linked to the Asset Strategy record that is linked to the System Strategy record to which a given Unit Strategy record is linked. This query is run when you select the Strategy Implementation link on the Navigation menu when you are viewing a Unit Strategy.
Move to Existing Secondary Package	After providing a prompt for an SAP system, returns all existing Implementation Packages associated with the selected SAP system, except for the current Implementation Package. This query is not meant to be run on its own. Instead, it is run automatically when you send an Action to a new or existing Implementation Package.

Query

Behavior and Usage

Asset Is Equipment

This query is not used by ASI.

Get Equipment for SAP ID

Returns the Equipment record that contains the ID corresponding to the value supplied for the SAP Equipment ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline Meridium Enterprise APM database, the query returns records in the Equipment family.

This query is not meant to be run on its own. Instead, the Meridium Enterprise APM system runs this query automatically to determine which Equipment record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the Meridium Enterprise APM system runs this query, it performs several actions automatically:

It passes the Equipment ID of the imported SAP item to the SAP Equipment ID prompt in the query.
It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query.

If the query returns a record using the provided values, the Meridium Enterprise APM system links that record to the new Asset Strategy record. If the query does not return a record using that value, the Meridium Enterprise APM system runs the Get Functional Location for SAP ID query.

Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Equipment for SAP ID query to include a family other than the baseline Equipment family.

Get Functional Location for SAP ID

Returns the Functional Location record that contains the ID corresponding to the value supplied for the SAP Functional Location ID prompt and is linked to the SAP System record identified by the value supplied for the SAP System prompt. In the baseline Meridium Enterprise APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, the Meridium Enterprise APM system runs this query automatically to determine which Functional Location record to link to the new Asset Strategy record when you create an Asset Strategy by importing Maintenance Items, Notifications, or Operations from SAP. When the Meridium Enterprise APM system runs this query, it performs several actions automatically:

It passes the Functional Location of the imported SAP item to the SAP Functional Location ID prompt in the query.
It locates the Site Reference record that you selected on the Select SAP Object(s) screen of the Asset Strategy Builder and locates the SAP System record that is linked to that Site Reference record. It then passes the value in the Name field in that SAP System record to the SAP System prompt in the query.

If the query returns a record using the provided values, the Meridium Enterprise APM system links that record to the new Asset Strategy record.

Note: Because the documentation for importing SAP items to create Asset Strategies assumes that you began the workflow by importing Equipment and Functional Location records using the SAP Interfaces, this documentation assumes that you will link your Asset Strategy records to either an Equipment or Functional Location record. You will not, therefore, need to modify the baseline Get Functional Location for SAP ID query to include a family other than the baseline Functional Location family.

Get SAP ID for Equipment

After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline Meridium Enterprise APM database, the query returns records in the Equipment family. This query is not meant to be run on its own. Instead, Meridium Enterprise 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.

Get SAP ID for Functional Location

After providing a prompt for an Entity Key, returns the record with the provided Entity Key. In the baseline Meridium Enterprise APM database, the query returns records in the Functional Location family. This query is not meant to be run on its own. Instead, it is run automatically to determine whether to populate the Equipment or Functional Location field when you build Notification or Maintenance Item records from Actions.

Locate Packages for Navigation

Returns all existing the Implementation Packages that contain one or more of the Asset Strategies that belong to the current Implementation Package. This query is not meant to be run on its own. Instead, it is run automatically when you select the Navigate link on the Packaging page.

Locate Strategies to Package

Returns a list of Active Asset Strategy records that are not linked to an Implementation Package record. This results of this query are displayed on the Select Asset Strategy to Add to Package window, which you can access via the Implementation Package Update page. You can add criteria to this query, but you should not remove any criteria from the query.

Locate_Packages

After providing a prompt for State and Implementation Role, returns a list of all Implementation Package records that meet the specified criteria. This query is run when you select the Packaging link on the Asset Strategy Implementation Overview Page.

Locate_Packages_for_Execution

This query is not used by ASI.

Locate_Packages_for_System_Strategy

Returns a list of all Implementation Package records that are linked to the Asset Strategy record to which a given System Strategy record is linked. This query is run when you select the Strategy Implementation link on the Navigation menu when you are viewing a System Strategy.

Locate_Packages_for_Unit_Strategy

Returns a list of all Implementation Package records that are linked to the Asset Strategy record that is linked to the System Strategy record to which a given Unit Strategy record is linked. This query is run when you select the Strategy Implementation link on the Navigation menu when you are viewing a Unit Strategy.

Move to Existing Secondary Package

After providing a prompt for an SAP system, returns all existing Implementation Packages associated with the selected SAP system, except for the current Implementation Package. This query is not meant to be run on its own. Instead, it is run automatically when you send an Action to a new or existing Implementation Package.