The timed_event_details Data Model
The timed_event_details data model creates a relationship between the area and line of a site, the production unit ID, the start time, and the downtime. The production unit ID, start time, and downtime are associated with the downtime category, end time, and event reason.
The data model uses the following primary key and Rest APIs:
- Primary key: ((tenant_id, enterprise_id, site_id, area, line), pu_id, start_time, tedet_id)
- REST APIs: Downtime Metrics, downtimeReports, downtimeReports/{id}
- tenant_id
- enterprise_id
- site_id
- area
- line
- pu_id
- start_time
- tedet_id
- bom_name
- cause_comment
- crew
- downtime_category
- dt_category set
- dt_category_l1 set
- dt_category_l2 set
- dt_category_l3 set
- dt_category_l4 set
- dt_performance
- dt_schedule
- duration
- end_time
- end_time_utc
- enterprise
- event_reason_id1
- event_reason_id2
- event_reason_id3
- event_reason_id4
- event_reason_name1
- event_reason_name2
- event_reason_name3
- event_reason_name4
- fault
- awsdms_cap_timestamp
- awsdms_cap_timestamp_utc
- initiated_by
- initiated_source
- ins_ts
- is_deleted
- planned
- process_order
- prod_code
- prod_desc
- product_family_desc
- product_grp_desc
- production_status
- production_status_reason
- replica_ins_ts
- shift
- site
- source_pu_id
- sourceunit
- start_time_utc
- start_time_yyyymmdd
- summary_cause_comment
- tenant
- unit
- upd_ts
- uptime