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

Chapter 3 Collecting Batch Data
Column Datatype Description Example
contains the phase
The BHParameter table contains data pertaining to a given phase or
report parameter. This table provides storage of essential parameter
data and allows parameter data to be linked to a given batch and/or
phase.
Column Datatype Description Example
uniqueid text Unique ID 31
paramname text Parameter name AMOUNT_TO_CHARGE
paramvalue text Data value 55
paramtype text Parameter type Recipe Value
recipe text Recipe 31:DEMO_RECIPE\PREMIX_A:1\MAKE_A:1\CHARGE_B:1-1
eu text Engineering units GALLONS
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:17.000
userid text User ID mjames1
The BHParameterChange table contains data pertaining to any
parameter change made during batch execution. Each parameter
change record is linked to only one phase and/or unit. This table
provides storage of essential parameter change data and allows
parameter change data to be linked to a given batch and/or phase.
Column Datatype Description Example
uniqueid text Unique ID 13
paramname text Parameter name AMOUNT_TO_TRANSFER
oldvalue text Previous value 3500
newvalue text New value 3501
machineid text
Machine ID where user
changed the parameter
DEV-MJAMES-01
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PR
OC_ORDER:1\PROC_ORDER_CLS:1-1
userid text User ID of person who mjames1
BHParameter Table
BHParameterChange Table
38 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014