Report Fields See supplementary developer document qncr_report_fields.xls for detailed table and logic listings for each column in icis_qncr_rpt_official_sel. Remove Minors When the Official QNCR report is run, the system will not select any Permits (or associated Violations and Enforcement Actions) that were not Majors as of the Window End Date. Header Sections Report Header The Report Header appears at the top of each page of the report. This section contains high-level information regarding the report and the Permits listed on the page. Table 3.1-14, Report Header, provides the field level detail of the Report Header. 3.1-14. Report Header Number on Rpt Field Report Rule Column in ICIS_QNCR_RPT_OFFICIAL_SEL Underlying Logic R.5 Data Run Date Reports the date the QNCR was created in MM/DD/YYYY format. CREATED_DATE Date the record was created in the (i.e., the date the process was run that created the record) R1 Date Reports the current system date in MM/DD/YYYY format. N/A Generated in report as current date; not stored in R2 Region Reports the Region Code for the Region to which the Permit(s) on the page belong. EPA_REGION_CODE using STATE_CODE get ref_state.region_code
Table 3.1-15. Permit Header Field Number on Rpt Field Report Rule Column in ICIS_QNCR_RPT_OFFICIAL_SEL Underlying Logic IP.1 Reports the of the Facility (not displayed on the report; used to support an input parameter) STATE_REGION ICIS_FACILITY_INTEREST.STATE_REGION P1 Facility Name Reports the Facility Name of the current Permit. FACILITY_NAME ICIS_FACILITY_INTEREST.FACILITY_NAME P2 ID Reports the NPDES ID of the current Permit. EXTERNAL_PERMIT_NUMBER ICIS_PERMIT.EXTERNAL_PERMIT_NMBR P3 FRS ID Reports the FRS ID of the Facility for the current Permit. FACILITY_UIN icis_facility_interest.facility_uin via xref_activity_facility_interest P4 Reports the City Name of the Facility for the current Permit. CITY ICIS_FACILITY_INTEREST.CITY
P5 Grant Reports the Federal Grant Indicator of the Permit: Report $ if indicator is True Report blank if indicator is False. FEDERAL_GRANT_FLAG ICIS_PERMIT.FEDERAL_GRANT_FLAG Database stores Y/N. Report displays $ if Y and blank if not Y P6 RNC Status Reports the RNC Status of the Permit: Report if Permit Status Designator is NC Report Resolved if Permit Status Designator is RE Report Resolved Pending if Permit Status Designator is RP PERMIT_STATUS_DESC PERMIT_STATUS_CODE (NC = Noncompliant, RE = Resolved, RP = Resolved Pending, CO = Compliant for coordinator's) should go to on icis_perm_rnc_history logic is if icis_perm_rnc_man_status_code is present, use that to get the status category, else use icis_perm_rnc_auto_status_code P7 Permit Status Sort Not displayed on report; used for sorting Based on PERMIT_STATUS_DESC: NC = 1 RE = 1 RP = 2
L2 First Level Enforcement Action (Linked Violation linked to an EA or FO: Informal Enforcement Action: L2: Report Issued By Flag (E=EPA, S=ST). Formal Enforcement Action: L2: Report blank Final Order: L2: Report Issued By Flag (E=EPA, S=ST). Violation not linked to an EA or FO: Report blank. LNK_ENF_ACT_DESC_LVL1_ISSUED_BY Always for Entire DMR Overdue records L3 Second Level Enforcement Action (Linked Violation linked to an EA or FO: Informal Enforcement Action: Report blank. Formal Enforcement Action: Report Final Order: Report Order: ” concatenated with the Formal Enforcement Action Identifier and the Final Order Identifier. Violation not linked to an EA or FO: Report blank. LNK_ENF_ACT_DESC_LVL2 Always blank for Entire DMR Overdue records
L2 First Level Enforcement Action Violation linked to an EA or FO: Informal Enforcement Action: L2: Report Issued By Flag (E=EPA, S=ST). Formal Enforcement Action: L2: Report blank Final Order: L2: Report Issued By Flag (E=EPA, S=ST). Violation not linked to an EA or FO: Report blank. LNK_ENF_ACT_DESC_LVL1_ISSUED_BY Linked FO: icis_activity.state_epa_flag Linked Formal EA: always blank Linked Informal EA: icis_activity.state_epa_flag
L3 Second Level Enforcement Action Violation linked to an EA or FO: Informal Enforcement Action: Report blank. Formal Enforcement Action: Report blank. Final Order: Report Order: ” concatenated with the Formal Enforcement Action Identifier and the Final Order Identifier. Violation not linked to an EA or FO: Report blank. LNK_ENF_ACT_DESC_LVL2 Linked FO: icis_enforcement.enf_identifier|| icis_enf_conclusion.enf_conclusion_nmbr Linked Formal EA: always Linked Informal EA: always blank
L5 Begin on First Level and Continue to Multiple Levels until entire Comment is printed Comments Violation linked to an EA or FO: Informal Enforcement Action: Report Formal Enforcement Action: Report Final Order: Report the QNCR Comment Text from the Final Order. Violation not linked to an EA or FO: Report blank. LNK_ENF_COMMENTS_LVL1 Linked FO: icis_enf_conclusion.qncr_comment_text Linked Formal EA: always Linked Informal EA: always D1 First Level Enforcement Action (Source) Report the Final Order Type Description if a Source Final Order exists; otherwise, the field is blank. Populated for Compliance Schedule and Enforcement Action Limit Violations SRC_FO_LVL1_SOURCE_FO_DESC icis_enf_conclusion.enf_conclusion_action_code then get: ref_enf_conclusion_action.enf_conclusion_action_desc D2 First Level Enforcement Action (Source) Report “Final Order: ” concatenated with the Formal Enforcement Action Identifier and the Final Order Identifier if a Source Final Order exists; otherwise the field is blank. Populated for Compliance Schedule and Enforcement Action Limit Violations SRC_FO_LVL1_SOURCE_FO_ID icis_enforcement.enf_identifier||’-‘|| icis_enf_conclusion.enf_conclusion_nmbr
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
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
Compliance Schedule Date ICIS_COMP_SCHEDULE_EVENT SCHEDULE_DATE Compliance Schedule Event Code ICIS_COMP_SCHEDULE_EVENT SCHEDULE_EVENT_CODE Compliance Schedule Description REF_SCHEDULE_EVENT SCHEDULE_EVENT_DESC Compliance Schedule Number ICIS_COMP_SCHEDULE COMP_SCHEDULE_NUMBER Compliance Schedule Type ICIS_COMP_SCHEDULE COMP_SCHEDULE_TYPE_FLAG DMR Window End Date Calculated field Calculated field Enforcement Action Type Description REF_ENF_TYPE ENF_TYPE_DESC Facility Type Description ICIS_PERMIT FACILITY_TYPE_INDICATOR Federal Grant Indicator ICIS_PERMIT FEDERAL_GRANT_FLAG Order Identifier ICIS_ENF_CONCLUSION ENF_CONCLUSION_NMBR Final Order Type Description REF_ENF_CONCLUSION_ACTION ENF_CONCLUSION_ACTION_DESC Formal Enforcement Action Identifier ICIS_ENFORCEMENT ENF_IDENTIFIER FRS ID ICIS_FACILITY_INTEREST FACILITY_UIN Issued By Flag ICIS_ACTIVITY STATE_EPA_FLAG Issued/Entered Date ICIS_ENF_CONCLUSION SETTLEMENT_ENTERED_DATE Limit Set Designator ICIS_LIMIT_SET LIMIT_SET_DESIGNATOR Manual RNC Status Flag ICIS_PERM_RNC_HISTORY PERM_RNC_MAN_STATUS_CODE Monitoring Location Code ICIS_LIMIT MONITORING_LOCATION_CODE Monitoring Period End Date ICIS_DMR_EVENT MONITORING_PERIOD_END_DATE NPDES ID ICIS_PERMIT EXTERNAL_PERMIT_NMBR Parameter Code ICIS_DMR_FORM_PARAMETER PARAMETER_CODE Parameter Name REF_PARAMETER PARAMETER_DESC Facility Name ICIS_FACILITY_INTEREST FACILITY_NAME Permit Schedule Date ICIS_PERM_SCHEDULE_EVENT SCHEDULE_DATE Permit Schedule Event Code ICIS_PERM_SCHEDULE_EVENT SCHEDULE_EVENT_CODE Permit Schedule Event Description REF_SCHEDULE_EVENT SCHEDULE_EVENT_DESC Permit Status Description REF_RNC_STATUS_CATEGORY RNC_STATUS_CATEGORY_CODE Permit Schedule Number ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_NUMBER Permit Schedule Type ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_TYPE_FLAG Permit Termination Date ICIS_PERMIT TERMINATION_DATE Permit Type Code ICIS_PERMIT PERMIT_TYPE_CODE
Permitted Feature ID ICIS_PERM_FEATURE PERM_FEATURE_NUMBER QNCR Comment Text ICIS_ENF_CONCLUSION QNCR_COMMENT_TEXT Region Code ICIS_FACILITY_INTEREST REGION_CODE RNC Detection Code ICIS_NPDES_VIOLATION RNC_DETECTION_CODE RNC Detection Date ICIS_NPDES_VIOLATION RNC_DETECTION _DATE RNC Detection Type Code REF_RNC_DETECTION DETECTION_TYPE_CODE RNC Resolution Code ICIS_NPDES_VIOLATION RNC_RESOLUTION_CODE RNC Resolution Date ICIS_NPDES_VIOLATION RNC_RESOLUTION_DATE Single Event Violation Date ICIS_NPDES_VIOLATION SINGLE_EVENT_VIOlATION_DATE Single Event Violation Description REF_VIOLATION VIOlATION_DESC State Code ICIS_FACILITY_INTEREST STATE_CODE State-Region ICIS_FACILITY_INTEREST STATE_REGION State Name REF_STATE STATE_DESC Violation Code ICIS_NPDES_VIOLATION VIOLATION_CODE Violation Group Code REF_VIOLATION VIOLATION_GROUP_CODE Permit Effective Date ICIS_PERMIT EFFECTIVE_DATE Major/Minor Indicator ICIS_MAJOR_MINOR_STATUS MAJOR_MINOR_STATUS_FLAG RNC Resolution Code Description REF_RNC_RESOLUTION RNC_RESOLUTION_DESC RNC Detection Code Description REF_RNC_DETECTION RNC_DETECTION_DESC Violation ID ICIS_NPDES_VIOLATION NPDES_VIOLATION_ID Violation Code Description REF_VIOLATION VIOLATION_DESC DMR Window Start Date Calculated field Calculated
CP3 FRS ID Reports the FRS ID of the Facility for the current Permit. FACILITY_UIN icis_facility_interest.facility_uin via xref_activity_facility_interest CP9 Maj/Min Reports the Major/Minor Indicator of the Permit. CP4 Facility Type Reports the Facility Type of the Permit(s). This report field will contain POTW for POTW, for or Federal for Federal. FACILITY_TYPE_DESC icis_permit.facility_type_indicator (POTW, etc.) CP5 Federal Grant Reports the Federal Grant Indicator of the Permit. Report $ if indicator is True Report blank if indicator is False. FEDERAL_GRANT_FLAG ICIS_PERMIT.FEDERAL_GRANT_FLAG Database stores Y/N. Report displays $ if Y and blank if not Y CP6 Compliance Status Current Noncompliance and Compliant Permits Section: Reports the Permit Status Description of the Permit Future Noncompliance Section: Report blank. PERMIT_STATUS_DESC PERMIT_STATUS_CODE (NC = Noncompliant, RE = Resolved, RP = Resolved Pending, CO = Compliant for coordinator's) should go to ref_rnc_status_category.rnc_status_category_desc based on icis_perm_rnc_history logic is if icis_perm_rnc_man_status_code is present, use that to get the status category, else use icis_perm_rnc_auto_status_code
CP39 Fiscal Year – Position 8 Report “FY” concatenated with the fiscal year of the current RNC Quarter in YY format. PERM_QNCR_STAT_CURR_QTR_YR "icis_perm_rnc_history.year for the current year/quarter " CP12 Quarter – Position 1 Report “Q” concatenated with the quarter of the RNC Quarter previous to the quarter in Position 2 in Q format. PERM_QNCR_STAT_CURR_QTR-7_QT "icis_perm_rnc_history.quarter for the current year/quarter - 7 " CP16 Quarter – Position 2 Report “Q” concatenated with the quarter of the RNC Quarter previous to the quarter in Position 3 in Q format. PERM_QNCR_STAT_CURR_QTR-6_QT "icis_perm_rnc_history.quarter for the current year/quarter - 6 " CP20 Quarter – Position 3 Report “Q” concatenated with the quarter of the RNC Quarter previous to the quarter in Position 4 in Q format. PERM_QNCR_STAT_CURR_QTR-5_QT "icis_perm_rnc_history.quarter for the current year/quarter - 5 "
CP40 Quarter – Position 8 Report “Q” concatenated with the quarter of the current RNC Quarter in Q format. PERM_QNCR_STAT_CURR_QTR_QT "icis_perm_rnc_history.quarter for the current year/quarter " CP13/14 Permit Status – Position 1 Report the Automatic RNC Permit Status for this position’s quarter concatenated with “/” and the Manual Permit RNC Status for this position’s quarter. PERM_QNCR_STAT_CURR_QTR-7_AS PERM_QNCR_STAT_CURR_QTR-7_MS "icis_perm_rnc_history.perm_rnc_auto_status_code for the current year/quarter - 7 " "icis_perm_rnc_history.perm_rnc_man_status_code for the current year/quarter - 7 " CP17/18 Permit Status – Position 2 Report the Automatic RNC Permit Status for this position’s quarter concatenated with “/” and the Manual Permit RNC Status for this position’s quarter. PERM_QNCR_STAT_CURR_QTR-6_AS PERM_QNCR_STAT_CURR_QTR-6_MS "icis_perm_rnc_history.perm_rnc_auto_status_code for the current year/quarter - 6 " "icis_perm_rnc_history.perm_rnc_man_status_code for the current year/quarter - 6 "
CP33/34 Permit Status – Position 6 Report the Automatic RNC Permit Status for this position’s quarter concatenated with “/” and the Manual Permit RNC Status for this position’s quarter. PERM_QNCR_STAT_CURR_QTR-2_AS PERM_QNCR_STAT_CURR_QTR-2_MS "icis_perm_rnc_history.perm_rnc_auto_status_code for the current year/quarter - 2 " "icis_perm_rnc_history.perm_rnc_man_status_code for the current year/quarter - 2 " CP37/38 Permit Status – Position 7 Report the Automatic RNC Permit Status for this position’s quarter concatenated with “/” and the Manual Permit RNC Status for this position’s quarter. PERM_QNCR_STAT_CURR_QTR-1_AS PERM_QNCR_STAT_CURR_QTR-1_MS "icis_perm_rnc_history.perm_rnc_auto_status_code for the current year/quarter - 1 " "icis_perm_rnc_history.perm_rnc_man_status_code for the current year/quarter - 1 " CP41/42 Permit Status – Position 8 Report the Automatic RNC Permit Status for this position’s quarter concatenated with “/” and the Manual Permit RNC Status for this position’s quarter. PERM_QNCR_STAT_CURR_QTR_AS PERM_QNCR_STAT_CURR_QTR_MS "icis_perm_rnc_history.perm_rnc_auto_status_code for the current year/quarter " "icis_perm_rnc_history.perm_rnc_man_status_code for the current year/quarter "
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
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
Single Event Violation Summary The Single Event Violation Summary displays information on Violations with a Violation Group of SEV. The reporting rules are the same in the Current Noncompliance and Future Noncompliance Sections. Table 5.1-18, Single Event Violation Summary, provides the details of the reported records. 5.1-18. Single Event Violation Summary Number on Rpt. Field Report Rule Column in ICIS_QNCR_RPT_COORDINATORS Underlying Logic CV1 Date Reports the Single Violation Date VIOLATION_DATE icis_npdes_violation.single_event_violation_date CV3 Violation CV3: Reports the Single Event Violation Description VIOLATION_DESC use icis_npdes_violation.violation_code to get ref_violation.violation_desc CG2 Violation CG2: Reports the Single Event Violation Code VIOLATION_CODE icis_npdes_violation.violation_code CG3/4/5 RNC Detection Code/Date/Type Reports 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 using icis_npdes_violation.rnc_detection_code get ref_rnc_detection.rnc_detection_type_code CG6/7/8 RNC Resolution Code/Date/Description Reports 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
CL4 Party/Action CL4: Report the Final Order Type Description or the Informal EA Action type; Formal EA with no FO gets literal text ‘Under Enforcement Review’ ENF_CONCLUSION_ACTION_DESC Vio linked to informal EA: xref_enf_type.enf_type_code for the EA's activity then get: ref_enf_type.enf_type_desc Vio linked to Formal EA and not to an FO: "Under Enforcement Review" Vio linked to FO: icis_enf_conclusion.enf_conclusion_action_code then get: ref_enf_conclusion_action.enf_conclusion_action_desc CL5 Status Report the Enforcement Action (Activity) Status for linked FO, otherwise blank. EA_STATUS_DESC Vio linked to informal EA: blank Vio linked to Formal EA and not to an FO: blank Vio linked to FO: use icis_activity.activity_status_code for linked EA/FO go to ref_activity and get activity_status_desc CL6 Status Date Report the Enforcement Action (Activity) Status Date for linked FO, otherwise blank. EA_STATUS_DATE Vio linked to informal EA: blank Vio linked to Formal EA and not to an FO: blank Vio linked to FO: use icis_activity.activity_status_date for linked EA/FO CL7 Formal/Informal Report “Formal” if a Formal EA, “Informal” if an informal EA FORMAL_INFORMAL if icis_activity.activity_type_code = 'AIF', "Informal" if icis_activity.activity_type_code in ('JDC','AFR'), "Formal" CL8 C.S.? Report “YES” if a Compliance Schedule exists for the Final Order for the Permit, otherwise report “NO” – Linked FO only COMP_SCHED_FOR_LINKED_FO_FLAG If using a linked FO, if the icis_enf_conclusion.enf_conclusion_id exists in icis_comp_schedule, then the FO has a schedule and value = Y
Indicator ICIS_MAJOR_MINOR_STATUS MAJOR_MINOR_STATUS_FLAG Manual RNC Status Flag ICIS_PERM_RNC_HISTORY PERM_RNC_MAN_STATUS_CODE Monitoring Location Code ICIS_DMR_FORM_PARAMETER MONITORING_LOCATION_CODE Monitoring Period End Date ICIS_DMR_EVENT MONITORING_PERIOD_END_DATE NPDES ID ICIS_PERMIT EXTERNAL_PERMIT_NMBR Parameter Code ICIS_DMR_FORM_PARAMETER PARAMETER_CODE Parameter Name REF_PARAMETER PARAMETER_DESC Permit Effective Date ICIS_PERMIT EFFECTIVE_DATE Facility Name ICIS_FACILITY_INTEREST FACILITY_NAME Permit Schedule Date ICIS_PERM_SCHEDULE_EVENT SCHEDULE_DATE Permit Schedule Code ICIS_PERM_SCHEDULE_EVENT SCHEDULE_EVENT_CODE Permit Schedule Event Comment ICIS_PERM_SCHEDULE_EVENT SCHEDULE_EVENT_TEXT Permit Schedule Event Description REF_SCHEDULE_EVENT SCHEDULE_EVENT_DESC Permit Schedule Number ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_NMBR Permit Schedule Type Code ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_TYPE_FLAG Permit Status Description REF_RNC_STATUS_CATEGORY RNC_STATUS_CATEGORY_DESC Permit Schedule Number ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_NUMBER Permit Schedule Type ICIS_PERM_NARRATIVE_CONDITION NARRATIVE_CONDITION_TYPE_FLAG Permit Termination Date ICIS_PERMIT TERMINATION_DATE Permit Type Code ICIS_PERMIT PERMIT_TYPE_CODE Permitted Feature ID ICIS_PERM_FEATURE PERM_FEATURE_NMBR QNCR Comment Text ICIS_ENF_CONCLUSION QNCR_COMMENT_TEXT Region Code ICIS_FACILITY_INTEREST EPA_REGION_CODE RNC Detection Code ICIS_NPDES_VIOLATION RNC_DETECTION_CODE RNC Detection Code Description REF_RNC_DETECTION RNC_DETECTION_DESC RNC Detection Date ICIS_NPDES_VIOLATION RNC_DETECTION RNC Detection Type Code REF_RNC_DETECTION DETECTION_TYPE_CODE RNC Resolution Code ICIS_NPDES_VIOLATION RNC_RESOLUTION_CODE RNC Resolution Code Description REF_RNC_RESOLUTION RNC_RESOLUTION_DESC RNC Resolution Date ICIS_NPDES_VIOLATION RNC_RESOLUTION_DATE Schedule Event Type Code REF_SCHEDULE_EVENT SCHEDULE_EVENT_TYPE_FLAG
Quantity 1 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 1 Single Field If no Q1 limit value record exists, report “******” Else if Q1 limit value record exists and Stay Type is not X or Z, report the Limit Value Number for Quantity 1. Else if Q1 limit value record exists and Stay Type is X or Z, report the Limit Value Number for Quantity 1 If the stay type for the parameter is Z and the Form's MPED is >= Stay Start date And (Form's MPED is <= Stay End Date OR Stay End Date is Null), report the Stay Value in brackets for Q1 rather than the Limit Value Number. If the stay type for the limit parameter is X and the Form's MPED is >= Stay Start date And (Form's MPED is <= Stay End Date OR Stay End Date is Null), report the word “Contested” for Q1 rather than the Limit Value Number. Quantity 1 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 2 Single Report the Statistical Base Code Short Description for Quantity 1. Quantity 2 QUANTITY OR LOADING – VALUE – Sample Measurement Single Use Quantity 1 QUANTITY OR LOADING – VALUE – Sample Measurement logic, substituting Q2 Quantity 2 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 1 Single Field Use Quantity 1 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 1 logic, substituting Q2. Quantity 2 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 2 Single Field Report the Statistical Base Code Short Description for Quantity 2. Quantity QUANTITY OR LOADING –UNITS – Sample Measurement Single Field If neither Q1 nor Q2 limit values exist Report “******” If either Q1 and/or Q2 values exist, If user-entered DMR information is included: Report the Unit Code Description from the Quantity DMR Value(s). If user-entered DMR information is not included: Report blank Quantity Units QUANTITY OR LOADING – Permit Requirement Single Field If neither Q1 nor Q2 limit values exist: Report “******” If either Q1 and/or Q2 limit values exist: Report the Unit Code Description from the Quantity Limit Value(s) . Concentration 1 QUALITY OR CONCENTRATION – – Sample Measurement Single Use Quantity 1 QUANTITY OR LOADING – VALUE – Sample Measurement logic, substituting C1
Concentration 1 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 1 Single Use Quantity 1 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 1 logic, substituting C1. Concentration 1 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 2 Single Field Report the Statistical Base Code Short Description for Concentration 1. Concentration 2 QUALITY OR CONCENTRATION – VALUE – Sample Measurement Single Field Use Quantity 1 QUANTITY OR LOADING – VALUE – Sample Measurement logic, substituting C2 Concentration 2 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 1 Single Field Use Quantity 1 QUANTITY OR LOADING – – Permit Requirement – Level 1 logic, substituting C2. Concentration 2 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 2 Single Field Report the Statistical Base Code Short Description for Concentration 2. Concentration 3 QUALITY OR CONCENTRATION – VALUE – Sample Measurement Single Field Use Quantity 1 QUANTITY OR LOADING – VALUE – Sample Measurement logic, substituting C3 Concentration 3 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 1 Single Field Use Quantity 1 QUANTITY OR LOADING – VALUE – Permit Requirement – Level 1 logic, substituting C3. Concentration 3 QUALITY OR CONCENTRATION – VALUE – Permit Requirement – Level 2 Single Report the Statistical Base Code Short Description for Concentration 3. Concentration Units QUALITY OR CONCENTRATION – Sample Measurement Single Field If neither C1 nor C2 nor C3 limit values exist Report “******” If either C1 and/or C2 and/or C3 values exist, If user-entered DMR information is included: Report the Unit Code Description from the Concentration DMR Value(s). If user-entered DMR information is not included: Report blank Concentration QUALITY OR CONCENTRATION – Permit Requirement Single Field If neither C1 nor C2 nor C3 values exist: Report “******” If C1 and/or C2 and/or C3 limit values exist: Report the Unit Code Description from the Concentration Limit Value(s) . Number of Excursions NO. OF EX – Sample Measurement Single Field Report the Reported Number of Excursions from the DMR Parameter. Number of Excursions NO. OF EX – Permit Requirement Single Field Report Frequency of Analysis FREQUENCY OF ANALYSIS – Sample Measurement Single Field Report the Frequency of Analysis Short Description from the DMR Value.