D5 First RNC Report the RNC_D5 If single Non-Receipt or Effluent violation and before Level Detection window = Y: Type. See Table 3.1-7, Else: use icis_npdes_violation.rnc_detection_code and Detection get Type. ref_rnc_detection.detection_type_code D6 First Violation Date Violation Group = VIOLATION_DATE SEV: icis_npdes_violation.single_event_violation_date Level SEV: Report the Schedule Violation: Single Event icis_perm_schedule_event.schedule_date Violation Date icis_comp_schedule_event.schedule_date Violation Group = SCH: If single Non-Receipt or Effluent violation and before Report the window = N: Schedule Date icis_dmr_event.monitoring_period_end_date Violation Group = EFF or DMR: If single Non-Receipt or Effluent violation and before Report the window = Y: earliest monitoring_period_end_date for Monitoring "crunched" violation records Period End Date. D6.5 First Violation End Violation Group = END_DATE If single Non-Receipt or Effluent violation and before Level Date EFF or DMR and window = Y: latest monitoring_period_end_date for Before Window = "crunched" violation records Y: Report the Else blank Monitoring Period End Precede in BO with - so it will look like “ “ Date of the VIOLATION_DATE - END_DATE latest violation in the summary group. D15 First Status Report the VIOLATION_STATUS_CODE use icis_npdes_violation.rnc_resolution_code to get Level Violation ref_rnc_resolution.rnc_status_category_code Status. See Table 3.1-5.
D5 First Level RNC Report the Detection Type. See Table 3.1-7, Detection Type. RNC_D5 If single Non-Receipt or Effluent violation and before window = Y: Else: use icis_npdes_violation.rnc_detection_code and get ref_rnc_detection.detection_type_code D6 First Level Violation Date Violation Group = SEV: Report the Single Event Violation Date Violation Group = SCH: Report the Schedule Date Violation Group = EFF or DMR: Report the Monitoring Period End Date. VIOLATION_DATE SEV: icis_npdes_violation.single_event_violation_date Schedule Violation: icis_perm_schedule_event.schedule_date icis_comp_schedule_event.schedule_date If single Non-Receipt or Effluent violation and before window = N: icis_dmr_event.monitoring_period_end_date If single Non-Receipt or Effluent violation and before window = Y: earliest monitoring_period_end_date for "crunched" violation records D6.5 First Level Violation End Date Violation Group = EFF or DMR and Before Window = Y: Report the Monitoring Period End Date of the latest violation in the summary group. END_DATE If single Non-Receipt or Effluent violation and before window = Y: latest monitoring_period_end_date for "crunched" violation records Else blank Precede in BO with “ - “ so it will look like VIOLATION_DATE - END_DATE D15 First Level Status Report the Violation Status. See Table 3.1-5. VIOLATION_STATUS_CODE use icis_npdes_violation.rnc_resolution_code to get ref_rnc_resolution.rnc_status_category_code
NPDES_Reports_v1.44.docx