spc_rule

rule_desc

string40

N

N

Unique description of rule

use_for_ix

logical

N

N

Yes if rule is to apply to indicated type of chart; default = No

use_for_mr

logical

N

N

use_for_xbar

logical

N

N

use_for_range

logical

N

N

use_for_sigma

logical

N

N

use_for_ma

logical

N

N

use_for_ewmaix

logical

N

N

use_for_run

logical

N

N

use_for_attr

logical

N

N

test1

int32

N

Y

Enumeration for primary test if any:

1 = trend up

2 = trend down

3 = run above

4 = run below

5 = run within

6 = run beyond

7 = alternating about

8 = capability sigma above

9 = Cpk above

10 = mean above

11 = Ppk above

12 = standard deviation above

test2

int32

N

Y

Enumeration for secondary test if any. Same details as test1 for 1 – 7.

8 = capability sigma below

9 = Cpk below

10 = mean below

11 = Ppk below

12 = standard deviation below

and_not_or

logical

N

N

Yes if both test conditions must be met for the process to be considered out-of-control.

No if meeting either is enough, or if either test1 or test2 is null.

level1

tfloat

N

Y

Value in standard deviations to apply to test1 if applicable.

If test1 = 3, 4, or 6, NULL = control limits.

If test1 = 9 or 11, value is dimensionless.

If test1 = 10, value is in units of the characteristic.

level2

tfloat

N

Y

Value in standard deviations to apply to test2 if applicable.

If test2 = 3, 4, or 6, NULL = control limits.

If test2 = 9 or 11, value is dimensionless.

If test2 = 10, value is in units of the characteristic.

num_points

int32

N

N

Number of subgroups that must meet the criteria in order for the condition to be satisfied

of_points

int32

N

N

Number of subgroups to check at a time, from with num_points are gotten

priority

int32

N

N

Relative importance of rule violations, lower numbers more important than higher

obsolete

logical

N

N

Is this rule to no longer be used; default = No

last_edit_comment

string254

N

Y

Reserved for internal use to indicate why this record was changed

last_edit_by

string40

N

N

ID of user who last modified record

created_by

string40

N

N

ID of user who created record

last_edit_at

tdatetime

N

N

When record last modified

created_at

tdatetime

N

N

When record created, in UTC

rule_id

ID 0

Y

N

Identify rule; initially coded as follows:

0 = 1 sample outside control limit

1 = 2 of 3 outside 2 standard deviations

2= 3 of 7 outside 2 standard deviations

3 = 4 of 10 outside 2 standard deviations

4 = 4 of 5 outside 1 standard deviation

5 = 7 consecutive samples on one side of centerline

6 = 8 consecutive samples on one side of centerline

7 = 8 consecutive samples beyond 1 standard deviation

8 = 9 consecutive samples on one side of centerline

9 = 10 of 11 on one side of centerline

10 = 12 of 14 on one side of centerline

11 = 6 consecutive samples increasing or decreasing

12 = 7 consecutive samples increasing or decreasing