EIA: Rejected EDDs Report

Report Name: EIA: Rejected EDDs

File Name: EarthSoft.Reports.Library.48827.dll* and EarthSoft.Reports.Library.d39109

Dependencies: Licensed SPM and SPM Schema

Software: SPM

Source: SPM install

Language: English

Output Type: Excel1

*Note: This report was previously part of the EarthSoft.Reports.Library.48827.dll file. Previously published reports that have 48827 in the filename will still be accessible within EQuIS Professional; however, they will have [Outdated] appended to the filename to differentiate between each location.

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

Report Output

FILE_NAME

REJECTED_DATE

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