DQM Check for Holding Times

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM > DQM Checks >

DQM Check for Holding Times

The DQM Holding Times Check identifies holding times that fall outside Quality Control (QC) limits based on the check rule and parameter details outlined below.

 

Check

 

The RT_DQM_CHECK.DQM_CHECK value is EarthSoft.DQM.HOLDINGTIMES = Holding Times

 

Values from RT_HOLDING_TIME are found by searching for the following matches:

RT_HOLDING_TIME.ANALYTIC_METHOD = DT_TEST.ANALYTIC_METHOD.

RT_HOLDING_TIME.MEDIUM_CODE = RT_MATRIX.MEDIUM_CODE where RT_MATRIX_CODE = DT_SAMPLE.MATRIX_CODE.

 

Notes:

It is important for RT_MATRIX.MEDIUM_CODE to be populated for all MATRIX_CODEs being used in the data.

The RT_HOLDING_TIME.HT_UNIT must be plural (e.g., "Days") while the RT_HOLDING_TIME.CALCULATION_UNIT must be singular (e.g., "Day"). These unit reference values are therefore added with the DQM Schema.

 

Holding Time Type(s) must be selected in the DQM report parameters for this check to run (shown below).

DQM_Types

 

Parameters

 

This Check uses the Global Parameters of REPORTABLE_RESULT, RESULT_TYPE_CODE, and TEST_BATCH_TYPE.

 

There are two parameters specific to this Check:

1.GrossRejectFactor – The multiplier used to determine when a gross exceedance of the holding time has occurred. No default. RT_HOLDING_TIME.GROSS_REJECT_FACTOR is used if an empty value is provided. If RT_HOLDING_TIME.GROSS_REJECT_FACTOR is also NULL, then the Gross Reject Factor = 1.

a.If GrossRejectFactor is not populated, then the RT_HOLDING_TIME.GROSS_REJECT_FACTOR is used.

b.If RT_HOLDING_TIME.GROSS_REJECT_FACTOR is also NULL, then the Gross Reject Factor = 1.

2.useRuleQualifiers* – Defaults to "Y". If useRuleQualifiers = "Y", the qualifiers are taken from RT_DQM_RULE. Otherwise, the qualifiers in RT_HOLDING_TIME are used.

 

Notes:

The default value is used if there is no record in RT_DQM_CHECK_PARAM for an input parameter.

The default value is used if the PARAM_VALUE is NULL for this parameter in RT_DQM_CHECK_PARAM.

 

Rules

 

There are four rules:

1.GROSS_QUALIFIER_HIT = Qualify a detected result if HoldTime >= QC_HoldTime * GrossRejectFactor.

2.GROSS_QUALIFIER_NON_DETECT = Qualify a non-detect result if HoldTime >= QC_HoldTime * GrossRejectFactor.

3.QUALIFIER_HIT = Qualify a detected result if HoldTime >= QC_HoldTime.

4.QUALIFIER_NON_DETECT = Qualify a non-detect result if HoldTime >= QC_HoldTime.

 

For each Holding Time Type, two dates are compared to get a HoldTime value and then that value is compared to the QC_HoldTime value as shown in the Rule equations below.

1.Collection To Prep – For HoldTime, compare LEACHATE_DATE to PREP_DATE if LEACHATE_DATE is populated. Otherwise, compare SAMPLE_DATE to PREP_DATE. Use RT_HOLDING_TIME.COLLECT_PREP as QC_HoldTime.

2.Prep To Analysis – For HoldTime, compare PREP_DATE to ANALYSIS_DATE. Use RT_HOLDING_TIME.PREP_ANALYSIS as QC_HoldTime.

3.Collect To Analysis (Unpreserved) – For HoldTime, compare LEACHATE_DATE to ANALYSIS_DATE if LEACHATE_DATE is populated. Otherwise, compare SAMPLE_DATE to ANALYSIS_DATE. Use RT_HOLDING_TIME.COLLECT_ANALYSIS_UNPRESERVED as QC_HoldTime.

4.Collect To Analysis (Preserved) – For HoldTime, compare LEACHATE_DATE to ANALYSIS_DATE if LEACHATE_DATE is populated. Otherwise, compare SAMPLE_DATE to ANALYSIS_DATE. Use RT_HOLDING_TIME.COLLECT_ANALYSIS_PRESERVED as QC_HoldTime.

5.TCLP Collect To Leachate – For HoldTime, compare SAMPLE_DATE to LEACHATE_DATE. Use RT_HOLDING_TIME.COLLECT_LEACHATE as QC_HoldTime.

6.TCLP Leachate to Prep – For HoldTime, compare LEACHATE_DATE to PREP_DATE. Use RT_HOLDING_TIME.LEACHATE_PREP as QC_HoldTime.