DQM (23.1)

DQM – Allow Export/Import Third Party Validated Data in a DQM Event [d24599]

Added support for third party validations to DQM. A DQM Event can be exported for third party validation and re-imported from the new Third Party Validations tab of the DQM Event Review Form.

DQM – Holding Times Check Includes New 'comparison_unit' Parameter [d25712]

A new parameter comparison_unit has been added to the Holding Times Check. The new check parameter can be used to compare holding times using the unit in RT_HOLDING_TIME.HT_UNIT. When comparison_unit is "minutes", all holding times will be converted to minutes before comparing HoldTime to QC_HoldTime. When comparison_unit is "ht_unit" and the unit in RT_HOLDING_TIME.HT_UNIT is Hours, Days, or Months then the holding time will be exceeded after the end of the last hour, day, or month, respectively.

We recommend updating QAPPs (https://help.earthsoft.com/dqm-update-existing-qapps.htm) to add the new parameter and republishing the report (EarthSoft.Reports.Library.63867.dll) to the database, following these instructions: https://help.earthsoft.com/pro_report-publisher.htm.

DQM – Populate ASSO_EX_SAMPLE with QC Sample that Caused Exception [d26152]

For associated results, DQM will populate DT_RESULT_DQM.ASSO_EX_SAMPLE with the SYS_SAMPLE_CODE of the QC sample that caused the sample to be qualified.

DQM – QAPP Specific Qualifier and Reason Code Rankings [d26443]

DQM qualifiers and reason codes and their rankings are now QAPP specific. The new QAPP specific RT_DQM_QUALIFIER table replaces the RT_QUALIFIER table for DQM.

DQM Event Report (Grid) – New Report [d25828]

Added a new 'DQM Event Report (Grid)' report to output DQM Event Report sections as grid reports.

We recommend republishing the report (EarthSoft.Reports.Library.63867.dll) to the database, following these instructions: https://help.earthsoft.com/pro_report-publisher.htm.

DQM Event Review Form – Added LAB_SAMPLE_ID to Grids [d25983]

The field DT_TEST.LAB_SAMPLE_ID has been added to the grids on the DQM Event Review Form.

DQM Export Event Form – Additional Fields Not Selectable [d26064]

Fixed a bug in the DQM Export Event Form that prevented additional fields from being selected unless a report was open in Professional.

DQM In Process Events Form – 'Reviewer' in SDG Status Tab Populates with 'PERSON_NAME - COMPANY_CODE' [d26357]

Fixed a bug in the DQM In Process Events Form SDG Status tab that caused some existing values in DT_SDG.DATA_REVIEW_COMPANY to be ignored and potentially overwritten.

DQM-refvals Format and DQM Starter QAPP EDD – Updated to Include Schema Changes [d26644]

The DQM-refvals.zip format and DQM Starter QAPP (DQM Starter QAPP.xlsx) have been updated to include the new holding times check comparison_unit parameter, the DQM_QAPP_CODE and REASON_CODE_RANK columns to RT_DQM_REASON, and the new RT_DQM_QUALIFIER table.

Schema – DQM – New Field ASSO_EX_SAMPLE to DT_RESULT_DQM [d26352]

Added new field ASSO_EX_SAMPLE to DT_RESULT_DQM.

Schema – DQM – QAPP Specific DQM Qualifiers and Reason Codes [d26361]

To facilitate QAPP-specific DQM Qualifiers and Reason Codes, the following changes were made to the DQM Schema:

New DQM_QAPP_CODE column in RT_DQM_REASON.
New RT_DQM_QUALIFIER table.
Modified foreign keys and added a script to add a set of rows for each DQM_QAPP_CODE in RT_DQM_RULE.