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

Collecting Batch Data Chapter 3
NOTE
Be sure to specify the .html extension, change the Save as type
to All Files (*.*), and change the File Format to ANSI.
6. In Windows Explorer, double-click the .html file to view the
actual HTML in your browser.
The BHBatch table contains data pertaining to execution of a batch
recipe, including the BatchID, the start and end time of the batch,
product code and description, and recipe information. You can
search the database for batches using the uniqueID and area as a
primary key.
Column Datatype Description Example
uniqueid text Unique (create) ID 31
batchid text Batch ID BATCH_ID-030102-3
productcode text Product code 123-ABC
product description text Product description Yellow Paint
starttime batchlist date/time
Time batch was placed on the
batch list
2002-03-01 12:21:01.000
endtime batchlist date/time
Time batch was removed from
the batch list
2002-03-01 12:25:06.000
starttime execution date/time Time batch was started 2002-03-01 12:21:06.000
endtime execution date/time Time batch was completed 2002-03-01 12:24:37.000
completion state text State of batch at completion COMPLETE
area text Area where batch executed. THE_PAINT_COMPANY
eventfile name text Event file name
\\DEV-MJAMES-01\BATCHCTL\YELLOWPAINT\JOURNA
LS\31.evt
author text Author of the recipe Kevin A. York
recipefile name text Recipe file name
\\DEV-MJAMES-01\BATCHCTL\YELLOWPAINT\RECIPES
\DEMO_RECIPE.BPC
version number text Recipe version 2.0
versiondate text Date recipe was last updated 1/14/2002 11:25:03 AM
areamodelfilename text Area model file name
\\DEV-MJAMES-01\BATCHCTL\YELLOWPAINT\RECIPES
\THE_PAINT_COMPANY.CFG
areamodel time text
Timestamp of last area model
update
9/8/2001 9:01:50 PM
verification time text Verification timestamp 1/14/2002 11:25:00 AM
recipetype text Recipe type BP
BHBatch Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 35