| Table of Contents |
|---|
Overview
The ICIS-NPDES Data View allows for staging new submissions to ICIS-NPDES and for viewing staged and historically submitted data.
This screen is only available if the current user belonging to a Security Group containing the “ICIS-NPDES Administrator” role.
Submissions Tab
...
...
Staged/Queued Submission
The first section allows for manually staging a new submission for transmittal to ICIS. One one submission can be staged at a time. This area has three modes:
No Queued/Staged Submission
Queued - A submission has been created and is ready to send to ICIS-NPDES.
Submitted - A submission has been sent to ICIS-NPDES and is awaiting a processing report to be sent back from ICIS-NPDES.
Staging a New Submission to ICIS-NPDES
When no queued/staged submission exists, a new submission can be created using the Stage New Submission button.
...
Clicking Stage New Submission displays a dialog where the user can select which payload(s) to stage for submission and optionally, to filter for a specific permit number. The available payloads are based on whether the payload is enabled. Payloads can only be enabled or disabled directly in the database and will require technical assistance to update.
If the Discharge Monitoring Report payload is selected, the user can optionally supply a DMR report period start/end date range. After clicking Save, the new submission will be loaded. A spinner will appear while the staging process is running.
...
Viewing a Staged Submission
If a new submission has been staged, it will display in the Staged/Queued Submission section of the screen. Expanding the submission using the arrow icon will display the number of records staged for each payload in the submission.
...
Click the Open button to view the business key identifiers for the records staged in the submission. The screen will change to the Data Viewer tab with the filters applied for just the staged submission data.
Clearing a Staged Submission
If a submission has been staged and it is decided that the data should not be sent to ICIS, click the Clear Submission button.
Sending a Staged Submission to ICIS-NPDES
To send a staged submission to ICIS-NPDES, navigate to the OpenNode2 instance and use the “Run Now” button to execute the PerformICISSubmission schedule. See OpenNode2 and ICIS-NPDES Plugin documentation for more details.
Submitted List
The Submitted section of the page displays the 30 most recent submissions to ICIS in order of most recent to oldest.
...
Click the Open button to view the records for a given submission.
| Info |
|---|
Note: Detailed data for historical submissions may be incomplete. This is due to how transaction history is tracked in the ICIS-NPDES OpenNode2 plugin. Only the most recent transaction for a given business key is stored. For example, a rejection from an older submission will be deleted if that error was resolved with the data in a newer submission. |
Data Viewer Tab
The data viewer tab allows for searching historical transactions to ICIS-NPDES. Each record is uniquely identified by the combination of Submission Type and business key. The business key for each submission type is defined by the ICIS-NPDES data flow. Please see the ICIS-NPDES batch data flow documentation for more information.
...
Resolving ICIS-NPDES Data Flow Errors
If a record is being repeatedly rejected from ICIS-NPDES and it is determined that the flow should not be attempting to flow that record to ICIS-NPDES, the record can be set to be ignored for future submissions. It goes without saying that caution should be taken when using this option!
Using the data viewer, identify the Submission Type and Business key that is receiving the error
Navigate to the Submissions tab and stage a new submission for just the Submission Type and Permit that will result in staging a submission containing the bad record.
Open the staged submission from the Queued/Staged list.
Locate the bad record in the Data Viewer tab. It should have a result status of Pending and a Set as Flowed button should appear.
Click Set as Flowed. The row disappears from the list and a confirmation appears.
If desired, clear the staged submission from the Submissions tab.
The record will no longer be staged to flow to ICIS.
How “Set as Flowed” Works
When Set as Flowed is clicked, the staged data for that record is copied to the tracking table of successfully flowed data. Essentially, you are telling the flow tracking tables that the record has successfully flowed which prevents it from being picked up from future submissions.
Note that the data viewer will now incorrectly reflect that the data was sent successfully to ICIS for this record. There is currently no way to differentiate records that were actually successfully flowed from those where “Set as Flowed” was used, which can create audit challenges later on.
ICIS-NPDES Flow Process Business Rules
...