Queries Folder

The folder \\Public\Meridium\Modules\PLA\Queries contains the following queries:

Query Name	Behavior and Usage
AllProductionEvents	Returns the Entity ID of all Production Event records. The query is used to display list of Production Events in the Production Event section of the PLA Overview page. If desired, you can modify the query to further limit the Production Event records that are displayed in the list.
EventList	Returns the Entity ID of all Production Event records whose date range includes the date in the Period field in a given Production Data record. This query is used to display values in the Production Event list in the Production Data workspace, when you account for the losses. If desired, you can modify the query to further limit the Production Event records that are displayed in the list.
ImpactCodeList	Returns the Entity ID of all Impact Code records. This query is used to display values in the Impact Code list in the Production Data workspace. If desired, you can modify the query to further limit the Impact Code records that are displayed in the list.
OEECodeList	Returns the Entity ID of all OEE Code records. This query is used to display values in the Codes workspace on the PLA Administrator page. If desired, you can modify the query to further limit the OEE Code records that are displayed in the list.
OEECodeListProdLoss	Returns the Entity ID of all OEE Code records that contain the value False in the Is Inactive field. This query is used to display values in the Select OEE Code window in the Production Data workspace, when you account for the losses. If desired, you can modify the query to further limit the OEE Code records that are displayed in the window.