Changing DQM Settings

<< Click to Display Table of Contents >>

EQuIS 7  >>  Professional > Modules > DQM >

Changing DQM Settings

After a DQM QAPP EDD has been committed to the EQuIS database, DQM settings can be changed further. Configure checks, rules, parameters and qualifier to meet specific project data validation objectives. Note that the Global Parameters check holds the parameters used by all of the other checks. See DQM Global Parameters for a description of each Global Parameter.

 

To open the DQM Settings tab:

1.Select a Premier Data license and navigate to the Data tab.

2.Select DQM Settings.

DQM_Ribbon

 

The DQM Settings window has three tabs—Checks, Qualifiers, and Tools.

 

Checks Tab

 

Select a DQM_QAPP_CODE in the pull-down menu labeled DQM_QAPP. The menu comes from the RT_DQM_QAPP table.

DQM_QAPP_drop-down_on_Settings

Select a check in the pull-down menu labeled Check. The menu comes from the RT_DQM_CHECK table.

DQM_Check_drop-down_Settings

Rules Tab

 

Each rule has its own qualifier, which can be selected from the drop-down list on this tab. New qualifiers can be added in the Qualifiers tab explained below. The ND_QUALIFIER is used as the DQM_QUALIFIER and APPLY_QUALIFIER during the DQM "Create Event" step when any Exception or Associated Result is non-detect (i.e. DETECT_FLAG = 'N').

dqm.qualifiers.tab

 

Note: The QUALIFIER and ND_QUALIFIER columns cannot be NULL without creating an error during the Save Event step. To "turn off" a qualifier, set the STATUS_FLAG = 'R' for that rule or set the qualifier to 'NQ' and batch delete the NQ qualifiers during review. (DQM will be modified in future versions to set the APPLY_QUALIFIER to NULL for all NQ qualifiers).

 

The Remark column is also available for editing. The remark describes what each rule does and is stored in the DQM_REMARK column of the DT_RESULT table when a result record is qualified.

DQM.remark.column

 

Parameters Tab

 

Within the Parameters tab, the user can modify and add to the parameters for each check (which are stored in the RT_DQM_CHECK_PARAM table). The Parameter and Value fields are required.

 

The Analytic Method, Analyte, and MAG columns allow multiple values to be entered for specific methods and/or analytes for some parameters (as specified in the documentation for each DQM check). Use the values to define the scope of the parameter. Leave the Analytic Method, Analyte, and MAG null to assign the value to any and all Analytic Methods, Analytes, and MAGs or use the pull-down for each field to select a specific item or group.

 

DQM-analytic_method_parameters

 

Note: The Holding Times Check is a special case. If it is selected, an additional HoldingTimeParameters tab will appear that allows the RT_HOLDING_TIME table to be edited directly from the Settings screen. ANALYTIC_METHOD, MEDIUM_CODE, HT_UNIT, and CALCULATION_UNIT are required. The Holding Times Check will only be applied to the time frames that have a value in the respective column.

 

DQM_holding.times.check

 

Qualifiers Tab

 

Qualifiers can be added and edited on the Qualifiers tab of the DQM Settings Form.

 

Populating the Rank column with a '99' will disable the merge option that prevents duplicates. For example, with the settings in the image below, merging 'B' and 'BL' would result in a qualifier of 'BBL' instead of 'BL'.

DQM.qualifiers-rank

 

Tools Tab

 

Copying a DQM_QAPPs Set of Checks and Rules

 

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. To make a copy of a set of checks and rules:

Select the Tools tab.

Select the DQM_QAPP to copy.

Enter the new Code, Description, and Remark.

Click Save.

Return to the Checks tab and select the new DQM_QAPP_CODE to change the settings.

DQM_QAPP_Tools

 

An alternate way to add a new DQM_QAPP_CODE is to make a copy of the DQM_Checks EDD used during the installation process, make the desired changes in Excel (do not forget to change the DQM_QAPP_CODE column in every worksheet), and load the new set of Checks using EDP.

 

Set NULL Values in VALIDATED_YN to 'N'

 

The DT_RESULT.VALIDATED_YN field should be filled in by most formats, but it is not a required field. To use the "Only return Unvalidated Results" option in the DQM Qualification Report, this field cannot include any NULL values. The Set All NULL VALIDATED_YN to 'N' button inserts a "N" value into any NULL valued DT_RESULT.VALIDATED_YN record.

DQM_Settings_tool_set_button