util_state

state_desc

string80

N

N

State description, must be unique

color

int32

N

N

Background color

runtime

int32

N

Y

Defaults for fields of the same name for utilization reasons:

Null = No default

0 = default No

1 = default Yes

downtime

int32

N

Y

setuptime

int32

N

Y

teardowntime

int32

N

Y

fixedtime

int32

N

Y

vartime

int32

N

Y

failure

int32

N

Y

def_lab_cd

string40

N

Y

Defaults for fields of the same name for utilization reasons:

Null = no default

priority

int32

N

Y

max_duration

int32

N

Y

new_reas_cd

int32

N

Y

standard_time

tfloat

N

Y

min_time

tfloat

N

Y

max_time

tfloat

N

Y

ent_enabled

int32

N

Y

Defaults for ent_enabled for utilization reasons:

Null = no default

0 = default No

1 = default Yes

category1

string80

N

Y

Defaults for fields of the same name for utilization reasons

Null = no default

category2

string80

N

Y

category3

string80

N

Y

category4

string80

N

Y

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

state_cd

ID 1

Y

N

Identify code