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

Chapter 3 Collecting Batch Data
be important when reconstructing the batch. A comment record is
linked to only one batch record.
Column Datatype Description Example
uniqueid text Unique ID 13
area text Area THE_PAINT_COMPANY
usercomment text
Comment entered by the
user
Buck fell into the paint
machineid text
Machine ID where comment
was entered
DEV-MJAMES-01
userid text User's ID mjames1
eventtime date/time Time stamp 2002-03-01 12:21:01.000
The BHControlSteps table contains a record for every control step
start and stop event in a batch. This table provides storage of
essential control step data and allows that data to be linked to a
given batch. A BHControlSteps record is linked to only one batch
record.
Column Datatype Description Example
uniqueid text Unique ID 13
area text Area THE_PAINT_COMPANY
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PROC
_ORDER:1\PROC_ORDER_CLS:1-1
event text Event BHControlStep START / BHControlStep STOP
stepindex text Step index 1
userid text User's ID mjames1
eventtime date/time Time stamp 2002-03-01 12:21:01.000
reactivation number integer
Number of times an active
eProcedure control step has
been reactivated.
1
BHControlSteps Table
44 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014