Report Name: EIA: LOR Validation
File Name: EarthSoft.Reports.Library.48827.dll
Dependencies: Licensed SPM and SPM Schema
Source: SPM install
Output Type: Excel1
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.
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
This report contains no input parameters
* This report contains hidden parameter: Facility_ID
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021