DQM Check for Numeric Results
Copyright © 2019 EarthSoft, Inc • Modified: 22 Apr 2019
The DQM Check for Numeric Results verifies sample results do not exceed limits.
Check name is EarthSoft.DQM.NumericResults = Numeric Results.
This check uses the REPORTABLE_RESULT and RESULT_TYPE_CODE parameters from Global Parameters.
As many parameters can be added as are needed.
•The PARAM_CODE can be any value, but each PARAM_CODE must be different since this is a Primary Key field.
•DQM does not use the values in PARAM_CODE in the evaluation; they are just identifiers for the user.
There must be at least one parameter with a numeric value in the PARAM_VALUE ("Value" in the Settings Form) column and with the units specified in the REMARK column. The REMARK column controls this check. The check looks for any results with the same units as those listed in the REMARK column of the parameter.
•The parameter(s) can be renamed if desired, and additional parameters can be added.
•The PARAM_VALUE is the maximum limit for the units listed in REMARK (unless PARAM_VALUE begins with "<").
•Two parameters can be added for the same units to test both greater than and less than values. (They must have different PARAM_CODE values, but the units in the REMARK would be the same).
•The REMARK contains one or more result units.
•PARAM_1.PARAM_VALUE = 1000 and
•PARAM_1.REMARK = mg/g, mg/ml.
•If a result with a unit of mg/g or mg/ml is greater than 1000, then it will be qualified.
There is one rule, and it is NUMERIC RESULTS = qualify a result if:
•DT_RESULT.RESULT_NUMERIC > PARAM_VALUE, or
•DT_RESULT.RESULT_NUMERIC < PARAM_VALUE (when PARAM_VALUE begins with "<").
The result is also qualified and an error is added to the Errors tab of the DQM Qualification Report Form if:
•DT_RESULT.RESULT_NUMERIC is null.
•DT_RESULT.RESULT_UNIT is null.