L5 Begin on Comments Violation linked to LNK_ENF_COMMENTS_LVL1 Linked FO: First an EA or FO: icis_enf_conclusion.qncr_comment_text Level and Informal Continue Enforcement Linked Formal EA: to Action: always Multiple Report Levels Formal Linked Informal EA: until Enforcement always entire Action: Comment Report is printed Final Order: Report the QNCR Comment Text from the Final Order. Violation not linked to an EA or FO: Report blank. D1 First Enforcement Report the Final Populated for Compliance Schedule and icis_enf_conclusion.enf_conclusion_action_code then Level Action (Source) Order Type Enforcement Action Limit Violations get: Description if a SRC_FO_LVL1_SOURCE_FO_DESC ref_enf_conclusion_action.enf_conclusion_action_desc Source Final Order exists; otherwise, the field is blank. D2 First Enforcement Report Populated for Compliance Schedule and icis_enforcement.enf_identifier||’-‘|| “Final Level Action (Source) Order: Enforcement Action Limit Violations icis_enf_conclusion.enf_conclusion_nmbr ” concatenated SRC_FO_LVL1_SOURCE_FO_ID with the Formal Enforcement Action Identifier and the Final Order Identifier if a Source Final Order exists; otherwise the field is 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
NPDES_Reports_v1.44.docx