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

Chapter 3 Collecting Batch Data
Column Datatype Description Example
userid text User ID mjames1
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:23.000
The BHModeCommand table contains data pertaining to any mode
command. This table provides storage of essential mode command
data to indicate an operator has taken or relinquished control of the
batch.
Column Datatype Description Example
uniqueid text Unique ID 13
mode text
Mode requested by the
operator
SEMIAUTO-MODE / AUTO-MODE / MAN-MODE
machineid text Machine ID DEV-MJAMES-01
recipe text Recipe 13:Y_300_YELLOW_PAINT-1
userid text User ID mjames1
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 2002-03-01 12:21:23.000
The BHModeChange table contains data pertaining to any mode
change for an equipment phase only. This table provides storage of
essential mode change data regarding mode changes of equipment
modules (phases). Each mode/command record is linked to only one
batch and/or phase.
Column Datatype Description Example
uniqueid text Unique ID 13
mode text Mode that was changed to O-AUTO / P-AUTO
equipment phase text Equipment module WP_ADD_SUGAR_M1
recipe text Recipe
13:Y_300_YELLOW_PAINT\PM_UP_STEP1:1\PM_OP_PR
OC_ORDER:1\PROC_ORDER_CLS:1-1
unitname text Unit name PREMIX_NORTH
area text Area THE_PAINT_COMPANY
eventtime date/time Time stamp 7/4/96 18:48:00
BHModeCommand Table
BHModeChange Table
40 Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014