SPM - Completeness Table - Analytical Results Report

Report Name: SPM - Completeness Table - Analytical Results (example)

File Name: EarthSoft.Reports.Library.48827.dll

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Report Grid with options for Excel1 and CrossTab

Description: The SPM - Completeness Table - Analytical Results report gives a comparison between analytical and field results that had been scheduled to occur and the data that has been received in the EQuIS data tables. The report grid has a Status column to show complete and incomplete tasks. This report is intended to generate a grid output to be used in Enterprise and Microsoft Power BI Dashboards.

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 usage, this report should be published to the database. The report will be available for selection once it has been published.

•For Professional usage, this report should be published to the database or have the .dll added to the local '.../Earthsoft/EQuIS/' folder.

Overview: The comparison can use the SYS_SAMPLE_CODE or use the following fields from the DT_SPM_SCHEDULED_SAMPLE and DT_SAMPLE tables: TASK_CODE, SYS_LOC_CODE, SAMPLE_TYPE, MATRIX (if not null), and DEPTH (if not null).

Source Tables DT_FACILITY, DT_SAMPLE, DT_FIELD_SAMPLE, DT_LOCATION, DT_COORDINATE, DT_SPM_SCHEDULED_SAMPLE, DT_SPM_SCHEDULED_TASK, DT_SPM_SCHEDULED_RESULT, DT_SPM_CONTRACT, DT_SPM_CONTRACT_CONTAINER, DT_SPM_CONTRACT_MAG, DT_SRN, DT_SRN_AMENDMENT, DT_SRN_ISSUE_TEST, DT_SDG, DT_CHAIN_OF_CUSTODY_MAG, DT_CHAIN_OF_CUSTODY, DT_CHAIN_OF_CUSTODY_MAG_MEMBER, DT_TEST, DT_SPM_PLANNED_TASK, DT_SPM_COMMITMENT, RT_GROUP, RT_GROUP_MEMBER

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 results Summary Report	Check box to create a simple lab results summary report with C and I status. Default: False.
Included Unplanned Samples	Check box to include unplanned samples. Default: False.
Reportable	Select one or more reportable results.

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