Output table
This table describes the schema of the BHBATCHHIS table in the BatchHistoryEx database. Use this schema as the basis for developing a custom output table.
TIP:
SQL Server
columns that have a box type of ntext
only retrieve 256 characters at a time
using a standard SELECT statement. To retrieve all the data, use the READTEXT function. Name | Type | Description | Example |
|---|---|---|---|
GMT | datetime NULL | Time event is recorded in Greenwich Mean Time | 2003-04-29 12:21:01.000 |
lclTime | datetime NULL | Local time of event | 2003-04-29 14:52:07.000 |
UniqueID | varchar(12) NULL | Unique identifier assigned by the FactoryTalk Batch Server | 31 |
BatchID | varchar(255) NULL | Alpha Batch ID | BATCH_ID-030102-3 |
Recipe | varchar(1000) NULL | The recipe element that was executing at the time of the electronic batch record entry. The box contents appear as:
<UniqueID>:[<Procedure>\][<Unit Procedure>:Instance\] <Operation>:Instance-LoopCounter The data in the brackets is optional, depending on the recipe level. | 13:Y_300_YELLOW_PAINT |
Descript | varchar(255) NULL | Description of PValue data | Yellow Paint |
Event | varchar(155) NULL | Event type triggering the record | Material Tracking / Material Bound / Material Unbound |
PValue | varchar(255) NULL | Value reported to the electronic batch record | 50 |
DescriptAPI | varchar(255) NULL | Description of PValue data | Engineering Units |
EventAPI | varchar(155) NULL | Event type triggering the record | Report |
PValueAPI | varchar(255) NULL | Value reported to the electronic batch record | 50 |
EU | varchar(255) NULL | Engineering units associated with PValue | GALLONS |
Area | varchar(155) NULL | Area model name in batch equipment configuration where batch was executed | THE_PAINT_COMPANY |
ProcCell | varchar(155) NULL | Process cell in batch equipment configuration | YELLOWPAINT1 |
Unit | varchar(155) NULL | Unit name in batch equipment configuration | PREMIX_A |
Phase | varchar(155) NULL | Name of the phase generating the record | PROC_ORDER_N |
Printed | datetime NULL | Last date the batch report was printed | 2003-04-29 14:52:07.000 |
UserID | varchar(85) NULL | Computer name/Windows user name | mjames1 |
PhaseDesc | varchar(50) NULL | Phase class description | |
MaterialName | varchar(155) NULL | Common name of the material | YELLOWPAINT |
MaterialID | varchar(50) NULL | Inventory control system material ID used to track the material | 31 |
LotName | varchar(255) NULL | Name assigned to a lot of material | TEST317_BRAND |
Label | varchar(255) NULL | ID assigned to a distributed portion of a lot | STANDARDBRANDYELLOW |
Container | varchar(255) NULL | Container’s name where material and lot were distributed, or where material and lot are stored | WAREHOUSE2/PAINT_PALLET1 |
PromiseID | varchar(50) NULL | Unique ID used as a key to allow grouping of separate event entries all resulting from a single material addition | 100 |
Signature | varchar(255) NULL | 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 | varchar(1) NULL | Tag indicating information reported to SAP | |
RecordNo | int NULL | Unique identifier assigned to the record when it is added to the database | 31 |
ArchivedGMT | datetime NULL | Date and time | 2003-04-29 14:52:07:000 |
Reactivation Number | int | Number of times an active e Procedure | 1 |
InstructionHTML | ntext | HTML for completed e Procedure | <FORM> Add a CIP batch to the Batch List. Select OK when done.</FORM> |
SignatureID | int | A 32-bit unsigned integer that uniquely identifies a Signature Request within the batch system. | 1 |
ActionID | int | A 32-bit unsigned integer that uniquely identifies an Action within the batch
system. An Action is a queued Execute command to the FactoryTalk Batch Server that is pending one or more Signature completions prior to
execution. | 1 |
ContextsID | varchar(255) NULL | Supports Context ID reporting. Lists the ContextID enumeration set member ordinals assigned to the input or output parameter for event generation. | |
Contexts | varchar(1024) NULL | Supports Context ID reporting. Lists the ContextID enumeration set member strings assigned to the input or output parameter for event generation. | |
RecordID | PK, varchar(255) NOT NULL | The primary key. | IDEVSE110010Sep 3 2014881157 |
Provide Feedback