P5 Grant Reports the FEDERAL_GRANT_FLAG ICIS_PERMIT.FEDERAL_GRANT_FLAG Federal Grant Indicator of the Database stores Y/N. Report displays $ if Y and Permit: blank if not Y Report $ if indicator is True Report blank if indicator is False. P6 RNC Reports the PERMIT_STATUS_DESC PERMIT_STATUS_CODE Status RNC Status of (NC = Noncompliant, RE = Resolved, RP = the Permit: Resolved Pending, CO = Compliant for Report coordinator's) if should go to Permit Status on icis_perm_rnc_history Designator is NC logic is if icis_perm_rnc_man_status_code is Report present, use that to get the status category, else Resolved if use icis_perm_rnc_auto_status_code Permit Status Designator is RE Report Resolved Pending if Permit Status Designator is RP P7 Permit Not displayed on report; used for sorting Status Sort Based on PERMIT_STATUS_DESC: NC = 1 RE = 1 RP = 2
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
NPDES_Reports_v1.44.docx