The production_event_details Data Model
The production_event_details data model creates a relationship between the area and line of a site, the production unit ID, and the start time of a production event. The production unit ID and start time are associated with the initial quantity, material details, and inventory count.
The data model uses the following primary key: ((tenant_id, enterprise_id, site_id, area, line), pu_id, start_time)
The data model contains the following columns:
- tenant_id
- enterprise_id
- site_id
- area
- line
- pu_id
- start_time
- bom_name
- category
- crew
- end_time
- end_time_utc
- entered_on
- enterprise
- event_id
- eventnum
- awsdms_cap_timestamp
- awsdms_cap_timestamp_utc
- initial_quantity_a
- initial_quantity_x
- initial_quantity_y
- initial_quantity_z
- initiated_by
- ins_ts
- inventory_count
- prod_code
- prod_desc
- product_family_desc
- product_grp_desc
- production_count
- production_status
- production_status_reason
- production_variable
- production_variable_value
- quantity_a
- quantity_x
- quantity_y
- quantity_z
- replica_ins_ts
- replica_upd_ts
- route
- scrap_quantity
- shift
- site
- start_time_utc
- tenant
- unit
- upd_ts
- work_order_id
- work_order_name