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 Column in Number Field Report Rule Underlying Logic ICIS_QNCR_RPT_OFFICIAL_SEL on Rpt R.5 Data Reports the date CREATED_DATE Date the record was created in the (i.e., Run the QNCR the date the process was run that created the Date was record) created in MM/DD/YYYY format. R1 Date Reports the N/A Generated in report as current date; not current system stored in date in MM/DD/YYYY format. R2 Region Reports the EPA_REGION_CODE using STATE_CODE get Region Code for ref_state.region_code the Region to which the Permit(s) on the page belong.
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
NPDES_Reports_v1.44.docx