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

Chapter 3 Collecting Batch Data
Column Datatype Description Example
classinstance text Class- or instance-based recipe Class
useridbatch list text
User ID who put batch on the
batch list
mjames1
machineid batchlist text
Machine ID where user put batch
on the batch list
DEV-MJAMES-01
userid execution text User ID who started the batch mjames1
machineid execution text
Machine ID where user started
the batch
DEV-MJAMES-01
reportstatus text Automatic reporting status READY
The BHUnitProcedure table contains data pertaining to the
execution of a given unit procedure. The unitprocedure column will
contain the name of the unit procedure, without the instance
number, that was executed. This table provides storage of essential
unit procedure data and allows data from other tables to be linked to
a given unit procedure.
Column Datatype Description Example
uniqueid text Unique ID 31
unitname text Unit name PREMIX_A
recipe text Recipe 31:DEMO_RECIPE\PREMIX_A:1-1
processcell text Process cell YELLOWPAINT1
area text Area where batch executed THE_PAINT_COMPANY
unit procedure text Unit procedure name PREMIX_A:1
starttime date/time
Time unit procedure was
started
2002-03-01 12:21:06.000
endtime date/time Time unit procedure finished 2002-03-01 12:22:57.000
completion state text
State when unit procedure
finished
COMPLETE
The BHUnit table contains unit data for each batch event record.
The BHUnit and BHUnitProcedure tables duplicate data when the
batch contains only one unit procedure. This table provides storage
BHUnitProcedure Table
BHUnit Table
36 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014