ICIS_ASYNC_CONTROLLER_STATE Added new NULLABLE columns to ICIS_ASYNC_TRANSACTION: EP-664 Update existing ICIS Added new NULLABLE columns to ICIS_PROG_RPT to track Total operational Volume, Reporting dates, Addl. Info: database tables for Biosolids Added new NULLABLE columns to XREF_PROG_RPT_CONTACT, XREF_PROG_RPT_ADDRESS to track affiliation type and dates: Added new NULLABLE column to REF_PROGRAM_REPORT_TYPE: EP-207 Create new ICIS Added all the following new tables (see tables for BioSolids_Program_Report_Database_Design_Final.docx for Biosolids detailed database column names, types and nullability) reporting Ref_NPDES_Data_Group Ref_Reporting_Obligation Ref_Bio_Treatment_Process Ref_Bio_Mgmt_Practice_Handler Ref_Bio_Mgmt_Practice_Type
ICIS_ASYNC_CONTROLLER_STATE Added new NULLABLE columns to ICIS_ASYNC_TRANSACTION: EP-664 Update existing operational database tables for Biosolids ICIS Added new NULLABLE columns to ICIS_PROG_RPT to track Total Volume, Reporting dates, Addl. Info: Added new NULLABLE columns to XREF_PROG_RPT_CONTACT, XREF_PROG_RPT_ADDRESS to track affiliation type and dates: Added new NULLABLE column to REF_PROGRAM_REPORT_TYPE: EP-207 Create new tables for Biosolids reporting ICIS Added all the following new tables (see BioSolids_Program_Report_Database_Design_Final.docx for detailed database column names, types and nullability) Ref_NPDES_Data_Group Ref_Reporting_Obligation Ref_Bio_Treatment_Process Ref_Bio_Mgmt_Practice_Handler Ref_Bio_Mgmt_Practice_Type
Summary_of_all_ICIS_7_5_Structure_v2.docx