util_exec

ent_id

int32

Y

N

Identify entity for which utilization may be collected

cur_state_cd

int32

N

Y

Current state of this entity

cur_reas_cd

int32

N

Y

Current reason for this entity

cur_reas_start_utc

tdatetime

N

Y

When current entity reason started in UTC

cur_reas_start_local

tdatetime

N

Y

When current entity reason started in local time

cur_raw_reas_cd

string40

N

Y

Current raw reason for this entity

reas_reqd

logical

N

N

Yes if this entity is currently waiting for the user to enter/override a final reason. Default = No

cur_log_id

int32

N

Y

Holds the log_id from the util_history table.

Beginning with MES version 6.0, this column is not used for new records.

target_util

tfloat

N

Y

Target entity utilization

current_util

tfloat

N

Y

Current entity utilization = RT/(RT+DT).

This column is not updated for each change in the utilization event. Instead, the current utilization is calculated on‑demand when requested from the client.

jobstart_reas_cd

int32

N

Y

Default reason when job starts

jobend_reas_cd

int32

N

Y

Default reason when job ends

shift_start_reas_cd

int32

N

Y

Default reason when a valid shift starts.

shift_end_reas_cd

int32

N

Y

Default reason when the ‘null’ shift starts.

unkn_stop_reas_cd

int32

N

Y

Default reason when unknown reason from I/O

break_start_reas_cd

int32

N

Y

Default reason when a shift break starts

Note: Currently, this field is not used by the system.

break_end_reas_cd

int32

N

Y

Default reason when a shift break ends

Note: Currently, this field is not used by the system.

inherit_from_parent

logical

N

N

Yes if, when the cur_reas_cd for a parent entity changes, the change should be applied to this entity as well. Default = Yes

spare1

string1000

N

Y

Use defined by language term 514

spare2

string1000

N

Y

Use defined by language term 515

spare3

string1000

N

Y

Use defined by language term 516

spare4

string1000

N

Y

Use defined by language term 517

last_edit_comment

notes

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