Data
- Last UpdatedMar 18, 2024
- 1 minute read
The AVEVA Batch Management Batch Execution System (BES) version 8.1 SP1 and above stores batch data in Microsoft SQL Server. The interface reads data from the following tables:
|
View/Table |
Data read by interface |
|---|---|
|
BatchIDLog |
UniqueID, BatchID, start time, end time |
|
BatchDetail |
Batch recipe data, product, equipment used for recipe execution, Start/End batch events. |
Union of tables:
-
ProcessVar
-
ProcessVarChange
-
OperatorComment
-
PhaseInstruction
-
MaterialInput
-
MaterialInputChange
-
MaterialOutput
-
EquipStatus
-
Transition
-
TransitionExpression
-
BatchQuestion
BatchDetail data and data for all batches, including Variable Name, Variable Actual Value, Variable Target or Old Value, and Event Timestamp.