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

Collecting Batch Data Chapter 3
• BHModeChange
• BHModeCommand • BHPromptResponse • RSDataPointSample
For instructions on removing the sample data, see Removing Sample
Data From an SQL Server Database (page 51).
The BHBatchHis table is used by the Batch Archiver as the primary
storage facility for batch event data. The columns in the FactoryTalk
Historian for Batch tables generally match the columns in the
BHBatchHis table for easy cross-reference.
Field Name Data Type Description Example
GMT Date/Time Time event is recorded in Greenwich Mean Time 2013-04-29 12:21:01.000
lclTime Date/Time Local time event is recorded 2013-04-29 14:52:07.000
UniqueID Text Unique identifier assigned by the Batch Server 31
BatchID Text Alpha Batch ID BATCH_ID-030102-3
Recipe Text
The recipe element that was executing at the time
of the electronic batch record entry. The field
contents appear as:
<UniqueID>:[<Procedure>\][<Uni
t Procedure>:Instance\]
<Operation>:Instance-LoopCount
er
The data in the brackets is optional, depending on
the recipe level.
13:Y_300_YELLOW_PAINT
Descript Text Description of PValue data Yellow Paint
Event Text Event type triggering the record
Material Tracking / Material Bound / Material
Unbound
PValue Text Value reported to the electronic batch record 50
DescriptAPI Text Description of PValue data Engineering Units
EventAPI Text Event type triggering the record Report
PValueAPI Text Value reported to the electronic batch record 50
EU Text Engineering units associated with Pvalue GALLONS
Area Text
Area model name in batch equipment
configuration where batch was executed
THE_PAINT_COMPANY
ProcCell Text Process cell in Batch equipment configuration YELLOWPAINT1
Unit Text Unit name in Batch equipment configuration PREMIX_A
Phase Text Name of the phase generating the record PROC_ORDER_N
BHBatchHis Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 31