Production Data (Data Logging)
- Last UpdatedMay 04, 2023
- 1 minute read
When the production command is triggered, the specified data is logged in the Job_Event table. The job_event record for the production data is identified through the PEMProductionData event_type.
The following table illustrates the functional data mapping between the attributes exposed in the UI and how the data is recorded.
|
PEM Attribute |
Columns in Job_Event Table |
Comments |
|---|---|---|
|
event_type |
The event type is PEMProductionData. |
|
|
ent_id |
The ID of the entity that triggers the middleware call. |
|
|
Comments |
comments |
|
|
Event Name |
value3 |
|
|
Location |
value2 |
|
|
Lot |
lot_no |
|
|
Material Id |
item_id |
|
|
Personnel List |
value4 |
|
|
Process Segment Id |
oper_id |
|
|
Production Request Id |
wo_id |
|
|
Production Schedule Id |
value1 |
|
|
Segment Requirement Id |
segment_requirement_id |
|
|
Segment Response Id |
segment_response_id |
|
|
Serial Number List |
value5 |
|
|
Sublot |
sublot_no |
|
|
Subsegment |
subsegment_id |
|
|
Genealogy ID |
genealogy_id |
|
|
value6 |
The row_id from the Data_Log table that is linked to the EPA data of this transaction. |