Rockwell Automation FactoryTalk Historian Classic for Batch User Guide User Manual
Page 32
Chapter 3 Collecting Batch Data
Field Name Data Type
Description
Example
Printed
Date/Time
Last date the batch report was printed
2013-04-29 14:52:07.000
UserID
Text
Computer name/Windows user name
mjames1
PhaseDesc
Text
Phase class description
MaterialName Text
Common name of the material
YELLOWPAINT
MaterialID
Text
Inventory control system material ID used to track
the material
31
LotName
Text
Name assigned to a lot of material
TEST317_BRAND
Label
Text
ID assigned to a distributed portion of a lot
STANDARDBRANDYELLOW
Container
Text
Container's name where material and lot were
distributed, or where material and lot are stored
WAREHOUSE2/PAINT_PALLET1
PromiseID
Text
Unique ID used as a key to allow grouping of
separate event entries all resulting from a single
material addition
100
Signature
Text
Used for event journal signatures by Batchsig
program to detect changes in .evt file.
Information stored here is a hexadecimal or a
single spaced character.
ERP_Flag
Text
Tag indicating information reported to SAP
RecordNo
integer
Unique identifier assigned to the record when it is
added to the database
31
ArchivedGMT
date/time
Time in Universal Coordinated Time when event
was archived to the database
2002-08-15 18:36:06.500
Reactivation
Number
integer
Number of times an active eProcedure control
step has been reactivated
1
Instruction
HTML
ntext
HTML for completed eProcedure instruction steps
SQL Server columns that have a field type of `ntext' only retrieve 256 characters of data at a time using a standard SELECT statement. To
retrieve all the data use the READTEXT function. See How To Display All Instruction HTML Data From an SQL Database (page 33) for more
information.
SignatureID
integer
A 32-bit unsigned integer that uniquely identifies
a Signature Request within the batch system.
1
ActionID
integer
A 32-bit unsigned integer that uniquely identifies
an Action within the batch system. An Action is a
queued Execute command to the Batch Server
that is pending one or more Signature
completions prior to being performed.
1
32
Rockwell Automation Publication BHIST-UM011A-EN-E-June 2014