EIA: Resample Requests Report

Report Name: EIA: Resample Requests

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

Dependencies: licensed SPM module and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type:

Description: The EIA: Resample Requests report can be used to notify users of new Resample Requests. The report lists all Resample Requests received on the Inquiry Date, which defaults to today's date. The report may be most useful if run on a daily schedule using a relative date for the Inquiry Date parameter, for example, "Today" or "Yesterday".

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:

This report is setup as an EQuIS Information Agent (EIA). Instructions on how to setup EIAs is available here.

Tables: AT_SAMPLE_SDG, DT_SAMPLE, DT_SDG, DT_SPM_RESAMPLE, DT_SPM_SCHEDULED_TASK, DT_SRN_ISSUE_SAMPLE, DT_TASK, RT_LOOKUP

Report Parameters

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).
Inquiry Date	Select the effective date of this inquiry.
Approved?	Parameter to select whether to limite approved (Y) or rejected (N) requests.
resample_reason(s)	Parameter for selecting resample_reasons.

Report Output
FACILITY_ID TASK_CODE SDG (WORK ORDER) SYS_SAMPLE_CODE SYS_LOC_CODE REQUEST_DATE REQUEST_TYPE	RESAMPLE_DATE RESAMPLE_APPROVED_YN RESAMPLE_REMARK PRIORITY REJECTION_REASON REMARK SAMPLE_ID	SPM_RESAMPLE_ID REASON_CODE REASON_DESCRIPTION PLAN DEPARTMENT

Report Output

FACILITY_ID

TASK_CODE

SDG (WORK ORDER)

SYS_SAMPLE_CODE

SYS_LOC_CODE

REQUEST_DATE

REQUEST_TYPE

RESAMPLE_DATE

RESAMPLE_APPROVED_YN

RESAMPLE_REMARK

PRIORITY

REJECTION_REASON

REMARK

SAMPLE_ID

SPM_RESAMPLE_ID

REASON_CODE

REASON_DESCRIPTION

PLAN

DEPARTMENT