Tables for Machine Utilization

Util_Exec Table

The break_start_reas_cd and break_end_reas_cd fields are not used by the system.

Util_Reas Table

Four spare fields have been added.

Util_Shift_Link Table Added

Specifies a shift during which a utilization event occurred. For a given utilization event, there will be a separate record for each shift during which the event occurred. This table allows utilization events to be properly broken down by the shifts in which they occur, which in turn allows their correct duration to be reported.

• Each record in the table identifies the actual utilization event in the util_history table using the ent_id and event_time_utc fields as keys. These two fields uniquely identify records in the util_history table.

• Each record identifies the shift using the shift_start_utc field.

• A record can optionally include a value for the row ID of a record in the job_history, which identifies the job that was running while the event was occurring.

• When a util_history record is deleted, any util_shift_link records linked to that util_history record (identified by the ent_id and event_time_utc fields) are deleted.

  Field	Datatype	PK	Nulls?	Description
  ent_id	int32	Y	N	The ID of the entity at which the utilization event took place.
  act_event_time_utc	tdatetime	Y	N	The actual start time of the event, in UTC. The actual start time can be different than the start time within the linked shift (event_time_utc) if the event duration spans two or more shifts and the event was not actually started in the linked shift.
  event_time_utc	tdatetime	Y	N	The start time of the event within the linked shift, in UTC. If the event was started within the linked shift, the value for this column and the act_event_time_utc column will be the same. If the event started in a previous shift, this will be the shift start time.
  event_time_local	tdatetime	N	N	The start time of the event within the linked shift, in the local time of the entity.
  shift_start_utc	tdatetime	N	N	The start time of the shift, in UTC. Used to identify the shift to which the utilization event is linked.
  job_hist_row_id	int32	N	Y	The row ID of the record in the Job_History table for the job that was running while the event was occurring.
  last_edit_comment	string254	N	Y	Reserved for internal use to indicate why this record was changed
  last_edit_by	string40	N	Y	Who last changed this record.
  last_edit_at	tdatetime	N	N	When this record was last changed.
  row_id	ID 0	N	N	Unique row identifier, for audit trail.

FK from ent_id to util_history. (Cascade delete, in combination with matching act_event_time_utc value)

FK from act_event_time_utc to util_history. (Cascade delete, in combination with matching ent_id value)

FK from job_hist_row_id to job_history.

Util_State Table

A foreign key to the def_lab_cd field in the labor_cat table has been added.