DQM – Reason Code Footnotes in Validation Report List All Combinations [d33846]
When exporting a DQM event, the Validation Report will now check each pipe-separated Reason Code before adding Footnotes.
DQM – Third-party Import Improvement [d30829]
Updated the DQM Third Party Validation Import to allow null values in the third_party_qualifier column of the Third Party Validation export. Null values in third_party_qualifier, third_party_reason_code, or third_party_remark columns will be ignored.
DQM Check – Batch Completeness Check – Allow for Some Analytic Methods/Analytes to be Skipped [d33959]
Added option to skip the Batch Completeness Check for specified analytes and/or analytic methods through the QAPP settings.
DQM Check – Holding Time Check – Add 'Leachate to Analysis' Option [d33878]
Added option of "Leachate to Analysis" to the DQM Holding Time Check.
DQM Check – Holding Time Check – Modify to Find Matching Method, Medium, Preservative Record in RT_HOLDING_TIME [d30852]
Updated the DQM Holding Times Check to use PRESERVATIVE—in addition to the ANALYTIC_METHOD, MEDIUM_CODE, and CAS_RN—to match records in the RT_HOLDING_TIME table.
DQM Check – Multiple Checks – Add RESULT_TYPE_CODE and SAMPLE_TYPE_CODE Parameters [d31480]
Added two new parameters RESULT_TYPE_CODE and SAMPLE_TYPE_CODE to several DQM checks to allow running the checks only for specific result and sample types.
Note: The default parameter values listed below refer to the value provided in the DQM Starter QAPP.xlsx file.
The new RESULT_TYPE_CODE parameter defaults to 'TRG' and has been added to the following checks:
- Batch Completeness
- RadChemEstimatedResults
- Repeated Results
- Repeated Results - Two Methods
- Verify Sample Units
- Field Blank Contamination
- Lab Blank Contamination
- Trip Blank Contamination
- Percent Solids
- Preservative
- RadCheckRelativeErrorRatio
The new SAMPLE_TYPE_CODE parameter defaults to 'N' has been added to the following checks:
- Batch Completeness
- RadChemEstimatedResults
- Repeated Results
- Repeated Results - Two Methods
- Verify Sample Units
- Numeric Results
- RPD Lab Field
DQM Check – Multiple Checks – Include Parent Reason Codes with Associated Reason Code [d31358]
Updated Blank Contamination Checks (Field, Lab, and Trip) and the Surrogate Recovery Check to include QA
Sample Exception Reason Code with Associated Exception Reason Code when the Associated Exception Reason Code ends with a "+". When the Associated Exception Reason Code is only "+", it will be replaced by the QA Sample Exception Reason Code instead.
DQM Check – Multiple Checks – Use Medium Code for Control Limits [d31299]
Updated the following DQM Checks to allow control limits to be set for a group of MATRIX_CODEs by entering a value in the MEDIUM_CODE column of one row in the RT_DQM_CONTROL_LIMITS table:
- Field Blank Contamination
- Field Duplicate Relative Percent Difference (RPD)
- Lab Blank Contamination
- Relative Percent Difference
- Required Detection Limit
- Spike Recovery
- Surrogate Recovery
- Trip Blank Contamination
DQM Check – RPD Check – Calculate RPD Using the Concentration for MS/MSD and LCS/LCSD [d31202]
Added a new parameter, "use_conc_for_calc", to the DQM Relative Percent Difference (RPD) check. When use_conc_for_calc = 'Y', DQM will use the concentration QC_ORIGINAL_CONC and QC_DUP_ORIGINAL_CONC to calculate the RPD instead of the spike recovery. The new parameter defaults to 'N'.
DQM Check – Spike Recovery Check – Add Fraction to Associated Results [d31543]
DQM Spike Recovery Check will now use Fraction to find associated records for MS/MSD samples.
DQM Check – Spike Recovery Check – Add Warning Message when RT_ANALYTE.ORGANIC_YN Is Null [d30912]
DQM will now display a warning for the Spike Recovery check indicating when Matrix Spike Recovery results are not processed due to null values in RT_ANALYTE.ORGANIC_YN.
DQM Check – Total vs Dissolved Check – Add Parameter to Compare by Method [d33799]
Updated Dissolved vs Total check to include an analytic_methods parameter to specify which analytic methods are used in the comparison.
DQM Event Report – Add Event Notes to Updated Summary Tab [d31442]
Added "Include Event Notes" parameter to DQM Event Report.
DQM Event Report – Footnote Explanations of Qualifiers [d34071]
Updated the Validation Report to contain a footnote section for qualifiers and their descriptions when exporting a DQM event.
DQM Schema – Added MEDIUM_CODE Column to RT_DQM_CONTROL_LIMITS Table [d30951]
Added MEDIUM_CODE VARCHAR(10) to the RT_DQM_CONTROL_LIMITS table in DQM Schema.
DQM-refvals Format – Added 4 Character Qualifiers and RT_DQM_STATUS, RT_LOOKUP, Reference RT_DQM_QUALIFIER [d30837]
Added
rt_lookup and rt_dqm_status sections to DQM-refvals format.
Updated
character limit to 4 for rt_dqm_rule.qualifier, rt_dqm_rule.nd_qualifier, and
rt_dqm_qualifier.qualifier fields in DQM-refvals format to match what is allowed in the database.
Updated
rt_dqm_rule.qualifer and rt_dqm_rule.nd_qualifier fields to refer to
rt_dqm_qualifer table instead of rt_qualifier in DQM-refvals format. The rt_dqm_rule.nd_qualifier field will be flagged with an error if a corresponding record in rt_dqm_qualifier is missing where rt_dqm_rule.dqm_qapp_code = rt_dqm_qualifer.dqm_qapp_code and rt_dqm_rule.nd_qualifier = rt_dqm_qualifer.qualifier. The same is true for rt_dqm_rule.qualifier.
Updated rt_dqm_qualifier.qualifier to be a lookup column referrencing rt_qualifier.qualifier in DQM-refvals format.
DQM-refvals Format and Starter QAPP EDD – Multiple Updates [d34123]
Updated the DQM-refvals.zip format and DQM Starter QAPP (DQM Starter QAPP.xlsx):
- Added new sections rt_lookup and rt_dqm_status to the starter QAPP and DQM-refvals format.
- Added medium_code column to rt_dqm_control_limits section of starter QAPP and DQM-refvals format.
- Added leachate_analysis to the rt_holding_time_v2 section of starter QAPP and DQM-refvals format.
- Added use_conc_for_calc parameter to the RPD check in the starter QAPP.
- Added analytic_methods parameter to the Dissolved vs Total check in the starter QAPP.
- Added result_type_code parameter to the starter QAPP for the following checks:
- Batch Completeness
- RadChemEstimatedResults
- RepeatedResults
- Repeated Results - Two Methods
- Verify Sample Units
- Field Blank Contamination
- Lab blank Contamination
- Trip Blank Contamination
- Percent Solids
- Preservative
- RadChemRelativeErrorRatio
- Added sample_type_code parameter to the starter QAPP for the following checks:
- Batch Completeness
- RadChemEstimatedResults
- RepeatedResults
- Repeated Results - Two Methods
- Verify Sample Units
- Numeric Results
- RPD Lab Field