std_oper_step

oper_id

string40

Y

N

Identify operation

step_no

int32

Y

N

Identify step

step_seq

int32

N

N

Sequence to perform steps. Same seq means steps can be done concurrently.

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:

0 = Normal (default)

1 = Log data

2 = Add production

3 = Add consumption

4 = Operator acknowledge

5 = Enter form data

6 = Enter SPC data

std_time

tfloat

N

N

Hours allowed for this step

complete_cond

int32

N

N

Enumeration of what completes the step:

1 = tag changes

2 = std. time elapses

3 = operator completes manually (the default)

4 = message is dismissed (only allowable if action_type = 4)

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 for this step

data_log_grp_id

int32

N

Y

Data log group for this step if any

reqd_rep_pct

tfloat

N

N

Percentage of lots or 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 = text box, storing any string (the default)

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 537

spare2

string80

N

Y

Use defined by language term 538

spare3

string80

N

Y

Use defined by language term 539

spare4

string80

N

Y

Use defined by language term 540

spare5

string80

N

Y

Use defined by language term 541

spare6

string80

N

Y

Use defined by language term 576

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

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