DQM Check for Holding Times
Copyright © 2019 EarthSoft, Inc • Modified: 05 Aug 2019
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.
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.
•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.
•Calculations are to the minute, regardless of holding time unit.
Holding Time Type(s) must be selected in the DQM report parameters for this check to run (shown below).
This Check uses the reportable_result and test_batch_type parameters from Global Parameters.
There are four other 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".
a.If useRuleQualifiers = "Y", the qualifiers are taken from RT_DQM_RULE.
b.Otherwise, the qualifiers in RT_HOLDING_TIME are used.
a.defaults to "N"
a.defaults to "TRG"
•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.
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.
The RT_HOLDING_TIME table defines QAPP-specific control limits = QC_HoldTime in the above equations.
The Holding Times Check has the following Holding Time Types which look up the Holding Time Limit (QC_HoldTime) in the indicated column:
•Collect to Prep - collect_prep column
•Prep to Analysis - prep_analysis column
•Collect to Analysis (Unpreserved) - collect_analysis_unpreserved column
•Collect to Analysis (Preserved) - collect_analysis_preserved column
•TCLP Collect to Leachate - collect_leachate column
•TCLP Leachate to Prep - leachate_prep column
Note: Enter 999 in any column to skip that Holding Time Type for that particular Analytic Method / Medium Code combination. A NULL value will cause an error to be displayed in the Errors tab when the check is run for that Holding Time Type.