SPM - SRN Issues Report

Report Name: SPM - SRN Issues (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: Lists Sample Receipt Notification (SRN) Issues.

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:

Tables: AT_SAMPLE_SDG, DT_SRN, DT_CHAIN_OF_CUSTODY, DT_TASK, DT_SPM_PLAN, DT_SRN_ISSUE, RT_ANALYTIC METHOD, RT_MTH_ANL_GROUP, RT_MTH_ANT_GROUP_MEMBER, DT_SRN_ISSUE_TEST

Report Parameters

Inquiry Date	Effective date of this inquiry.
Review Days	Input for number of desired days for the review period.
Task Filter
Department(s)	Parameter for selecting department(s).
Monitoring Program(s)	Parameter for selecting monitoring program(s).
Monitoring Type(s)	Parameter for selecting monitoring type(s).
Authority(s)	Parameter for selecting authority(s).
Authority Type(s)	Parameter for selecting authority type(s).
Permit Number	Parameter for selecting permit number.
Task Type	Parameter for selecting task type.
Priority Ranking	Parameter for selecting priority ranking.
Task Code(s)	Parameter for selecting task code(s).
Individual Selections SRN(s)	Parameter to select one or more SRNs. No selection will return all SRNs.
Individual Selections SDG(s)	Parameter to select one or more SDGs. No selection will return all SDGs.
Individual Selections COC(s)	Parameter to select one or more COCs. No selection will return all COCs.

* This report contains the following hidden parameter(s) that could affect the outcome of the report:

•Facility_id

Consult an EQuIS administrator if this parameter should be visible or use different default values in a published report (a report that allows saving of User Reports). This parameter cannot be viewed or changed in unpublished reports outside of a report parameter file.

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