E10 reporting tool

• US 5,740,429 A
• Filed: 07/07/1995
• Issued: 04/14/1998
• Est. Priority Date: 07/07/1995
• Status: Expired due to Fees

• Current Assignee: Advanced Micro Devices, Inc.
• Original Assignee: Advanced Micro Devices, Inc.
• Inventors: Zvonar, John, Simpson, Mike, Wang, Qingsu
• Primary Examiner(s): Lintz, Paul R.
• Application Number:
  US08/499,220
• Time in Patent Office: 1,012 Days
• Field of Search: 395/615, 395/180, 364/480
• US Class Current: 1/1
• CPC Class Codes: G01R 31/287 Procedures; Software aspects
• CPC Class Codes: G06Q 10/06 Resources, workflows, human or project management; Enterprise or organisation planning; Enterprise or organisation modelling
• CPC Class Codes: Y10S 707/99945 Object-oriented database structure processing
• CPC Class Codes: Y10S 707/99948 Application of database or data structure, e.g. distributed, multimedia, or image

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.

Claims

1. A method of automatically generating reports for use in assessing reliability, availability and performance of a plurality of pieces of equipment in a manufacturing environment, the method comprising:

accumulating in a database events occurring in connection with said equipment;

responsive to a data request having user selectable event restriction criteria, said event restriction criteria including a date range and a characteristic indicative of related ones of said pieces of equipment;

mapping each event complying with said event restriction criteria to one of a plurality of predefined equipment states and accumulating time associated with said event in one of a plurality of time bins, each time bin associated with one of said predefined equipment states;

accumulating numbers of equipment failures; and

calculating a plurality of standard metrics using said numbers accumulated and said time accumulated in said time bins; and

responsive to a report request identifying at least one of said calculated metrics and a report format, presenting said at least one of said calculated metrics in said identified report format for pieces of equipment indicated by said event restriction criteria.

2. The method of claim 1 wherein said identified format is a textual format or a graphical format.

3. The method of claim 1 wherein said presenting comprises displaying said at least one of said calculated metrics in said identified report format on a video terminal.

4. The method of claim 1 wherein said presenting comprises generating a hard copy of said at least one of said calculated metrics in said identified report format using a printer or plotter.

5. The method of claim 1, wherein said characteristic indicates a family of related equipment.

6. The method of claim 1, wherein said characteristic indicates a manufacturing site.

7. The method of claim 1, wherein said characteristic indicates a manufacturing area.

8. The method of claim 1, wherein said characteristic indicates a module.

9. The method of claim 1, wherein said mapping is responsive to a user selectable mapping directive.

10. The method of claim 9, wherein said events comprise WorkStream events.

11. The method of claim 10 wherein said mapping directive indicates usage of mappings of status line values to said predefined equipment states.

12. The method of claim 9 wherein said mapping directive indicates usage of user-specified mappings of events to said predefined equipment states.

13. The method of claim 1 wherein said predefined equipment states comprise E10 states.

14. The method of claim 10 wherein said mapping directive indicates usage of mappings of user-specified mappings of events to said predefined equipment states.

15. An apparatus for automatically generating reports for determining reliability, availability and performance of a plurality of pieces of equipment in a manufacturing environment, the apparatus comprising:

a database for accumulating events occurring in connection with said equipment;

a server comprising;

logic responsive to a data request having user selectable event restriction criteria, said event restriction criteria including a date range and a characteristic indicative of related ones of said pieces of equipment, said logic for mapping each event complying with said event restriction criteria to one of a plurality of E10 categories and accumulating time associated with said event in one of a plurality of time bins, each time bin associated with one of said E10 categories;

counters for accumulating numbers of failures; and

logic for calculating a plurality of E10 metrics using said numbers accumulated in said counters and said time accumulated in said time bins; and

a display for presenting user-selected ones of said calculated E10 metrics in a user-specified report format for pieces of equipment indicated by said event restriction criteria.

16. The apparatus of claim 15 wherein said user-specified report format is a textual format or a graphical format.

17. The apparatus of claim 15 further comprising a printer for generating a printout of said user-selected ones of said calculated E10 metrics.

18. The apparatus of claim 15 wherein said user-specified report format comprises a graph, the apparatus further comprising a plotter for generating a hard copy of said graph.

19. The apparatus of claim 15, wherein said mapping is responsive to a user selectable mapping directive.

20. The apparatus of claim 19, wherein said database comprises a manufacturing execution system database and said events comprise WorkStream events.

21. The apparatus of claim 20 wherein said mapping directive indicates usage of mappings of status line values to said E10 categories.

22. The apparatus of claim 19, wherein said mapping directive indicates usage of user-specified mappings of events to said E10 categories.

23. The apparatus of claim 20, wherein said mapping directive indicates usage of mappings of user-specified mappings of events to said E10 categories.

24. Apparatus for enabling the automatic generation of reports for indicating reliability, availability and performance of a plurality of pieces of equipment in a manufacturing environment, the apparatus comprising:

means for storing events occurring in connection with said equipment;

responsive to a data request having user selectable event restriction criteria, said event restriction criteria including a date range and a characteristic indicative of related ones of said pieces of equipment,

means for mapping each event complying with said event restriction criteria to one of a plurality of predefined equipment states;

means for accumulating time associated with said event in one of a plurality of time bins, each time bin associated with one of said predefined equipment states;

means for accumulating numbers of equipment failures; and

means for calculating a plurality of standard metrics using said numbers and said time accumulated in said time bins; and

means responsive to a report request identifying at least one of said calculated metrics and a report format for presenting said at least one of said calculated metrics in said identified report format for pieces of equipment indicated by said event restriction criteria.

25. The apparatus of claim 24 wherein said identified format is a textual format or a graphical format.

26. The apparatus of claim 24 wherein said means for presenting comprises a video terminal.

27. The apparatus of claim 24 wherein said means for presenting comprises a printer or plotter.

28. The apparatus of claim 24, wherein said means for mapping is responsive to a user selectable mapping directive.

29. The apparatus of claim 28 wherein said means for storing comprises a manufacturing execution system database and said events comprise WorkStream events.

30. The apparatus of claim 29, wherein said mapping directive indicates usage of mappings of status line values to said predefined equipment states.

31. The apparatus of claim 28, wherein said mapping directive indicates usage of user-specified mappings of events to said predefined equipment states.

32. The apparatus of claim 29, wherein said mapping directive indicates usage of user-specified mappings of events to said predefined equipment states.

33. The apparatus of claim 24 wherein said predefined equipment states comprise E10 states.