The waste_event_details Data Model
The waste_event_details data model creates a relationship between the area and line of a site, the production unit ID, and the event. The production unit ID and event are associated with the event reason and product details.
The data model uses the following primary key and rest APIs:
- Primary key: ((tenant_id, enterprise_id, site_id, area, line), pu_id, event_timestamp, wed_id)
- REST APIs: wasteReports, wasteReports/{id}
- tenant_id
- enterprise_id
- site_id
- area
- line
- pu_id
- event_timestamp
- wed_id
- bom_name
- cause_comment
- crew
- enterprise
- event_based
- event_reason_id1
- event_reason_id2
- event_reason_id3
- event_reason_id4
- event_reason_name1
- event_reason_name2
- event_reason_name3
- event_reason_name4
- event_timestamp_utc
- fault
- awsdms_cap_timestamp
- awsdms_cap_timestamp_utc
- initiated_by
- initiated_source
- ins_ts
- process_order
- prod_code
- prod_desc
- product_family_desc
- product_grp_desc
- production_status
- production_status_reason
- quantity
- replica_ins_ts
- shift
- site
- source_pu_id
- sourceunit
- tenant
- timestamp
- unit
- upd_ts