EIA: Rejected EDDs Report

<< Click to Display Table of Contents >>

Navigation:  EQuIS Library > Reports > EarthSoft Standard Reports by Product > Standard with SPM > EIAs (EQuIS Information Agents) >

EIA: Rejected EDDs Report

Report Name: EIA: Rejected EDDs

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: Rejected EDDs Report can be used to notify users of EDDs that have been rejected by Enterprise EDP at least once and have not, to date, loaded successfully to EQuIS.

 

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 returns records where ST_FILE_REGISTRATION.ACCEPTED_DATE is null and ST_FILE_REGISTRATION.REJECTED_DATE is more than (X) days in the past. The records returned will include those with null ST_FILE_REGISTRATION.FACILITY_ID to account for EDDs for which EQuIS Enterprise EDP was unable to determine the appropriate Facility.

 

This report can be run manually, but is also setup as an EIA. Instructions on how to setup EIAs are available here.

 

Tables: ST_FILE_REGISTRATION

 

Report Parameters *

Older than X days ago

Parameter to check for rejected EDDs over X days ago. Default: 7.

 

* 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

FILE_NAME

REJECTED_DATE

 

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

 

 



Copyright © 2024 EarthSoft, Inc. • Modified: 08 Dec 2023