Rockwell Automation FactoryTalk Historian Classic for Batch User Guide - Manual (Page 46)

Chapter 3 Collecting Batch Data
linked to a given batch. Only one deviation is created per parameter
or report, for the most severe limit violation. For example, if a
parameter has a verification method of HH/LL and the value
exceeds both the high and high-high limits, only one deviation event,
will be created for the high-high limit.
Column Datatype Description Example
uniqueid text Unique (create) ID 31
area text Area THE_PAINT_COMPANY
starttime date/time Time stamp 2002-03-01 12:21:17.000
batchid text Batch ID BATCH_ID-030102-3
EU text Engineering units Gallons
unit text Unit name REACTOR_1
phase text equipment module name PHASE11
event text
Batch event from the event
journal: Recipe Parameter
Deviation or Report
Parameter Deviation
Recipe Parameter Deviation
descript text
Name of the parameter or
report that has exceeded
limits.
REPORT_10
esignatureid integer
Unique electronic signature
number.
1
deviatedvalue text
Actual value of the
parameter deviation.
101
targetvalue text
Value of the target
parameter. The target
parameter is the recipe
parameter used in
calculating the limit when
the calculation method is
Percent or Relative.
100
limitviolated text
Level of limit that was
violated: High/Low,
High-High/Low-Low, or
High-High-High/Low-Low-L
ow.
High/Low
limitvalue text
Value of the limit that was
violated.
10
46 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014