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

Collecting Batch Data Chapter 3
The BHMaterialEvent table contains a record for every MBR
(material-based recipe) event. This table provides storage of essential
material event data and allows that data to be linked to a given
batch. A material event record is linked to only one batch.
Column Datatype Description Example
eventtime date/time Time stamp 2002-03-01 12:21:17.000
recipe text Recipe 31:DEMO_RECIPE\PREMIX_A:1\MAKE_A:1\CHARGE_B:1-1
description text
event text Event Material Tracking / Material Bound / Material Unbound
value text Equipment module name WP_ADD_SUGAR_M1
eu text Engineering units GALLONS
area text Area THE_PAINT_COMPANY
uniqueid text Unique (create) ID 31
material name text
Common name of the
material
YELLOWPAINT
materialid text
Inventory control system
material ID used to track
material 31
lotname text
Name assigned to a lot of
material
TEST317_BRAND
label text
ID assigned to a distributed
portion of a lot
STANDARDBRANDYELLOW
container text
Container name the material
and lot were distributed to
WAREHOUSE2/PAINT_PALLET1
promiseid text
Unique ID used as a key to
group separate event entries
resulting from a single
material addition
100
signature text
Used for event journal
signatures.
The BHDeviationEvents table contains a record for every parameter
or report deviation event. This table provides storage of essential
parameter and report deviation event data and allows that data to be
BHMaterialEvent Table
BHDeviationEvents Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 45