SPM - SDG Missing Samples Report

Report Name: SPM - SDG Missing Samples

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

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Report Grid1

Description: Shows Chains of Custody (COCs) with Missing Samples in their associated Sample Delivery Groups (SDGs), with an option to show only the samples that are missing.

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.

Overview:

Tables: DT_FACILITY, DT_CHAIN_OF_CUSTODY, DT_TASK, DT_SAMPLE, DT_SDG, DT_SRN

Report Parameters

Inquiry Date	Effective date of this inquiry.
Review Days	Input for number of desired days for the review period.
Show Samples	Selection for Show All samples or Show Only Missing Samples.
Individual Selections
Individual Selections Date Range
Start Date	Start date for COC list.
End Date	End date for COC list.
Individual Selections COC(s)	Parameter for selecting one or more COCs. No selection will return all COCs.

* This report contains hidden parameter: Facility

1The Report Grid provides additional export options to Excel, Google Earth, Outlook, Shapefile, PDF, Text, Access, XML, or a printer.