util_reas

reas_desc

string80

N

N

Description of reason

reas_grp_id

int32

N

N

Link to reason group

state_cd

int32

N

N

State for this reason

runtime

logical

N

N

Count this sort of time as running. Default = No.

downtime

logical

N

N

Count this sort of time as downtime. Default = Yes.

setuptime

logical

N

N

Count this sort of time as setup time. Default = No.

teardowntime

logical

N

N

Count this sort of time as teardown time. Default = No.

fixedtime

logical

N

N

Count this sort of time as fixed. Default = No.

vartime

logical

N

N

Count this sort of time as variable. Default = Yes.

failure

logical

N

N

Count this time as a failure. Default=No

def_lab_cd

string40

N

Y

Default labor code when this reason selected manually

display_seq

int32

N

N

Specify the display sequence of reasons

priority

int32

N

N

The utilization reason priority value. The utilization reason with the highest value is used for the line when two or more bottleneck entities have differing reasons. Default = 1.

Note: The functionality that the utilization reason with the highest value is used for the line when two or more bottleneck entities have differing reasons is currently not used.

max_duration

int32

N

Y

The maximum duration, in seconds, that is used with setting a Severe flag or with the new_reas_cd parameter:

• If the new_reas_cd parameter is not being used (that is, it is null) and the maximum duration is exceeded, the reason is marked as being Severe and the event is considered to be in a severe condition. The Severe flag is typically used with downtime events.

• If the new_reas_cd parameter is being used and the maximum duration is exceeded, the utilization reason for the entity is changed to the new reason specified in the new_reas_cd parameter.

  Null (the default) = no duration limit.

new_reas_cd

int32

N

Y

The reason to which the entity should be changed if the max_duration is exceeded on this reason. Should be null if max_duration is null.

standard_time

tfloat

N

Y

The standard time for this utilization reason, in minutes.

min_time

tfloat

N

Y

The minimum time for this utilization reason, in minutes.

max_time

tfloat

N

Y

The maximum time for this utilization reason, in minutes.

ent_enabled

logical

N

N

Indicates whether when, in this utilization reason, the entity is to be considered to be enabled (to be included in line production rate calculations), to have additional work queued for it, and to allow jobs to be started on it.

Default = True.

category1

string80

N

Y

User defined category copied to util_history; used for sorting and grouping the reasons.

category2

string80

N

Y

User defined category copied to util_history; used for sorting and grouping the reasons.

category3

string80

N

Y

User defined category copied to util_history; used for sorting and grouping the reasons.

category4

string80

N

Y

User defined category copied to util_history; used for sorting and grouping the reasons.

spare1

string80

N

Y

Use defined by language term 3007.

spare2

string80

N

Y

Use defined by language term 3008.

spare3

string80

N

Y

Use defined by language term 3009.

spare4

string80

N

Y

Use defined by language term 3010.

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

reas_cd

ID 0

Y

N

Identify reason