Personnel actual (labor)
- Last UpdatedJan 31, 2025
- 1 minute read
When the Personnel Actual command is triggered, the specified data is logged in the Job_Event table. The Job_Event record for the personnel actual data is identified through the PEMPersonnelActual 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 |
PEMPersonnelActual. |
|
|
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 |
Accepts a comma-separated list. |
|
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 |
|
|
Sublot |
sublot_no |
|
|
Serial Number List |
value5 |
|
|
Genealogy ID |
genealogy_id |
|
|
Subsegment |
subsegment_id |
|
|
Quantity |
quantity |
|
|
value6 |
The row_id from the Data_Log table that is linked to the EPA data of this transaction. |
|
|
Unit Of Measure |
value7 |
This UOM only represents the actual unit of measurement that is reported during production. The corresponding quantity may be stored in different units in the MES database, as the quantities for the production and consumption are recorded in native units of this item. |