CD3 Parameter Specific Violation: CD3 PARAMETER_CODE CD3: "If Entire DMR Overdue: ""DMR Overdue to EPA/State"" CD4 CD3: Report the DMR CD4 PARAMETER Parameter Code concatenated with Else icis_dmr_form_parameter.parameter_code" “-” CD4: Report Parameter Name CD4: "If Entire DMR Overdue: blank Entire DMR Overdue: CD3: Report “Entire Else icis_dmr_form_parameter.parameter_code DMR Overdue”. get ref_parameter.parameter_desc" CD4: Report blank. CD5 Mon Loc Specific Violation: MONITORING_LOCATION_CODE If Entire DMR Overdue: Report the Monitoring Location Code Else Entire DMR Overdue: icis_dmr_form_parameter.monitoring_location_code Report blank. CG1 Enforcement Action Report the Enforcement ENFORCEMENT_ACTION_IDENTIFIER if entire DMR Overdue: blank Identifier Action Identifier concatenated with the If violation is an EA limit vio or Comp Schedule vio: Final Order Identifier of the Violation’s Source Enforcement Action else: blank CD6 Change of Limit Status Reports the type of limit CHANGE_LIMIT_STATUS_CODE if icis_limit.CHANGE_LIMIT_STATUS_CODE in that is linked with the DMR (PAC, MJM, MNM, MLG), "Mod Limit" Parameter. Report EA Limit if the if icis_limit.CHANGE_LIMIT_STATUS_CODE = linked Limit is EA EAL, "EA Limit" Limit Report Mod if the else linked Limit is Mod "Base Limit" Limit Report Base Limit if the linked Limit is Base Limit CG2 Violation Report the Violation VIOLATION_CODE icis_npdes_violation.violation_code Code of the Violation
CD3 CD4 Parameter Specific Violation: CD3: Report the DMR Parameter Code concatenated with “-” CD4: Report Parameter Name Entire DMR Overdue: CD3: Report “Entire DMR Overdue”. CD4: Report blank. CD3 PARAMETER_CODE CD4 PARAMETER CD3: "If Entire DMR Overdue: ""DMR Overdue to EPA/State"" Else icis_dmr_form_parameter.parameter_code" CD4: "If Entire DMR Overdue: blank Else icis_dmr_form_parameter.parameter_code get ref_parameter.parameter_desc" CD5 Mon Loc Specific Violation: Report the Monitoring Location Code Entire DMR Overdue: Report blank. MONITORING_LOCATION_CODE If Entire DMR Overdue: Else icis_dmr_form_parameter.monitoring_location_code CG1 Enforcement Action Identifier Report the Enforcement Action Identifier concatenated with the Final Order Identifier of the Violation’s Source Enforcement Action ENFORCEMENT_ACTION_IDENTIFIER if entire DMR Overdue: blank If violation is an EA limit vio or Comp Schedule vio: else: blank CD6 Change of Limit Status Reports the type of limit that is linked with the DMR Parameter. Report EA Limit if the linked Limit is EA Limit Report Mod if the linked Limit is Mod Limit Report Base Limit if the linked Limit is Base Limit CHANGE_LIMIT_STATUS_CODE if icis_limit.CHANGE_LIMIT_STATUS_CODE in (PAC, MJM, MNM, MLG), "Mod Limit" if icis_limit.CHANGE_LIMIT_STATUS_CODE = EAL, "EA Limit" else "Base Limit" CG2 Violation Report the Violation Code of the Violation VIOLATION_CODE icis_npdes_violation.violation_code
NPDES_Reports_v1.44.docx