CP3 FRS ID Reports the FRS FACILITY_UIN icis_facility_interest.facility_uin via ID of the xref_activity_facility_interest Facility for the current Permit. CP9 Maj/Min Reports the Major/Minor Indicator of the Permit. CP4 Facility Type Reports the FACILITY_TYPE_DESC icis_permit.facility_type_indicator (POTW, etc.) Facility Type of the Permit(s). This report field will contain POTW for POTW, for or Federal for Federal. CP5 Federal Reports the Federal FEDERAL_GRANT_FLAG ICIS_PERMIT.FEDERAL_GRANT_FLAG Grant Grant Indicator of the Permit. Database stores Y/N. Report displays $ if Y and Report $ if blank if not Y indicator is True Report blank if indicator is False. CP6 Compliance Current PERMIT_STATUS_DESC PERMIT_STATUS_CODE Status Noncompliance and (NC = Noncompliant, RE = Resolved, RP = Compliant Permits Resolved Pending, CO = Compliant for Section: coordinator's) Reports the Permit Status should go to Description of ref_rnc_status_category.rnc_status_category_desc the Permit based on icis_perm_rnc_history Future Noncompliance logic is if icis_perm_rnc_man_status_code is Section: present, use that to get the status category, else Report blank. use icis_perm_rnc_auto_status_code
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
NPDES_Reports_v1.44.docx