D3 First Instance of Violation Group = INST_OF_NONCOMPLIANCE SEVs: use icis_npdes_violation.violation_code to get Level Noncompliance SEV: ref_violation.violation_desc (Part 1) D3: Report the Single Event Sch Vios: Violation Use either Description icis_perm_schedule_event.schedule_event_code or Violation = icis_comp_schedule_event.schedule_event_code to get SCH: ref_schedule_event.schedule_event_desc D3: Report the Schedule Single Non-Receipt or Effluent Violation: Description use icis_dmr_form_parameter.parameter_code to get Violation = ref_parameter.parameter_desc EFF or DMR: D3: Report the Parameter Name D4 First Instance of Violation Group = INST_OF_NONCOMPLIANCE_B4_RNC if SEV: Level Noncompliance SEV: blank (Part 2) D4: blank Violation = if SCH: SCH: permit schedules: D4: Report the icis_perm_narrative_condition.narrative_condition_nmbr|| Schedule icis_perm_narrative_condition.schedule_type_flag Number, and Schedule Type comp schedules: Violation = icis_comp_schedule.comp_schedule_nmbr|| EFF or DMR: icis_comp_schedule.schedule_type_flag D4: Report the Permitted if EFF/DMR and BEFORE_WINDOW_FLAG = N: Feature icis_perm_feature.perm_feature_nmbr|| Identifier and "-"||icis_limit_set.limit_set_designator Limit Set Designator. (No Limit Set if EFF/DMR and BEFORE_WINDOW_FLAG = Y: Designator for icis_perm_feature.perm_feature_nmbr Entire DMR Overdue or if violation is Before Window)
D3 First Level Instance of Noncompliance (Part 1) Violation Group = SEV: D3: Report the Single Event Violation Description Violation = SCH: D3: Report the Schedule Description Violation = EFF or DMR: D3: Report the Parameter Name INST_OF_NONCOMPLIANCE SEVs: use icis_npdes_violation.violation_code to get ref_violation.violation_desc Sch Vios: Use either icis_perm_schedule_event.schedule_event_code or icis_comp_schedule_event.schedule_event_code to get ref_schedule_event.schedule_event_desc Single Non-Receipt or Effluent Violation: use icis_dmr_form_parameter.parameter_code to get ref_parameter.parameter_desc D4 First Level Instance of Noncompliance (Part 2) Violation Group = SEV: D4: blank Violation = SCH: D4: Report the Schedule Number, and Schedule Type Violation = EFF or DMR: D4: Report the Permitted Feature Identifier and Limit Set Designator. (No Limit Set Designator for Entire DMR Overdue or if violation is Before Window) INST_OF_NONCOMPLIANCE_B4_RNC if SEV: blank if SCH: permit schedules: icis_perm_narrative_condition.narrative_condition_nmbr|| icis_perm_narrative_condition.schedule_type_flag comp schedules: icis_comp_schedule.comp_schedule_nmbr|| icis_comp_schedule.schedule_type_flag if EFF/DMR and BEFORE_WINDOW_FLAG = N: icis_perm_feature.perm_feature_nmbr|| "-"||icis_limit_set.limit_set_designator if EFF/DMR and BEFORE_WINDOW_FLAG = Y: icis_perm_feature.perm_feature_nmbr
NPDES_Reports_v1.44.docx