<< Click to Display Table of Contents >> Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > EIAs (EQuIS Information Agents) > 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

 

 

 

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