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

Collecting Batch Data Chapter 3
The BHBinding table contains data pertaining to the binding of the
recipe to a given unit. This table allows you to reproduce how the
recipe was bound to equipment. The userid/machineid columns
contain data only when an operator responds with binding
information. The BHBinding Table provides storage of essential
binding data and allows that data to be linked to a given batch
and/or unit. Each binding record is linked to only one batch.
Column Datatype Description Example
eventtime datetime Time stamp 2002-03-01 12:21:01.000
uniqueid text Unique ID 31
mainevent text Primary event Creation Bind / Bind / UnBind
subevent text Secondary event Prompt Bind / First Available Bind
unitalias text Alias of the unit Alias_REACTOR_1
unitname text Unit name PREMIX_NORTH
area text Area THE_PAINT_COMPANY
userid text User ID mjames1
machineid text Machine ID DEV-MJAMES-01
The BHOperation table contains data pertaining to the execution of
each operation during the batch. This table provides storage of
essential operation data and allows that data to be linked to a given
batch and/or unit (procedure). Each operation record is linked to
only one batch and/or unit (procedure).
Column Datatype Description Example
uniqueid text Unique ID 31
unit procedure text Unit procedure REACTOR_1:1
unitname text Unit name REACTOR_1
operation text Operation MAKE_PAINT:1
recipe text Recipe 31:DEMO_RECIPE\REACTOR_1:1\MAKE_PAINT:1-1
starttime date/time Operation start time 2002-03-01 12:21:06.000
area text Area THE_PAINT_COMPANY
endtime date/time Time operation finished 2002-03-01 12:24:37.000
BHBinding (Unit Binding)
Table
BHOperation Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 41