Rockwell Automation FactoryTalk Metrics User Guide - Manual (Page 261)

Appendix A
Report Data Sources
FactoryTalk Metrics exposes the following important report data
sources from which report designers can create charts and tables:
• Workcell history (page 261).
• Event history (page 263).
• Machine state data (page 264).
In order to create charts and tables effectively, you need to
understand first the types of data included in these report data
sources.
The FactoryTalk Metrics Workcell History report data source is
based on the OEEQWorkcell view in the RSBizWare database.
This report data source contains the historical performance data for
activity areas, including OEE performance and the data that is used
to calculate OEE performance. Each record contains summarized
information for a single enabled activity area collected within a
specified period of time. Each record includes:
• The start and end times for the record.
• The number of parts built (good parts, scrap parts, and total
parts).
• The amount of time the activity area was available, scheduled
available, and running.
• The number of the part being built and the ideal cycle time for
that part number.
• The number of parts that could have been built under ideal
conditions.
Workcell History
Rockwell Automation Publication PLTMT-UM001M-EN-P-June 2014 261