How DQM Handles Multiple Exceptions

<< Click to Display Table of Contents >>

 >Professional > Modules > DQM >

How DQM Handles Multiple Exceptions

In DQM, there is the option to either:

 

a)merge multiple qualifiers (the current method in EQuIS 7) or

b)select the highest ranked qualifier (the method used in v6.6.1)

when an analytical result has more than one exception to a Rule in a DQM Check.

 

To control this feature, there are three Global Parameters:

 

merge_equal_ranks: parameter to control how qualifiers with equal ranks are handled

MERGE = merge qualifiers with no warning;

WARNING = merge qualifiers and place a warning message in the Errors tab

 

merge_ranked_reason_codes: option to merge multiple reason codes, even when not merging qualifiers

when merge_qualifiers = FALSE,

ALL = merge the reason codes from all exceptions, even though not all of the qualifiers are not being merged;

EQUAL ONLY = use only the reason code from the exception with the highest DQM_CHECK_RANK in RT_QUALIFIER. If more than one exception has been assigned a qualifier with the highest rank, then only the reason codes from those exceptions will be merged.

 

merge_ranked_remarks: option to merge multiple remarks, even when not merging qualifiers

when merge_qualifiers = FALSE,

ALL = merge the remarks from all exceptions, even though not all of the qualifiers are not being merged;

EQUAL ONLY = use only the remark from the exception with the highest DQM_CHECK_RANK in RT_QUALIFIER. If more than one exception has been assigned a qualifier with the highest rank, then only the remarks from those exceptions will be merged.

 

Examples:

 

Assuming these qualifiers have the following ranks:

 

R: rank = 1

U: rank = 2

J:  rank =3

B: rank = 2

 

Note: Any unranked qualifiers -- DQM_CHECK_RANK = NULL -- will be assigned a Rank = 999 during the DQM processing.

 

Consider these three scenarios:

 

a)One result has three exceptions with the following qualifiers:

i.Exception 1:  qualifier = J;  reason code = RC1;  remark = remark one

ii.Exception 2:  qualifier = U;  reason code = RC2;  remark = remark two

iii.Exception 3:  qualifier = J;  reason code = RC3;  remark = remark three

b)One result has two exceptions with the following qualifiers:

i.Exception 1:  qualifier = U;  reason code = RC1;  remark = remark one

ii.Exception 2:  qualifier = B;  reason code = RC2;  remark = remark two

c)One result has three exceptions with the following qualifiers:

i.Exception 1:  qualifier = U;  reason code = RC1;  remark = remark one

ii.Exception 2:  qualifier = J;  reason code = RC2;  remark = remark two

iii.Exception 3:  qualifier = R;  reason code = RC3;  remark = remark three

 

In the table below, “Apply Q”, “Apply RC”, and “Apply Remark” refer to those columns on the Review All Results tab of the Process Event screen, and “Warning” refers to that column on the Errors tab of the Process Event screen.

 

merge_qualifiers

TRUE

FALSE

FALSE

FALSE

merge_equal_ranks

Either

MERGE

MERGE

WARNING

merge_ranked_reason_codes

Either

ALL

EQUAL ONLY

EQUAL ONLY

merge_ranked_remarks

Either

ALL

EQUAL ONLY

EQUAL ONLY

Scenario a)

J, U, J

J, U, J

J, U, J

J, U, J

Apply Q

UJ

U

U

U

Apply RC

RC1 : RC2 : RC3

RC1 : RC2 : RC3

RC1 : RC3

RC1 : RC3

Apply Remark

merged:
remark one:
remark two:

remark three

merged:
remark one:
remark two:
remark three

merged:
remark one:
remark three

merged:
remark one:
remark three

Warning

---

---

---

More than one qualifier - J,J - with the same
rank applied to a result. Qualifiers were
merged based on Global Parameter: merge_equal_rank = WARNING.

Scenario b)

U, B

U, B

U, B

U, B

Apply Q

UB

UB

UB

UB

Apply RC

RC1 : RC2

RC1 : RC2

RC1 : RC2

RC1 : RC2

Apply Remark

merged:
remark one:

remark two

merged:
remark one:
remark two

merged:
remark one:
remark two

merged:
remark one:
remark two

Warning

---

---

---

More than one qualifier - U,B - with the same
rank applied to a result. Qualifiers were
merged based on Global Parameter: merge_equal_rank = WARNING.

Scenario c)

U, J, R

U, J, R

U, J, R

U, J, R

Apply Q

UJR

R

R

R

Apply RC

RC1 : RC2 : RC3

RC1 : RC2 : RC3

RC1

RC1

Apply Remark

merged:

remark one:

remark two:

remark three

merged:

remark one:
remark two:

remark three

remark one

remark one

Warning

---

---

---

---