Answer: DQM only evaluates the data for the analytical methods contained in the dataset for which the analytical methods are also configured in the selected DQM QAPP.
Click the down arrow in the QUALIFIER or ND_QUALIFIER column to display all of the qualifiers with STATUS_FLAG = ‘A’ in RT_QUALIFIER.
Answer: The REMARK column in the RT_DQM_RULE is the remark that is placed in the APPLY_REMARK column after an Event is created (if an exception to the rule is encountered); this remark can be edited for each DQM QAPP. When the Event is completed, this remark is written into the DQM_REMARK column of DT_RESULT to document the specific reason for the application of a qualifier. (The REMARK column in RT_QUALIFIER is not used by DQM).
Answer: The US EPA National Functional Guidelines include a list of data validation qualifiers, including the “J” qualifier. The “J” qualifier is defined in this document as “The result is an estimated quantity”. There are many reasons that the “J” validation qualifier is prescribed to be used by the data validation guidelines, and therefore there are many DQM rules that the “J” qualifier could be applied if a rule exception is encountered. If your project requirements differ, simply change the qualifiers in your DQM QAPP to match the requirements of your project.
Example: Depending on which exception DQM finds first, either UJ or JU is returned (within the same dataset) – is there a way to force DQM to always output UJ and never JU?
Answer: Qualifiers can be ranked in RT_QUALIFIER by populating DQM_CHECK_RANK. The lower the number, the higher the ranking. Additionally, there are several parameter values that require consideration and population in RT_DQM_CHECK_PARAM for the global parameters check in the DQM QAPP EDD. For additional details, see Ranking Qualifiers and Reason Codes and DQM Settings > Qualifiers Tab.
We have a feature request with our development team to add greater control on the merger of qualifiers to a future build of DQM. Currently, order of the qualifiers when merging can be forced when the combination itself exists in RT_QUALIFIER. For example, if there is J, U, and UJ in the RT_QUALIFIER table, the merge of J and R will be UJ, not JU. If there are common combinations wanted in a certain order (such as UJ), please add those combinations to the RT_QUALIFIER table.
Answer: DQM functionality includes several configuration options for ranking qualifiers and reason codes to allow you to define the data qualification hierarchy appropriate for your project needs. Details on ranking qualifiers and reason codes can be found here.
Answer: For the existing DQM functionality to work as designed, none of the DQM Rules can be changed. Only the QUALIFIER, ND_QUALIFIER, and REMARK columns can be changed in a new DQM QAPP EDD by uploading the EDD into EQuIS or by reconfiguring these fields directly in the DQM Settings Form.
Copyright © 2022 EarthSoft, Inc • Modified: 17 Feb 2022