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

Collecting Batch Data Chapter 3
of essential unit data and allows data from other tables to be linked
to a given unit.
Column Datatype Description Example
uniqueid text Unique ID 31
unitname text Unit name PREMIX_A
processcell text Process cell YELLOWPAINT1
area text Area THE_PAINT_COMPANY
starttime date/time Time unit started 2002-03-01 12:21:06.000
endtime date/time Time unit finished 2002-03-01 12:24:37.000
completion state text State when unit finished COMPLETE
The BHPhase table contains phase execution data. The unitname
column allows unit names to be associated with phases when the
top-level recipe step is an operation or an active/manual step change
was done. This table provides storage of essential phase data and
allows phase data to be linked to a given batch and/or unit.
Column Datatype Description Example
uniqueid text Unique ID 13
batchid text Batch ID BATCH_ID-030102-3
recipe phase text Phase name PROC_ORDER_N
equipment phase text Equipment module name PROC_ORDER_CLS
phase type text Phase type PROC_ORDER
phase instance text Phase instance PROC_ORDER_N1:1-2
unitname text
Unit name where phase
executed
CHAINREACTOR
unit procedure text
Unit procedure that contains
the phase
CR_UP_STEP1:1
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PR
OC_ORDER:1\PROC_ORDER_CLS:1-1
starttime date/time Time phase started 3/1/2002 18:48:00
endtime date/time Time phase finished 3/1/2002 18:58:00
completion state text State when phase ended COMPLETED / STOPPED / ABORTED
area text Area THE_PAINT_COMPANY
operation text Name of operation that CR_OP_STEP1:1
BHPhase Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 37