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

Chapter 3 Collecting Batch Data
Column Datatype Description Example
completion state text
State when operation
finished
COMPLETE / STOPPED / ABORTED
The BHFailure table contains data pertaining to any setting of an
equipment phase failure during batch execution. The
BHFailureClear Table contains data describing the clearing of the
failure.
The unitname is included because multiple units can share an
equipment module. The machineID and userID of the operator that
cleared the failure can be obtained by querying the
BHStateCommand table for a Clear Failures command with a
timestamp between (inclusive) the creation of the failure and
clearing of the failure.
Identity columns are used to match failure and failureclear records.
These tables provide storage of essential failure data to allow you to
determine if failures of equipment modules (phases) occurred during
batch execution and how much time elapsed before the failures were
cleared.
Each failure record is linked to only one batch record.
Column Datatype Description Example
failureid int Numerical ID 1
uniqueid text Unique ID 13
area text Area THE_PAINT_COMPANY
recipe text Recipe 31:DEMO_RECIPE\REACTOR_1:1\MAKE_PAINT:1-1
eventtime date/time Time stamp 2002-03-01 12:21:01.000
The BHStateCommand table contains data pertaining to any state
command, excluding the batch START command (this command is
accounted for as the batch start time starttimeexecution in the
BHBatch Table). This table provides storage of essential data
BHFailure and BHFailureClear
Tables
BHFailure table BHFailureClear table
BHStateCommand Table
42 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014