Searching for Production Events

To access this dialog box: From the Plant Applications Excel Add-in, click the Plant Applications menu, point to Event Summary and click Search Production Events.

You can find specific information about each production event in Plant Applications. These production events are associated with a production unit. When you search for production events, you must specify a start time. Additionally, the Plant Applications Add-in provides you with multiple filters that you can use to limit or refine your search results.

To search for production events

  1. From the Plant Applications menu, point to Event Summary and click Search Production Events.

  2. The Plant Applications Event Search dialog box opens.

  3. optional: Under Server, click the drop-down arrow to select a different server. If you need to add a new server or connect to the selected server, click the Browse  button.

  4. Under Production Line, click the drop-down arrow to select a production line, then click the second drop-down arrow to select a production unit.

  5. Under Time Range, enter a start and end time. For more information on entering start and end dates, please see Selecting Start and End Times.

  6. If you want to filter on a specific product, under Product Filter (or Product Code), select a Product Code or Product ID on your worksheet. If you filter on a product, the options original product and applied product will be available.

Whether you are required to select Product Code or Product ID is determined by the site parameter, ProdCodeIsNum. For more information, see ProdCodeIsNum Site Parameter.

If you filter on a product, the options Original Product and Applied Product will be available. Additionally, "Original Product" and "Applied Product" will be added to the Display list.

  1. If the choice is available, under Product Filter As, select:

  2. Original Product to filter on the original product.

  3. Applied Product to filter on the applied product. The applied product is the final product that a particular production event is assigned. This is used to indicate a different product than the production event was originally built as. The starting or initial product is the original product.

  1. Select Filter Out Non Productive Time to exclude non-productive time from the search results. For more information on non-productive time, see the topic Non-Productive Time.

  2. For information about Force ID, see ProdCodeIsNum Site Parameter.

  3. Under Filter By, do one or more of the following:

  4. Under Plant Order Number, enter the plant order number.

  5. Under Customer Code, enter the customer code.

  6. Under Shipment Number, enter the shipment number

  7. Under Primary Event Number, enter the primary event number.

Keep in mind that the results you get might not be the expected results simply because of the filters you have chosen. If you are not sure of your results, it’s best to use fewer filters.

  1. Under Crew Schedule Filter, do one or more of the following:

  2. Under Crew Description, click the drop-down arrow to select a crew.

  3. Under Shift Description, click the drop-down arrow to select a shift.

Notice that if you select a crew description or shift description, "Crew Description" and "Shift Description" are added to the Display list.

  1. Under Event Status Filter, do one of the following:

  2. If you do not want to filter on event status (e.g., Consumed, In Progress, Hold, etc.), select the Do Not Filter By Event Status option.

  3. If you want to filter on event status, select the Filter By Specific Event Status In List Below option. Then, in the Status To Exclude list, select one or more of the event statuses you want to include, then click the Move Selected button to move the event statuses to the Status To Include list.

  1. Under Display, select one or more of the attributes you want to include on your worksheet.

  2. Under Output Range, select the range of cells where you want to input your production event attributes. For information on how to select cells for output, please see Selecting Cells for Output.

  3. Under Output Sort, do one of the following:

  4. Select the Ascending option to sort the statistics starting with the most recent Run Start Time (i.e., from oldest to newest).

  5. Select the Descending option to sort the statistics starting with the earliest Run Start Time (i.e., from newest to oldest).

  1. If select only one cell, you can click either the Columns or Rows option. For more information, please see Output Orientation.

If you select more than one output cell, these options are not available.

  1. Click the OK button.