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

Collecting Batch Data Chapter 3
Column Datatype Description Example
limitcalculation text
Type of equation used to
calculate the limit: Absolute,
Percent, or Relative.
Absolute
Two temporary tables are required to allow data from separate event
journal records to be combined into one record. Neither of these
tables contains permanent data and should not be referenced in any
report.
The first temporary table, BHTempBatch, allows a single batch
record to be built and inserted into the batch table. A tempbatch
record is created and updated as new data becomes available. The
Tempbatch record is inserted into the BHBatch Table when the last
expected piece of starting data (the record containing the Beginning
Of Batch event) is received. The Tempbatch and Batch tables have
exactly the same schema.
The second temporary table, BHTempBatchEnd, appends the time
the batch ended to the appropriate batch record. When a
termination event is found whose recipe matches a record in this
table, that event is assumed to be the completion of the batch
denoted by the recipe, uniqueid, and area.
Column Datatype Description Example
uniqueid text Unique (create) ID 13
area text Area where batch executed THE_PAINT_COMPANY
recipe text Recipe 13:Y_300_YELLOW_PAINT
Data in the BHTempBatch and BHTempBatchEnd tables is
normally removed automatically after the data is transferred into the
permanent BHBatch table. In the event that data is not
automatically removed from the BHTempBatch and
BHTempBatchEnd tables, the database administrator can manually
BHTemporary Tables
BHTempBatch table BHTempBatchEnd table
Manually Clear BHTemporary
Tables
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 47