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

Collecting Batch Data Chapter 3
Column Datatype Description Example
changed the parameter
area text Area THE_PAINT_COMPANY
eventtime date/time
Time stamp when change
was made
2002-03-01 12:21:23.000
The BHPrompt table contains data pertaining to prompt events.
The recipe column allows prompts and their responses to be
matched for determination of time differences. This table provides
storage of essential prompt data and allows prompt data to be linked
to a given batch and/or phase. Each prompt record is linked to only
one batch and/or phase record.
Column Datatype Description Example
uniqueid text Unique ID 31
paramname text Parameter name AMOUNT_TO_CHARGE
datavalue text Default data value 45.5
recipe text Recipe 31:DEMO_RECIPE\PREMIX_A:1\MAKE_A:1\CHARGE:1-1
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:16.000
The BHPromptresponse table contains data pertaining to any event
where an operator responded to a prompt. The recipe column allows
prompts and their responses to be matched for determination of
time differences. This table provides storage of essential prompt
response data and allows prompt response data to be linked to a
given batch and/or phase. Each prompt response record is linked to
only one batch and/or phase.
Column Datatype Description Example
uniqueid text Unique ID 31
paramname text Parameter name AMOUNT_TO_CHARGE
datavalue text Operator's input 55
machineid text Machine ID DEV-MJAMES-01
recipe text Recipe 31:DEMO_RECIPE\PREMIX_A:1\MAKE_A:1\CHARGE:1-1
BHPrompt Table
BHPromptResponse Table
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014 39