DQM – Blank Checks Messages Incorrectly Hard Coded to Quantitation Limit [d27912]
Updated
Blank Contamination Checks so that if the selected NONDETECT_DETECTION_LIMIT (QUANTITATION_LIMIT, METHOD_DETECTECTION_LIMIT, MINIMUM_DETECTABLE_CONC, or the
REPORTING_DETECTION_LIMIT) is missing or NULL, error messages will no longer
only indicate that the Quantitation Limit is missing.
DQM – Checks Not in Alphabetic Order in Dropdown List [d27906]
For In Process Events, checks displayed in the View Exception by Check dropdown are now sorted in alphabetical order.
DQM – Complete Event Form – Zeros After Decimal Point Removed When Copying Data into REPORTING_DETECTION_LIMIT [d28041]
Updated the DQM Complete Event Form so that trailing zeros are no longer removed from values in RESULT_TEXT when Set Detection Limit = RESULT_TEXT.
DQM – Delete Event Button Now Deletes Corresponding Records in DT_RESULT_DQM [d28292]
Updated the Delete Event button in the DQM In Process Events form and DQM History form to also delete corresponding records in DT_RESULT_DQM.
DQM – Event SQL Queries Need to be Standardized [d28924]
Standardized DQM Queries to improve the updating process.
DQM – Improve Save Event Button to Allow Frequent Saving [d28170]
Updated DQM to allow frequent saving without reloading the event.
DQM – RPD Field – Non-Detect Sample Results Should Either Stop or Fail Checks or Additional Tests [d27433]
Fixed
an exception that could occur in the Relative Percent Difference (Laboratory
Duplicates), Relative Percent Difference - Field, and Dissolved vs
Total checks if both results were non-detect. Also fixed an exception that
could occur for the wrong rule if only
one of the results were non-detect.
DQM – Spike Recovery Check Uses QC_SPIKE_RECOVERY Over QC_DUP_SPIKE_RECOVERY for Duplicate Samples [d28548]
Fixed a bug in the Spike Recovery Check in Data Quality Module (DQM) to check QC_DUP_SPIKE_RECOVERY (or both QC_DUP_SPIKE_ADDED and QC_DUP_SPIKE_MEASURED) before QC_SPIKE_RECOVERY (or both QC_SPIKE_ADDED and QC_SPIKE_MEASURED) for duplicate samples.
DQM – Starter QAPP EDD and DQM-refvals Format – Updated Blank Contamination Descriptions [d29448]
Updated the DQM-refvals.zip format and DQM Starter QAPP (DQM Starter QAPP.xlsx). They now include more accurate descriptions of the Blank Contamination Checks in the REASON_CODE_DESC and REMARK columns for the RT_DQM_REASON and RT_DQM_RULE tables, respectively.
DQM – Third Party Validation Tab Not Populating Third Party Columns [d27748]
Updated
the Third Party Validation Tab in the DQM Event Review Form so that associated
Third Party columns populate after importing third party validations.
DQM Event Form – Completed Events Throw an Error [d27859]
Updated
the DQM Event Report to prevent an error if the selected DQM Event is a
completed event.
DQM Event Report – Exceptions by Reason Codes [d29323]
Updated DQM with the ability to display Exceptions by Reason Code in a separate worksheet or in a single worksheet sorted by Reason Code.
DQM Save Event – Holding Time Types Lost Due to Truncated Text [d28871]
Improved visibility of Holding Time Check when DQM Event is saved.
DQM Settings – Add Parameter Erroneously Populates Analyte Column [d28970]
Updated DQM Settings Form to populate the Analyte column with a blank value by default when adding a Parameter.
DQM Settings Form – Disabled QAPPs in Drop-down List [d27926]
Updated the DQM Settings Form to prevent disabled QAPPs (i.e., RT_DQM_QAPP.STATUS_FLAG = 'R') from appearing in the DQM_QAPP drop-down list.
DQM Surrogate Recovery Check – Calculated Value used in Comparison not included in REMARK [d27437]
Fixed a bug in DQM for the Surrogate Recovery Check where the Evaluated Value used in a comparison would not be shown in the Remark if QC_SPIKE_RECOVERY was blank.