EIA: Overdue Results Report

Report Name: EIA: Overdue Results (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: Overdue Results report notifies users of analytical results they expected, but have not yet received.

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 logic compares the system date to DT_SRN.SCHEDULED_REPORTING_DATE and returns any records where SYSDATE - DT_SRN.SCHEDULED_REPORTING_DATE > 0. The output contains the number of days late calculated as SYSDATE - DT_SRN.SCHEDULED_REPORTING_DATE rounded to the nearest whole number.

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

Tables: AT_SAMPLE_SDG, DT_FACILITY, DT_SDG, DT_SRN, DT_TEST

Input Parameters *
This report contains no input parameters
* This report contains the following hidden parameter(s) that could affect the outcome of the report: •Facility_ID If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter. Consult an EQuIS administrator if hidden parameters should be visible or use different default values in a published report (a report that allows saving of user reports). Hidden parameters cannot be viewed or changed in unpublished reports outside of a report parameter file.

Input Parameters *

This report contains no input parameters

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

•Facility_ID

If listed, the Additional Fields parameter may be customized as explained in How To Customize the Additional Fields Parameter.

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

Report Output
FACILITY_CODE SDG_NAME DAYS_LATE

Report Output

FACILITY_CODE

SDG_NAME

DAYS_LATE

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