DQM Qualified Results Metrics Report

Report Name: DQM Qualified Results Metrics

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

Dependencies: Licensed DQM and DQM Schema

Software: EQuIS DQM, EQuIS Professional

Source: EarthSoft Community Center > Downloads Dashboard > Products > Data Governance

Language: English

Output Type: Report Grid1

Description: The DQM Qualified Results Metrics report compiles information from database tables that can be used to assess the status of analytical data results qualified with DQM as part of EQuIS data governance.

Installation Instructions: This report requires a licensed EQuIS DQM and the DQM Schema applied to the database. The DQM Metrics by Company report (EarthSoft.Reports.Library.d41585.dll) is available for download in the Products\Data Governance folder on the Downloads Dashboard on the EarthSoft Community Center. Copy the DLL file to the EQuIS Professional installation folder. For standard installations, this directory is C:\Program Files\EarthSoft\EQuIS; for per-user installations, this directory is %localappdata%\Programs\EarthSoft\EQuIS by default.

For Enterprise use, this report should be published to the database. When publishing the report, the assembly should be stored in the database. The report will be available for selection once it has been published.

Overview: The report output is generated for the selected date range (see below Parameters table) pulling DQM-related data from the DT_FACILITY, DT_FIELD_SAMPLE, DT_RESULT, DT_SAMPLE, DT_TEST, RT_ANALYTE, RT_DQM_RULE, and DT_RESULT_DQM tables. The Report Output section below details the fields in the report and the source/calculation of fields.

Tables: DT_FACILITY, DT_FIELD_SAMPLE, DT_RESULT, DT_SAMPLE, DT_TEST, RT_ANALYTE, RT_DQM_RULE, DT_RESULT_DQM

Report Parameters

End Date	End date of DT_SAMPLE.SAMPLE_DATE to fetch the report.
Last Month(s)	The previous number of months to search.

Report Output:

Report Output	Data Mapping	Remark
FACILITY_CODE	DT_FACILITY.FACILITY_CODE
S_YEAR	YEAR(DT_SAMPLE.SAMPLE_DATE)	Year of sample date
MATRIX_CODE	DT_SAMPLE.MATRIX_CODE
SAMPLING_COMPANY_CODE	DT_FIELD_SAMPLE.SAMPLING_COMPANY_CODE or ‘UNKNOWN’	Select DT_FIELD_SAMPLE.SAMPLING_COMPANY_CODE if not null, else ‘UNKNOWN’
ANALYTIC_METHOD	DT_TEST.ANALYTIC_METHOD
LAB_NAME_CODE	DT_TEST. LAB_NAME_CODE or DT_TEST.ANALYTIC_METHOD	Select DT_TEST. LAB_NAME_CODE if not null, else DT_TEST.ANALYTIC_METHOD
SAMPLE_TYPE_CODE	DT_SAMPLE.SAMPLE_TYPE_CODE
CHEMICAL_NAME	RT_ANALYTE.CHEMICAL_NAME
RESULT_TYPE_CODE	DT_RESULT.RESULT_TYPE_CODE
VALIDATED_YN	DT_RESULT.VALIDATED_YN
DQM_CHECK	RT_DQM_RULE.DQM_CHECK
DQM_RULE_ID	DT_RESULT_DQM.DQM_RULE_ID
DQM_RULE	RT_DQM_RULE.DQM_RULE
QUALIFIER	RT_DQM_RULE.QUALIFIER
REASON_CODE	RT_DQM_RULE.REASON_CODE
APPLY_QUALIFIER	DT_RESULT_DQM.APPLY_QUALIFIER
APPLY_REASON_CODE	DT_RESULT_DQM.APPLY_REASON_CODE

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer. Excel report output requires a valid license of Microsoft Excel to view the output.