Storing control rules internally

A rule, whether standard or custom, is controlled by their definition in the Spc_Rule table, as described in the table below.

Values configured for Test1 and Test2 can be interchanged without affecting whether the rule is violated or not. Test1 uses the value in Level1, and Test2 uses the value in Level2.

• If the Boolean flag AndNotOr is set to True, Test1 and Test2 must contain a non-null value and they both must satisfy the tests to log a rule violation; otherwise, the rule is not considered to be violated.

• If the Boolean flag AndNotOr is set to False, it is only required if either Test1 or Test2 satisfies its test to log a rule violation.

  Test1/ Test2	Level1/ Level2	Num Points	Of Points	Type of Rule Violations	Comments/ Example
  Trend Up (1)	Not Applicable	Applicable, if > 2	Applicable, if > 2	Num Points of Of Points increasing	Num Points and Of Points must be greater than 2 (e.g., 7 of 7 increasing)
  Trend Down (2)	Not Applicable	Applicable, if > 2	Applicable, if > 2	Num Points of Of Points decreasing	Num Points and Of Points must be greater than 2 (e.g., 7 of 7 decreasing)
  Run Above (3)	Applicable	Applicable, if > 0	Applicable, if > 0	Chart point above upper control limit Num Points of Of Points above >=Level* std. dev. Num Points of Of Points on one side (upper) of center line	If Num Points = 1, Level1 is NULL, then this test validates whether the chart point is above upper control limit (e.g.,1 above upper control limits). If Num Points > 0 Of Points > 0, Level1 <> 0, then this test validates whether the Num Points of Of Points above >= Level1 std. dev. (e.g., 2 of 3 above 2 std. dev.). If Num Points > 1, Of Points > 1, Level1 = 0, then this test validates whether the Num Points of Of Points on upper side of centerline (e.g., 8 of 8 points on one side (above) of CL).
  Run Below (4)	Applicable	Applicable, if > 0	Applicable, if > 0	Chart point below lower control limit Num Points of Of Points below <= Level * std. dev. Num Points of Of Points on one side (lower) of center line	If Num Points = 1, Level1 is NULL, then this test validates whether the chart point is below lower control limit (e.g., 1 below lower control limit). If Num Points > 0, Of Points > 0, Level1 <> 0, then this test validates whether the Num Points of Of Points below <=Level1 std. dev. (e.g., 2 of 3 below 2 std. dev). If Num Points > 1, Of Points > 1, Level1 = 0, then this test validates whether the Num Points of Of Points on lower side of centerline (e.g., 8 of 8 points on one side (below) of CL).
  Run Beyond (6)	Applicable	Applicable, if > 0	Applicable, if > 0	Num Points of Of Points beyond <=-Level * std.dev. or >=+Level * std. dev.	If Num Points > 1, Of Points > 1, Level* <> 0, then this test validates whether the Num Points of Of Points beyond <=-Level* std. dev. or beyond >=+Level* std.dev. (e.g., 8 of 8 points beyond 1 std. dev.).