<< Click to Display Table of Contents >> Navigation: EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > EIAs (EQuIS Information Agents) > EIA: Incomplete Lab Results Report |
Report Name: EIA: Incomplete Lab Results (example)
File Name: EarthSoft.Reports.Library.48827.dll
Dependencies: Licensed SPM and SPM Schema
Software: SPM
Source: SPM install
Language: English
Output Type: Excel1
Description: The EIA: Incomplete Lab Results report can be used to configure EDD-triggered agents to check incoming EDDs for completeness. The report logic is based on the SPM - Completeness Report - Summary report, and presents similar input parameters.
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 compares laboratory results in incoming EDDs against the expected results based on the task code selected in the report parameters, showing a list of results that are missing. The report generates output for each associated EDD until all expected results are received. For example, if 100 results are expected for the chosen task code and an incoming EDD contains 75 results associated with that task code, the report will generate output on the 25 remaining results. If a second EDD is received containing the remaining 25 results associated with the task code, the report will not generate output.
This report is setup as an EQuIS Information Agent (EIA) only. Instructions on how to setup the SPM Completeness Report as an EIA are available here, and can be followed with slight modifications to setup this report.
Tables: DT_SAMPLE, DT_SPM_CONTRACT, DT_SPM_CONTRACT_MAG, DT_SPM_SCHEDULED_RESULT, DT_SPM_SCHEDULED_SAMPLE, DT_TASK
Report Parameters |
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
1Excel report output requires a valid license of Microsoft Excel to view the output.
Copyright © 2022 EarthSoft, Inc • Modified: 25 Nov 2021