E10 reporting tool

Abstract

Method and system for automatically and accurately generating E10 reports based on a user-selected set of parameters, including date range, equipment and other parameters, are disclosed. In a preferred embodiment, the system of the present invention performs three primary functions; namely, a mapping function, a data extraction function and a reporting application function. The mapping function enables users to map WorkStream events into E10 defined states outside of the WorkStream database. The reporting application function provides several major functional capabilities, particularly, enabling a user to formulate restriction information, or 'E10 data requests,' for data extraction and reporting purposes. Each E10 data request identifies, as a function of facility (or manufacturing area), module, family and/or equipment, the equipment list for which data is to be accumulated, as well as a time period for reporting and duration type to report on. In addition, the reporting application function enables the user to display all E10 calculations for each piece of equipment in the extracted data set and to generate and display via a video terminal, printer and/or plotter, standard and custom graphic reports from the extracted E10 data calculations. The data extraction function provides the necessary data extraction capabilities and E10 data request management by managing and executing the requests submitted by users and purging old requests from the queue. In one aspect of the invention, the system comprises a user interface for facilitating the user's formulation of requests, mapping of WorkStream events to E10 states and substates, and viewing and/or printing reports in textual and graphical formats.