ICIS-NPDES - Compliance Monitoring
- Will Rensmith
Overview
Compliance Monitoring relates to Evaluations in nVIRO.
Mapping of an Evaluation Type to an ICIS-NPDES Compliance Monitoring Category and Type is performed by configuring the Compliance Monitoring Category Code and Compliance Monitoring Type Code on the Evaluation Types lookup edit screen.
Use the attached spreadsheet to determine the valid values to configure, making special note to ensure the chosen values are valid for the given Statute (e.g. ICIS-NPDES = “CWA” and ICIS-Air = “CAA”).
Compliance Monitoring Identifiers
Each inspection is identified in ICIS-NPDES using a Compliance Monitoring identifier. The format must be the two-character state initials followed by 000N and up to 19 additional digits or characters. (e.g. SC000N0000000000000000001)
nVIRO will automatically assign a Compliance Monitoring Identifier to an Evaluation when the evaluation is marked “Complete” and only if the evaluation type is mapped to an ICIS-NPDES Inspection Type Code in the Evaluation Type lookup edit screen.
Compliance Monitoring Contacts/Affiliations
If flowing contacts on compliance actions, the only contact affiliation types for flowing to ICIS-NPDES are Non-Governmental contacts associated with the “Inspections” module:
USE ICIS_LOOKUPS
GO
SELECT RAT.*
FROM dbo.REF_AFFILIATION_TYPE RAT
JOIN dbo.XREF_AFFILIATION_MODULE XAM ON XAM.AFFILIATION_TYPE_CODE = RAT.AFFILIATION_TYPE_CODE
JOIN dbo.REF_APP_MODULE RAM ON RAM.APP_MODULE_CODE = XAM.APP_MODULE_CODE
WHERE RAM.APP_MODULE_CODE = 'IPN'
AND RAT.AFFILIATION_CATEGORY = 'Non-Government'