Bhbinding (unit binding) table, Bhoperation table, Bhbinding (unit binding) table bhoperation table – Rockwell Automation FactoryTalk Historian Classic for Batch User Guide User 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