Rockwell Automation FactoryTalk Report Expert User Guide - Manual (Page 51)

Understanding Report Templates Chapter 5
Rockwell Automation Publication RPTEXP-UM001H-EN-P-June 2014 51
NOTE
If the data returned exceeds the maximum number of rows allowed in
the resulting report, the Max row limit reached message appears in
red above the grid. The maximum row number can be changed in the
RptSettings table. For details, see "Modifying the RptSetting Table (page
143)".
The drillthrough hierarchy: none.
Calculations used by Report Expert to obtain values in the resulting
report:
• Duration = End Time - Start Time
The Event History String and Value report templates display
row-level data from the OEEEvent table. The difference between
the reports is that the
Start Value, End Value and Reporting Value
columns are displayed as either strings or values in the Event History
String and Event History Value report templates respectively.
Query: EventDetailExt.
The fields of the report template grid:
Item Description
Line
Workcell A level of the plant model (which is constructed by enterprise, site,
area, line, and then work cell).
Shift Start Time The start time of the shift during which the data was collected.
Event Occurrence The identifier of a single event occurrence.
Event Category The category of the event.
Event Name The name of the event.
Event Reason The string value representing the event reason.
Start Time The date and time that the event or state started.
End Time The date and time that the event or state ended.
Duration The length of the event, calculated as the difference between start
time and end time and displayed using the format
HH:MM:SS.mmm. The calculation for this field is:
Duration = End Time - Start Time.
Event History String/Value