Extended production attributes
- Last UpdatedJan 31, 2025
- 2 minute read
The extended attribute values for which the PEMAttrs.<Instance Name>.<AttributeName>.Log log attribute is set to True are collected at run btime and sent to the middleware when a PEM command is triggered. When a PEM command is triggered, only the extended attributes linked to a PEM instance are collected.
A valid data log group ID must exist for the specified data log group name. An exception is logged if the specified data log group does not exist in the database.
For example, the data log group name for the PEM extension attributes is represented as: OCO_001|Mixing|ProductionData, OCO_100|Blending|MaterialConsumption, and so on.
When the extended attribute data is sent to the middleware, the middleware queries the Data_Log_Value table using the specified data log group and value names (extended attribute name) to retrieve the value index.
After retrieving the value index is retrieved, the specified extended attribute value is copied to the corresponding value column in the Data_Log table. This process is repeated for all the specified extended attributes.
The extended attributes that match the value of the value_name column for a data log group in the Data_Log_Value table are logged into the Data_Log table and the remaining value columns are updated with Null values.
An exception is logged if the specified extended attribute name does not exist in the Data_Log_Value table for the specified data log group. The values that are retrieved at runtime from the extended attributes are always recorded in the Data_Log table
The following table illustrates the functional data mapping between the attributes exposed in the UI and how the data is recorded.
|
PEM Attribute |
Column in Data_Log Table |
Comments |
|---|---|---|
|
grp_id |
The group ID linked to the extended attribute. |
|
|
Event Time |
sample_time_local and sample_time_utc |
The specified local time that is recorded in the sample_time_local field and the corresponding UTC time is calculated from the local time with the specified offset. |
|
Production Request |
wo_id |
|
|
Process Segment |
oper_id |
|
|
seq_no |
The sequence number that is identified for the job. |
|
|
step_no |
Null |
|
|
Material Id |
item_id |
|
|
Lot |
lot_no |
|
|
Sublot |
sublot_no |
|
|
shift_start_utc |
The shift start time (in UTC) that is running at EventTime. |
|
|
shift_start_local |
The shift start time (in local) that is running at EventTime. |
|
|
shift_id |
The shift that is running at EventTime. |
|
|
ent_id |
The entity ID that triggers the middleware call. |
|
|
Genealogy |
genealogy_id |
|
|
Segment Requirement |
segment_requirement_id |
|
|
Segment Response |
segment_response_id |
|
|
value1 ... value48 |
Values related to an extended attribute. |