EIA: Lab Results Completeness

Report Name: EIA: Lab Results Completeness (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: Lab Results Completeness 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

Plan Code	Parameter to select the sample plan code. Only plans with applicable tasks are shown.
Sample
Task Filter
Date Range
Start	Select a start date.
End	Select an end date.
Department(s)	Parameter for selecting department(s).
Monitoring Program	Parameter for selecting monitoring program.
Monitoring Type	Parameter for selecting monitoring type.
Authority	Parameter for selecting authority.
Authority Type	Parameter for selecting authority type.
Permit Number	Parameter for selecting permit number.
Task Type	Parameter for selecting task type.
Priority Ranking	Parameter for selecting priority ranking.
Person Name(s)	Parameter for selecting person(s).
Company Code(s)	Parameter for selecting company code(s).
Project(s)	Parameter for selecting project(s).
SPM Task Code(s)	Parameter for selecting SPM task code(s).
Type(s)	Select one or more sample types.
QC Type(s)
Matrix(es)	Select one or more sample matrix.
Delivery Group(s)	Parameter to select one or more sample delviery goups (field or lab).
Result Type(s)	Parameter to select result type(s).
Test Type(s)	Parameter to select test type(s).
Non-detect Symbol	Input parameter for non-detect symbol. Default: <.
Reporting Limit	Select which reporting limit you desire to use (reporting_detection_limit, method_deteciton_limit, etc.)
Location
Individual(s)	Parameter for selecting individual locations.
Group(s)	Parameter for selecting location groups.
Check by Method	Check box for enabling check by method. Default: False.
Check by Lab	Check box for enabling check by lab. Default: False.
Check by Matrix	Check box for enabling check by matrix. Default: True.
Check by Fraction	Check box for enabling check by fraction. Default: True.
Check by Sample depth	Check box for enabling check by Sample depth. Default: True.
Check by SPM sys_sample_code	Check box for enabling check by SPM sys_sample_code. Default: False.
Add Task Client	Check box to add task client. Default: False.
A Simple Lab Results Summary Report	Check box to create a simple lab results summary report with C and I status. Default: False. (If selected, Include Unplanned Data will be ignored)
Included Unplanned Data	Check box to include unplanned samples. Default: False.
EDD (ebatch)	Parameter for selecting EDDs.

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