DQM Exceptions Report by EDD

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports with Module Purchase > Standard with DQM Module >

DQM Exceptions Report by EDD

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

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 scheuled 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.

 

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 Seletion


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

Enter an eBatch number to run this report.