Getting Started with DQM
Copyright © 2018 EarthSoft, Inc • Modified: 12 Dec 2018
The Data Qualification Module (DQM) is organized around a primary key field, DQM_QAPP_CODE, which allows all of the DQM checks, rules, and parameters to have different values for different agencies, regions, individual QAPPs, etc. For each DQM_QAPP_CODE uploaded or copied, the user can modify the parameters, qualifiers, and remarks associated with each check/rule in DQM Settings. Note that control limits in the RT_DQM_CONTROL_LIMITS table defines QAPP-specific control limits for certain checks.
Every DQM QAPP must have a Global Parameters "Check". The Global Parameters check holds the parameters used by all other checks within a given DQM QAPP and can be easily modified in the Parameters tab of the DQM Settings form. The Global Parameters check is not listed in the Check menu on the DQM Create Event form because it does not run an actual check.
Each DQM event is a review of an analytical results dataset (such as the lab results reported for a given Lab SDG).
•The review begins with Creating a DQM event, which runs a selected dataset through one or more or all of the automated checks for the selected DQM QAPP Code.
•The review continues with Processing a DQM Event, which displays results in the Event Summary, Exceptions by Check, Review All Results, Results by Sample, and Errors tabs. At this stage, the DQM event is available for future reference and to edit at a later time, without saving changes to results.
DQM must be installed and configured prior to usage. DQM only needs to be installed one time. Prior to creating a DQM event, complete all of the installation steps described here.
Note: If a previous version of DQM has already been installed, it is still necessary to proceed with these steps. A couple of additional considerations are detailed at the bottom of this page.
The installation of DQM is a three-step process:
1.Install the DQM application files during the custom setup step,
2.Publish the DQM report .dll file (EarthSoft.Reports.Library.63867.dll) to the EQuIS database, and
3.Apply the DQM Schema to the EQuIS database. Steps 2 and 3 must be performed for each EQuIS database that will utilize DQM.
To install DQM, select the DQM Module during the installation of EQuIS Professional Version 6.2 or later. If EQuIS Professional is already installed, the installer can be run again to add the DQM Module.
When complete, verify that EarthSoft.Reports.Library.63867.dll is in the EQuIS Professional folder (e.g., C:\Program Files\EarthSoft\EQuIS). Publish the EarthSoft.Reports.Library.63867.dll to the database. Instructions for publishing reports such as this can be found in the Report Publisher help article.
Update the database with Schema.DQM.xme. Follow the steps for SQL in the Database Update with SQL Server help article.
A DQM QAPP EDD can be created and uploaded into the EQuIS database via Professional EDP. When creating a DQM QAPP EDD, utilize the template file DQM_checks_v7.0.xlsx (typically located in C:\Program Files\EarthSoft\EQuIS\Formats\DQM).
Review and modify the template file, based upon the actual project requirements. Perform the following steps to create the new DQM QAPP EDD:
1.Locate the DQM Checks EDD (DQM_checks_v7.0.xlsx) and save the file with a new name that contains the name of the project or DQM QAPP.
2.Decide which QAPP Codes will be needed. For example, Radio Chemistry Data Checks may not be needed. On the worksheet RT_DQM_QAPP, populate the DQM_QAPP_CODE with the name of the DQM QAPP. Populate the other fields in the worksheet as desired. Multiple DQM QAPP codes can be defined in the same spreadsheet.
3.Modify each tab of the EDD to match the new QAPP Codes by deleting rows and modifying data as necessary. (Hint: A global Find and Replace with the "Within" option set to "Workbook" is best for changing the DQM_QAPP_CODE). Continuing with the above example, the RT_DQM_CHECK tab would be changed as shown below.
Note: In the DQM forms, any list of checks will display the DQM_CHECK_DESC column. Thus, there are a couple of things to consider:
•The checks can be displayed in a language other than English by changing the DQM_CHECK_DESC column.
•Although the DQM_CHECK_DESC column will accept 255 characters, DQM forms only display about
•If the DQM_CHECK_DESC column is blank, the user will get an error when trying to select checks to Create an Event.
4.On the worksheet RT_MATRIX, populate the MATRIX_CODE and MATRIX_DESC with all the field matrices that are applicable to the project.
5.Review and modify all qualifiers specified on the RT_DQM_RULE tab.
6.Review and modify all parameters specified on the RT_DQM_CHECK_PARAM tab.
7.Review and modify the holding time limits on the RT_HOLDING_TIME tab and the control limits on the RT_DQM_CONTROL_LIMITS tab by referring to the DQM Control Limits help article.
8.Save the file.
9.The next step is to load the modified DQM Checks EDD file to the EQuIS database using EDP. On the EQuIS Professional Home ribbon, select the EDP button.
10.Click the Format button and select DQM-refvals.zip from the installed DQM files, typically located in \Programs Files\EarthSoft\EQuIS\Formats\DQM.
11.Select the EDD button.
12.Select the modified DQM Checks EDD created in the above steps.
13.Create and Commit the EDD.
Note: For updating an existing DQM install, load the latest DQM_Checks EDD using the Insert and Update commit type.
Users with ALS Admin permissions have access to DQM as shown by the DQM buttons being enabled on the ribbon. (Remember the DQM DLL must first be published to the database).
Use the following instructions to make DQM available to users without ALS Admin permissions:
1.Give the user Owner permission to the published DQM Report - DQM Exceptions Report by EDD. This enables all of the DQM buttons, except for Create Event.
2.Give the user Creator permission to Reports. This also enables the Create Event button.
3.For DQM Settings to be edited, the database user (called by the ALS connection role assigned to the DQM user) must be granted SELECT, INSERT, UPDATE, and DELETE permissions on the tables listed in the next item.
4.For DQM Settings to be read-only, the database user (called by the ALS connection role assigned to the DQM user) should only be granted SELECT permissions on the tables listed below.
If a previous version of DQM has already been installed, here are a couple of additional considerations:
1.If the Qualification Report button still shows up in the DQM ribbon toolbar do the following:
b.Find and delete the following XML file: \Users\<user>\AppData\Roaming\EarthSoft\EarthSoft.EQuIS.Toolbar.en-US.6.6.0.xxxxx.xml
2.To use QAPP Settings already uploaded, add the following record to RT_DQM_RULE for each QAPP Code you wish to continue using:
a.DQM_QAPP_CODE = <existing qapp code>
b.DQM_CHECK = 'EarthSoft.DQM.GlobalParameters'
c.DQM_RULE = 'Manually Entered Apply Qualifier'
d.REMARK = 'This rule is used to create the DQM_RULE_ID for manually entered Apply Qualifiers.'