job_step

wo_id

string40

Y

N

Identify work order

oper_id

string40

Y

N

Identify operation

seq_no

int32

Y

N

Identify row in job table

step_no

int32

Y

N

Identify step

step_seq

int32

N

N

Sequence to perform steps

step_name

string40

N

Y

Text to be displayed with step_no to describe step briefly.

step_desc

string1700

N

N

Description for this step

action_type

int32

N

N

Enumeration of action to be performed in this step (see Oper_Step for details). Default = 0

std_time

tfloat

N

N

Hours allowed for this step

complete_cond

int32

N

N

Enumeration of what completes the step (see Oper_Step for details). Default = 3

allow_bypass

logical

N

N

Can the user bypass this step? Default = No.

enter_data

logical

N

N

Is data entry required at this step? Default = No.

step_grp_id

int32

N

N

Identify step group

spc_char

string40

N

Y

Allow for an optional SPC characteristic to be collected at this step

Note: This field is currently not used.

form_name

string254

N

Y

Link to an optional form (usually in a ‘Forms’ application) for this step

data_log_grp_id

int32

N

Y

Identify data log group whose data is to be collected at this step

reqd_rep

int32

N

N

Number of lots/sublots for which this step must be done; 0 (default) if for all. Applies only if max_lot_size or max_sublot_size = 1 and step group is repeatable.

control_type

int32

N

N

0 (default) = text box, storing any string

1 = text box, storing analog value

2 = text box, storing datetime

3 = checkbox

4 = radio buttons

5 = drop-down list

high_limit

tfloat

N

Y

Maximum allowable value if control_type = 1, otherwise null (default)

low_limit

tfloat

N

Y

Minimum allowable value if control_type = 1, otherwise null (default)

limit_warning

logical

N

N

If true and control_type is 1 and value entered is outside limits, warn user but permit entry anyway. If false (default) and control_type is 1 and value entered is outside limits, disallow entry. Has no effect if control_type <> 1 or value entered is within limits.

spare1

string80

N

Y

Use defined by language term 542

spare2

string80

N

Y

Use defined by language term 543

spare3

string80

N

Y

Use defined by language term 544

spare4

string80

N

Y

Use defined by language term 545

spare5

string80

N

Y

Use defined by language term 546

spare6

string80

N

Y

Use defined by language term 547

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 1

N

N

Unique row identifier, for audit trail.