Batch Analysis and the Event Transactions Table
Batch process data can be imported into the Proficy Plant Applications MES solution where data can be analyzed, reported on, and used as inputs to other core functions within Plant Applications. If you are interfacing Plant Applications with the external S88 batch execution engines such as Proficy Batch Execution or RSBatch, then Model 5013 is used to load S88 batch events from these batch execution platforms into an intermediate transaction table, Event_Transactions, in the Plant Applications database. Model 49000, that is created by Model 118, reads the records from the Event Transactions table and puts them into the appropriate Plant Applications table.
If you are using another batch system, you must write your own stored procedure, and then use Model 602 to load your batch events into the Event_Transactions table.
The Event_Transactions Table Structure
The following table describes the structure for the Event_Transactions table. The value in the EventType field will determines which rows are processed and which fields are required. The five valid EventType values are:
|
Field |
Data Type |
Description |
|
[EventTransactionId] |
[int] |
Specifies unique identifier for the event transaction record. |
|
[OrphanedFlag] |
[bit] |
Indicates that the processed transaction was ignored, or an error occurred. |
|
[ProcessedFlag] |
[bit] |
Indicates that the transaction has been successfully processed. |
|
[ProcessedTimeStamp] |
[datetime] |
Specifies the timestamp the transaction was last processed. |
|
[EventTimeStamp] |
[datetime] |
Specifies the local timestamp event created in the batch execution system (BES). |
|
[ProcedureStartTime] |
[datetime] |
Specifies the start time of the procedure. |
|
[ProcedureEndTime] |
[datetime] |
Specifies the end time of the procedure. |
|
[RawMaterialDimensionA] |
[float] |
Specifies the diameter of the material being consumed. |
|
[RawMaterialDimensionX] |
[float] |
Specifies the weight of the material being consumed. |
|
[RawMaterialDimensionY] |
[float] |
Specifies the length of the material being consumed. |
|
[RawMaterialDimensionZ] |
[float] |
Specifies the width of the material being consumed. |
|
[UnitProcedureInstance] |
[int] |
Specifies the instance of the unit procedure within the batch. |
|
[OperationInstance] |
[int] |
Specifies the instance of the operation within the batch. |
|
[BatchInstance] |
[int] |
Specifies the instance of the batch. |
|
[PhaseInstance] |
[int] |
Specifies the instance of the phase within the batch. |
|
[Proficy_Id] |
[int] |
Specifies the unique identifier of a Proficy record. |
|
[RawMaterialCellName] |
[varchar] (100) |
Specifies the cell or production line of the raw material event that will get linked to the main batch event. |
|
[RawMaterialUnitName] |
[varchar] (100) |
Specifies the production unit of the raw material event that will get linked to the main batch event. |
|
[EventReportType] |
[varchar] (50) |
Creates a User-Defined Event type by using the name specified in the EventReportType. |
|
[RecipeString] |
[varchar] (1000) |
Specifies the full recipe string reported by the batch execution system. |
|
[OrphanedReason] |
[varchar] (255) |
Specifies the reason why the transaction was not processed. |
|
[RawMaterialAreaName] |
[varchar] (100) |
Specifies the area or department of the raw material event that will get linked to the main batch event. |
|
[RawMaterialContainerId] |
[varchar] (50) |
Specifies the identification of the container moving the material. |
|
[UserName] |
[varchar] (100) |
Specifies the user creating or approving the transaction. |
|
[UserSignature] |
[varchar] (255) |
Specifies the token of the user approving the transaction. |
|
[ParameterAttributeComments] |
[varchar] (255) |
Specifies the comments that apply to the value being reported. |
|
[RawMaterialProductCode] |
[varchar] (25) |
Specifies the product code of the raw material being moved or consumed. |
|
[RawMaterialBatchName] |
[varchar] (50) |
Specifies the source batch or lot of the material being moved or consumed. |
|
[ParameterAttributeName] |
[varchar] (100) |
Specifies the attribute of the parameter being reported. |
|
[ParameterAttributeUOM] |
[varchar] (15) |
Specifies the unit of measure of the parameter being reported. |
|
[ParameterAttributeValue] |
[varchar] (25) |
Specifies the value of the parameter being reported. |
|
[PhaseName] |
[varchar] (50) |
Specifies the name of the phase. |
|
[StateValue] |
[varchar] (25) |
Specifies the name of the procedure state or completion status. |
|
[ParameterName] |
[varchar] (100) |
Specifies the name of the parameter being reported. |
|
[BatchProductCode] |
[varchar] (25) |
Specifies the product code of a batch. |
|
[UnitProcedureName] |
[varchar] (50) |
Specifies the name of the unit procedure. |
|
[OperationName] |
[varchar] (50) |
Specifies the name of the operation. |
|
[CellName] |
[varchar] (100) |
Specifies a production line in the Batch execution system in the Plant Model. |
|
[UnitName] |
[varchar] (100) |
Specifies a production line in the Batch execution system in the Plant Model. |
|
[BatchName] |
[varchar] (50) |
Specifies the name of a batch that includes the UnitCycleCount production line. |
|
[EventType] |
[varchar] (20) |
Specifies the type of event to be processed. |
|
[EventName] |
[varchar] (100) |
Specifies the description of the subtype of an event. |
|
[AreaName] |
[varchar] (100) |
Specifies the name of a department in the batch execution system in the Plant Model. |
|
[ProcessOrderId] |
[Int] |
Specifies the unique identifier of a process order that enables the inclusion of the process order associated with a Production Event in the ProcedureReport event type. |
|
[InitialDimensionX] |
[Float] |
Specifies the initial weight of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[InitialDimensionY] |
[Float] |
Specifies the initial length of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[InitialDimensionZ] |
[Float] |
Specifies the initial width of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[InitialDimensionA] |
[Float] |
Specifies the initial diameter of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[FinalDimensionX] |
[Float] |
Specifies the final weight of the material produced during a Production Event associated with the ProcedureReport event type. |
| [FinalDimensionY] |
[Float] |
Specifies the final length of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[FinalDimensionZ] |
[Float] |
Specifies the final width of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[FinalDimensionA] |
[Float] |
Specifies the final diameter of the material produced during a Production Event associated with the ProcedureReport event type. |
|
[EventSubtype] |
[varchar] (50) |
Specifies the subtype of an event that overrides the event associated with a User-Defined Event (UDE) in the S88 batch interface.
|
|
[LotIdentifier] |
[nvarchar] (100) |
Specifies the unique identifier of a Lot associated with a Production Event that enables you to search for events by Lot IDs. |
|
[FriendlyOperationName] |
[nvarchar] (100) |
Specifies the name of the operation associated with a Production Event. For example, Op1 and Op2. |