Rockwell Automation FactoryTalk Historian Classic for Batch User Guide - 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
<FORM> Add a CIP Batch to the
Batch List. Click "OK" when
done.
</FORM>
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