CG3/4/5 RNC Detection Report the Detection RNC_DETECTION_CODE icis_npdes_violation.rnc_detection_code Code/Date/Type Code, Detection Date, and Detection RNC_DETECTION_DATE icis_npdes_violation.rnc_detection_date Type of the Violation icis_npdes_violation.rnc_detection_code get RNC_DETECTION_TYPE ref_rnc_detection.rnc_detection_type_code CG6/7/8 RNC Resolution Report the Resolution RNC_RESOLUTION_CODE icis_npdes_violation.rnc_resolution_code Code/Date/Description Code, Resolution Date, and Violation RNC_RESOLUTION_DATE icis_npdes_violation.rnc_resolution_date Status of the Violation RNC_RESOLUTION_DESC using icis_npdes_violation.rnc_resolution_code get ref_rnc_resolution.rnc_resolution_desc Schedule Violation Summary The Schedule Violation Summary displays information on Violations with a Violation Group of SCH. The reporting rules are the same in the Current Noncompliance and Future Noncompliance Sections. Table 5.1-17, Schedule Violation Summary, provides the details of the reported records. Table 5.1-17. Schedule Violation Summary Column in Underlying Logic Number Field Report Rule ICIS_QNCR_RPT_COORDINATORS on Rpt. CS1 Violation Date Reports the VIOLATION_DATE icis_perm_schedule_event.schedule_date Schedule Date of icis_comp_schedule_event.schedule_date the Schedule Event, to which the Violation is linked. CS2 Sch Num Reports the SCHEDULE_NMBR permit schedules: Schedule Number icis_perm_narrative_condition.narrative_condition_nmbr of the Schedule comp schedules: Event, to which the icis_comp_schedule.comp_schedule_nmbr Violation is linked.
CG3/4/5 RNC Detection Code/Date/Type Report the Detection Code, Detection Date, and Detection Type of the Violation RNC_DETECTION_CODE RNC_DETECTION_DATE RNC_DETECTION_TYPE icis_npdes_violation.rnc_detection_code icis_npdes_violation.rnc_detection_date icis_npdes_violation.rnc_detection_code get ref_rnc_detection.rnc_detection_type_code CG6/7/8 RNC Resolution Code/Date/Description Report the Resolution Code, Resolution Date, and Violation Status of the Violation RNC_RESOLUTION_CODE RNC_RESOLUTION_DATE RNC_RESOLUTION_DESC icis_npdes_violation.rnc_resolution_code icis_npdes_violation.rnc_resolution_date using icis_npdes_violation.rnc_resolution_code get ref_rnc_resolution.rnc_resolution_desc Schedule Violation Summary The Schedule Violation Summary displays information on Violations with a Violation Group of SCH. The reporting rules are the same in the Current Noncompliance and Future Noncompliance Sections. Table 5.1-17, Schedule Violation Summary, provides the details of the reported records. Table 5.1-17. Schedule Violation Summary Number on Rpt. Field Report Rule Column in ICIS_QNCR_RPT_COORDINATORS Underlying Logic CS1 Violation Date Reports the Schedule Date of the Schedule Event, to which the Violation is linked. VIOLATION_DATE icis_perm_schedule_event.schedule_date icis_comp_schedule_event.schedule_date CS2 Sch Num Reports the Schedule Number of the Schedule Event, to which the Violation is linked. SCHEDULE_NMBR permit schedules: icis_perm_narrative_condition.narrative_condition_nmbr comp schedules: icis_comp_schedule.comp_schedule_nmbr
NPDES_Reports_v1.44.docx