CL4 Party/Action CL4: Report the Final ENF_CONCLUSION_ACTION_DESC Vio linked to informal EA: Order Type xref_enf_type.enf_type_code for the EA's activity Description or the then get: Informal EA Action ref_enf_type.enf_type_desc type; Formal EA with no FO gets literal Vio linked to Formal EA and not to an FO: "Under text ‘Under Enforcement Review" 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 EA_STATUS_DESC Vio linked to informal EA: blank Enforcement Action (Activity) Status for Vio linked to Formal EA and not to an FO: blank linked FO, otherwise 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 EA_STATUS_DATE Vio linked to informal EA: blank Enforcement Action (Activity) Status Date Vio linked to Formal EA and not to an FO: blank for linked FO, otherwise blank. Vio linked to FO: use icis_activity.activity_status_date for linked EA/FO CL7 Formal/Informal Report if a FORMAL_INFORMAL if icis_activity.activity_type_code = 'AIF', "Informal" “Formal” Formal EA, if icis_activity.activity_type_code in ('JDC','AFR'), if an "Formal" “Informal” informal EA CL8 C.S.? Report if a COMP_SCHED_FOR_LINKED_FO_FLAG If using a linked FO, if the “YES” Compliance icis_enf_conclusion.enf_conclusion_id exists in Schedule exists for icis_comp_schedule, then the FO has a schedule and the Final Order for value = Y the Permit, otherwise report Linked FO “NO” – only
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
NPDES_Reports_v1.44.docx