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

Collecting Batch Data Chapter 3
regarding operator control of the batch in terms of state commands.
A state command record is linked to only one batch record.
Column Datatype Description Example
uniqueid text Unique ID 13
state text
State commanded (changed
to) HELD / HOLDING / RUNNING / START / STOP / RESTART /
ABORT / CLEAR_FAILURE
machineid text Machine ID DEV-MJAMES-01
userid text User ID mjames1
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PRO
C_ORDER:1\PROC_ORDER_CLS:1-1
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:01.000
The BHStateChange table contains data pertaining to any state
change event at the phase level with the exception of changes to the
IDLE, COMPLETE, STOPPED, or ABORTED state. This table
provides storage of essential data regarding state changes of
equipment phases. A statechange record is linked to only one batch
record.
Column Datatype Description Example
uniqueid text Unique ID 31
state text State changed to
CONNECTING / STARTING / READY All state changes other
than: IDLE / COMPLETE / STOPPED / ABORTED
equipment phase text Equipment module XFR_IN2
recipe text Recipe
31:DEMO_RECIPE\REACTOR_1:1\MAKE_PAINT:1\XFR_IN_2:
1-1
unitname text Unit name REACTOR_1
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:39.000
The BHComment table contains a record for every user comment.
Each record in the table represents one operator comment. This
table provides storage of essential operator/user comments that can
BHStateChange Table
BHComment Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 43