DQM Exceptions Report by EDD

Report Name: DQM Exceptions Report by EDD (previously Data Quality Module (DQM) Qualification Report) (example)

File Name: EarthSoft.Reports.Library.63867.dll

Dependencies: Licensed DQM and DQM Schema

Software: EQuIS DQM, EQuIS Professional

Source: EQuIS Professional install (DQM)

Language: English

Output Type: User-specified (EIA input parameters)

Description: The DQM Exceptions Report by EDD can be used to determine if a data submittal may have data quality issues that deserve immediate attention and may be scheduled as an EQuIS Information Agent (EIA). This update is part of the new DQM Workflow, where the options for Exporting DQM Event Data to Excel replace any need for the previous Qualification Report.

Installation Instructions: This report requires a licensed EQuIS DQM and the DQM Schema applied to the database. The report is included in the EQuIS Professional install when the DQM feature has been enabled during installation. For Enterprise use, the EarthSoft.Reports.Library.63867.dll assembly must be copied into the Enterprise bin directory.

Overview:

Use DQM Exceptions Report by EDD as an EIA

Admin Setup

1.Publish the EarthSoft.Reports.Library.63867.dll to the database (necessary to use DQM).

2.Make sure the dll is not blocked or read-only.

3.Add EarthSoft.Reports.Library.63867.dll to the Enterprise bin folder (necessary to use DQM in Enterprise).

Report

1.Create an EZView Widget in Enterprise from this report, and select to Enable Agent.

2.Select the DQM QAPP Code and Checks on the Data tab.

3.On the EQuIS Information Agent tab, select Limit report to only data within the EDD (i.e. new data).

Note: The EIA process does not, in any way, substitute for an actual DQM data validation.

Data Requirements: All of the RT_DQM_... tables must be populated with values for at least one DQM_QAPP

Source Tables DT_FACILITY, DT_SAMPLE, DT_TEST, DT_RESULT, DT_RESULT_QC, DT_FIELD_SAMPLE, DT_CHAIN_OF_CUSTODY, AT_TEST_BATCH_ASSIGN, DT_SAMPLE_PARAMETER, RT_ANALYTE, RT_MATRIX, RT_UNIT, RT_MTH_ANL_GROUP, RT_MTH_ANL_GROUP_MEMBER, RT_DQM_QAPP, RT_DQM_RULE, RT_DQM_CHECK, RT_DQM_CHECK_PARAM, RT_DQM_CHECK_PARAM_TYPE, RT_DQM_CONTROL_LIMITS, RT_DQM_STATUS, ST_USER

Report Parameters *

Result Selection Limitation
MAG: (Optional)	Select a method analyte group for this report.
Check Selection
DQM_QAPP_CODE: (required)	Select the desired DQM_QAPP_CODE.
Checks: (required)	Select the desired qualification check(s).
Types: (Only used for Holding Time check; required)	Select type(s) of holding time.
EDD Ebatch Number: (required)	Enter an EBATCH number to run this report.

* This report includes the following hidden parameter(s) that could affect the output of the report:

•chain_of_custody

•facility_id

•field_sdg

•FieldQualityComment

•lab_sdg

•only_UN

•sample_code

•sample_type

•task_code

•test_batch_id

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.