DQM Metrics by Company Report

Report Name: DQM Metrics by Company

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 Metrics by Company report compiles information from database tables that can be used to assess the DQM validated and qualified results metrics by sampling company 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_SAMPLE, DT_RESULT, and DT_TEST 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_SAMPLE, DT_RESULT, DT_TEST

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
LOADED_RESULTS	SUM OF FACILITY_CODE, YEAR(DT_SAMPLE.SAMPLE_DATE), DT_SAMPLE.MATRIX_CODE, SAMPLING_COMPANY_CODE, ANALYTIC_METHOD and LAB_NAME_CODE
VALIDATED_RESULTS	SUM OF FACILITY_CODE, YEAR(DT_SAMPLE.SAMPLE_DATE), DT_SAMPLE.MATRIX_CODE, SAMPLING_COMPANY_CODE, ANALYTIC_METHOD and LAB_NAME_CODE when DT_RESULT.VALIDATED_YN = ‘Y’
QUALIFIED_RESULTS	SUM OF FACILITY_CODE, YEAR(DT_SAMPLE.SAMPLE_DATE), DT_SAMPLE.MATRIX_CODE, SAMPLING_COMPANY_CODE, ANALYTIC_METHOD and LAB_NAME_CODE when LEN(DT_RESULT.DQM_QUALIFIERS) > 0

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.