EIA: LOR Validation Report

Report Name: EIA: LOR Validation

File Name: EarthSoft.Reports.Library.48827.dll* and EarthSoft.Reports.Library.d39109

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

*Note: This report was previously part of the EarthSoft.Reports.Library.48827.dll file. Previously published reports that have 48827 in the filename will still be accessible within EQuIS Professional; however, they will have [Outdated] appended to the filename to differentiate between each location.

Description: The EIA: LOR (Limit of Reporting) Validation report was developed to compare incoming analytical result reporting and method detection limits to expected reporting and method detection limits. The report may be useful as an EDD-triggered EIA.

Installation Instructions: This report requires a licensed SPM and the SPM Schema applied to the database. For SPM usage, no additional steps are necessary. 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 logic relates incoming DT_SAMPLE.SAMPLE_ID values to DT_CHAIN_OF_CUSTODY_MAG.SAMPLE_ID to determine the appropriate METHOD_ANALYTE_GROUP_CODE value, then relates this value to RT_MTH_ANL_GROUP_MEMBER to determine the expected reporting detection limit. This expected value is compared to incoming reporting detection limit and method detection limit values to ensure they are as expected.

This report is setup as an EQuIS Information Agent (EIA) only. Instructions on how to setup EIAs is available here.

Tables: DT_CHAIN_OF_CUSTODY_MAG, DT_RESULT, DT_SAMPLE, DT_TEST, RT_ANALYTE, RT_MTH_ANL_GROUP_MEMBER

Input Parameters *
This report contains no input parameters
* This report contains the following hidden parameter(s) that could affect the outcome of the report: •Facility_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.

Input Parameters *

This report contains no input parameters

* This report contains the following hidden parameter(s) that could affect the outcome of the report:

•Facility_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.

Report Output
FACILITY_CODE SAMPLE_ID SYS_LOC_CODE SYS_SAMPLE_CODE SAMPLE_DATE MATRIX_CODE TEST_ID ANALYTIC_METHOD	ANALYSIS_DATE FRACTION TEST_TYPE CAS_RN CHEMICAL_NAME RESULT_NUMERIC RESULT_TEXT RESULT_UNIT	DETECT_FLAG REPORTING_DETECTION_LIMIT METHOD_DETECTION_LIMIT EXPECTED_DETECT_LIMIT DETECTION_LIMIT_UNIT EXPECTED_REPORTING_UNIT CUSTOM_FIELD_1

Report Output

FACILITY_CODE

SAMPLE_ID

SYS_LOC_CODE

SYS_SAMPLE_CODE

SAMPLE_DATE

MATRIX_CODE

TEST_ID

ANALYTIC_METHOD

ANALYSIS_DATE

FRACTION

TEST_TYPE

CAS_RN

CHEMICAL_NAME

RESULT_NUMERIC

RESULT_TEXT

RESULT_UNIT

DETECT_FLAG

REPORTING_DETECTION_LIMIT

METHOD_DETECTION_LIMIT

EXPECTED_DETECT_LIMIT

DETECTION_LIMIT_UNIT

EXPECTED_REPORTING_UNIT

CUSTOM_FIELD_1

1Excel report output requires a valid license of Microsoft Excel to view the output.