Table 2.23. Screen Navigation: Link CM Activity Entry Point User Action Exit Point Home → Search Facility → Facility Search Results → View/Edit Facility → Compliance Monitoring tab→ List Compliance Monitoring → View/Edit Compliance Monitoring Activity → Linked Compliance Monitoring Activities → List to Link → List of Compliance Monitoring Activities Eligible to be Linked User selects records and selects Link. System creates links between the selected records to the current record and navigates to the Linked Compliance Monitoring Activities List. Cancel System does not link the records and navigates to the Linked Compliance Monitoring Activities List. Home → Search Compliance Monitoring → Search Compliance Monitoring → View/Edit Compliance Monitoring Activity → Linked Compliance Monitoring Activities → List to Link → List of Compliance Monitoring Activities Eligible to be Linked User selects records and selects Link. System creates links between the selected records to the current record and navigates to the Linked Compliance Monitoring Activities List. User selects Add/Link Compliance Monitoring dropdown System navigates to the selected Add Compliance Monitoring screen. Cancel System does not link the records and navigates to the Linked Compliance Monitoring Activities List. Table 2.24. Screen Navigation: Unlink CM Activity provides navigation flow for unlinking a Compliance Monitoring Activity record and another existing Compliance Monitoring Activity record. Entry Point describes how the user navigates to the specific screen to perform the action. User Action describes the actions performed by the user on the screen. Exit Point describes the results of the user’s action. Table 2.24. Screen Navigation: Unlink CM Activity Entry Point User Action Exit Point Home → Search Facility → Search Results-List Facility → View/Edit Facility → Compliance Monitoring → List Compliance Monitoring → View/Edit Compliance Monitoring Activity → Linked Compliance Monitoring Activities → Linked Compliance Monitoring Activities List User selects records and selects Unlink. System removes links between the selected records from the current record and navigates to the Linked Compliance Monitoring Activities List. Home → Search Compliance Monitoring → Search Compliance Monitoring → View/Edit Compliance Monitoring Activity → Linked Compliance Monitoring Activities → Linked Compliance Monitoring Activities List User selects records and selects Unlink. System removes links between the selected records from the current record and navigates to the Linked Compliance Monitoring Activities List. Table 2.25. Compliance Monitoring Activity List Screen Details lists the data elements and their sources and formatting for the List of Compliance Monitoring Activities Linked to the <Module> screen.
Registration Number N N N N/A Free Text Alphanumeric 16 characters N/A Activity ID N N N N/A Free Text Numeric 19 characters N/A ICIS_Activity.Activity_ID Activity Name N N N N/A Free Text Alphanumeric 100 characters N/A ICIS_Activity.Activity_Name Activity Type N N N N/A Dropdown REF_Activity_Type Sort Order: Alphabetic - Ascending Order by Activity Type Description Category N N N N/A Dropdown REF_Comp_Monitor_Category Sort Order: Alphabetic - Ascending Order by Compliance Monitoring Category Description Derive using Compliance Monitoring ID N N N N/A Free Text Alphanumeric 25 characters N/A
Compliance Monitoring Type N N N N/A Multiselect Display for the Activity Type and Federal Statute selected REF_Comp_Monitor_Type Sort by Alphabetic – Ascending Order by Compliance Monitoring Type Description Valid values: Values currently in REF_Comp_Monitor_Type Agency Type N N N N/A Multi-Select Display REF_Agency_Type Valid values: Values in REF_Agency_type for Activity_Group_Code = CMM Sort Order: Alphabetical – Ascending by Agency Type Description Compliance Monitoring Activity Start Date (From, To) N N N N/A Date Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Activity End Date (From, To) N N N N/A Date Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Actual_End_Date
EPA Region N N N N/A Multiselect Display REF_Region Sort by Alphabetic – Ascending Order by Region Description Valid values: Values currently in REF_Region Address N N N N/A Free Text Alphanumeric 50 characters N/A ICIS_Facility_Interest.Address City N N N N/A Free Text Alphanumeric 60 characters N/A ICIS_Facility_Interest.City State-EPA Region Code N N N N/A Free Text Alphanumeric 5 characters N/A State N N N Filter by Region if selected Dropdown Display REF_State Sort by Alphabetic – Ascending Order by State Description Valid values: Values currently in REF_State Zip Code N N N N/A Free Text Alphanumeric 14 characters N/A ICIS_Facility_Interest.Zip
City Code N N N Filter by State if selected Autocomplete, single select Display for REF_City Sort by Alphabetic – Ascending Order by City Name Valid values: Values currently in REF_City ICIS_Facility_Interest.City_Code Country N N N N/A Dropdown Display REF_Country Sort by Alphabetic – Ascending Order by Country Description Valid values: Values currently in REF_Country County N N N Filter by State if selected Autocomplete, multi-select Display REF_County Sort by Alphabetic – Ascending Order by County Description Valid values: Values currently in REF_County
LCON N N N Filter by State if selected Multi-select Display REF_Air_LCON Sort by Alphabetic – Ascending Order by LCON Description Valid values: Values currently in REF_Air_LCON Air Programs N N N N/A Multi-select with Autocomplete Air Programs on Air Screen for Delegated Agency Display Air DA Programs as (Program_Code) Display Federal Air Programs as where (Program_Code) REF_Program Filter where program_category_code = AIR Sort Order: Ascending: order by ref_program.air_sort_order Pollutants N N N N/A Autocomplete, multi-select Display REF_Pollutant Sort by Alphabetic – Ascending Order by Pollutant Description Valid values: Active values in REF_Pollutant where Pollutant_Category_Code = ‘AIR’ E)
Stack Test Test Results N N N N/A Multiselect REF_Air_Stack_Test_Status Sort by Alphabetic – Ascending Order by Test Result Status Description Valid values: Values in REF_Stack_Test_Result Search Results/List Screens Compliance Monitoring ID N N N N/A Uneditable N/A Activity ID N N N N/A Uneditable N/A ICIS_Activity.Activity_ID Activity Name N N N N/A Uneditable N/A ICIS_Activity.Activity_Name Programmatic ID/ Facility Site Name N N N N/A Uneditable Display in Programmatic ID/Facility Site Name Pairs If multiple facilities, hard return between each value and order alphabetically N/A Activity Type N N N N/A Uneditable Display N/A
Screen Navigation Actions Table 3.21. Screen Navigation: View/Edit FE&C CM Activity provides a list of the navigation options when editing an FE&C Compliance Monitoring record. Entry Point describes how the user navigates to the specific screen to perform the action. User Action describes the actions performed by the user on the screen. Exit Point describes the results of the user’s action. Table 3.21. Screen Navigation: View/Edit FE&C CM Activity Entry Point User Action Exit Point Home → Search Facility → Facility Search Results → View/Edit Facility → Compliance Monitoring tab → View/Edit Compliance Monitoring Activity Save System saves the record and remains on the View/Edit screen of the current record. Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Copy & Create New System saves the record and navigates to the Add Compliance Monitoring Activity screen. Add/Link Case File System saves the record and navigates to the selected Add Case File screen. Cancel System does not save the record and navigates to the Home screen. Home → Search Compliance Monitoring → Search Compliance Monitoring Activities Results → View/Edit Compliance Monitoring Activity Save System saves the record and remains on the View/Edit screen of the current record. Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Copy & Create New System saves the record and navigates to the Add Compliance Monitoring Activity screen. Add/Link Case File System saves the record and navigates to the selected Add Case File screen. Cancel System does not save the record and navigates to Search Compliance Monitoring Activities Results screen. Home → Other Module Location → Compliance Monitoring tab→ View/Edit Compliance Monitoring Activity Save System saves the record and remains on the View/Edit screen of the current record. Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Copy & Create New System saves the record and navigates to the Add Compliance Monitoring Activity screen. Add/Link Case File System saves the record and navigates to the selected Add Case File screen.
Basic Information Basic Information:: State N N N Both Not displayed N/A Always blank for FE&C CM activities ICIS_Activity.State_Code Basic Information:: LCON N N N Air Not displayed N/A Always blank for FE&C CM activities ICIS_Activity.Air_Lcon_Code Basic Information:: Lead Agency N Y N Air For State records, value is State. For LCON records, value is Local Dropdown Length of Largest Value Display where REF_Agency_Type values where Basic Information:: Compliance Monitoring Activity Name Y N N Both N/A Alphanumeric Free-form text Max Length 100 characters N/A ICIS_Activity.Activity_Name Linked Facility Linked Facility:: Programmatic ID Y Y N Both N/A Alphanumeric Max Length 18 characters N/A
Linked Facility:: Program System Acronym N N N Both N/A Alphanumeric Free-form text Max Length 10 characters Must be active in REF_System. Linked Facility:: Facility Site Name Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: Address Street 1 N N N Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: Address Street 2 N N N Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: County N N N Both N/A Display where REF_County Linked Facility:: State N N N Both N/A Alphanumeric Max Length 2 characters N/A Linked Facility:: Zip Code N N N Both N/A Numeric Max Length 14 characters N/A ICIS_Facility_Interest.Zip Linked Facility:: FRS ID N N N Both N/A Alphanumeric Max Length 12 characters N/A
Statutes/Sections/Programs/Compliance Monitoring Type Federal Statute:: Federal Statute Y Y N Both N/A Dropdown REF_Statute Sort Order: Alphabetic - Ascending Order by Statute Code Law Sections:: Law Sections Y Y N FE&C N/A Multiselect Display Statute Code: Law Section Code: Law Section Description REF_Law_Section Valid values: Values currently in REF_Law_Section where Activity_Group_Code=CMM for Federal Statute Selected Sort Order: Alphabetic – Ascending Order by Statute Code, Law Section Code Programs:: Programs Y Y N FE&C N/A Multi-select with Autocomplete Display Uneditable by user REF_Program Valid values: Values currently in REF_Program for Federal Statute/Law Sections selected Sort Order: Alphabetic - Ascending Order by Program Description Programs:: Program Description N N N Air N/A Alphanumeric Max Length 100 characters N/A
Compliance Monitoring Type:: Compliance Monitoring Type Y Y N Both N/A Multiselect Display for the Activity Type and Federal Statute selected REF_Comp_Monitor_Type Sort by Alphabetic – Ascending Order by Compliance Monitoring Type Description Valid values: Values currently in REF_Comp_Monitor_Type Compliance Monitoring Compliance Monitoring Method N N Y FE&C N/A Dropdown Display REF_Comp_Monitor_Type Valid values: Status Flag = Active Sort Order: Alphabetic – Ascending Order by Biomonitoring Method Description
Compliance Monitoring Dates:: Planned End Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Actual Start Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Actual End Date N Y N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Actual_End_Date
Compliance Monitoring Reason Compliance Monitoring Monitoring Action Reason Y Y N Both N/A Multiselect Display REF_Activity_Purpose Valid values: Active values in REF_Activity_Purpose for the Activity Type Sort Order: Alphabetical – Ascending by Activity Purpose Description Compliance Monitoring Agency Compliance Monitoring Monitoring Agency Type Y Y N Both N/A Dropdown Display REF_Agency_Type Valid values: Active values in REF_Agency_type for Activity_Group_Code = CMM Sort Order: Alphabetical – Ascending by Agency Type Description Compliance Monitoring Monitoring Agency Name N N N Both N/A Dropdown Display REF_Agency Valid values: Active values in REF_Agency Sort Order: Alphabetical – Ascending by Agency Description
NAICS Codes NAICS Codes:: NAICS Codes N N N Both N/A Multi-select Search Autocomplete Display REF_NAICS Valid Values: Active values currently in REF_NAICS Sort Order: Ascending by NAICS Code SIC Codes SIC Codes:: SIC Codes N N N Both N/A Multi-select Search Autocomplete Display REF_SIC.SIC_Code REF_SIC.SIC_Desc REF_SIC Valid Values: Active values currently in REF_SIC Sort Order: Ascending by SIC Code XREF_Activity_SIC.SIC_Code Compliance Monitoring Details Compliance Monitoring Details::If State, Local, or Tribal Lead, did EPA Assist? N N N FE&C N/A Defaults to N for State NPDES Activities Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) ICIS_Activity.EPA_Assist_Flag Compliance Monitoring Details::Was this a State, Federal, or Joint (State/Federal) Compliance Monitoring Activity? N N N FE&C N/A Dropdown Valid values: Blank State (stored as S) Federal (stored as Joint (State/Federal) (stored as J)
ICDS::Water Pollutants N N N FE&C N/A Multiselect Display REF_Corrective_Action Valid values: Active values in REF_Pollutant where = ‘WTR’ Sort Order: Alphabetical – Ascending by Pollutant Description ICDS::Air Pollutants N N N FE&C N/A Multiselect Display REF_Corrective_Action Valid values: Active values in REF_Pollutant where = ‘AIR’ Sort Order: Alphabetical – Ascending by Pollutant Description ICDS::Did you provide general Compliance Assistance in accordance with the policy on the role of the EPA Inspector in providing Compliance Assistance during inspections? N N N FE&C N/A Dropdown Valid values: Blank Yes (stored as Y) No (stored as N)
ICDS:: Did you provide Compliance Assistance in accordance with the policy on the role of the EPA Inspector in providing Compliance Assistance during the Inspection? N N N FE&C N/A Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Citations Citations::Title N N N FE&C 40 CFR Alphanumeric Free-form text Max Length 50 characters N/A ICIS_CITATION.Citation_Title Citations::Part N N N FE&C N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_CITATION.Citation_Part N N N FE&C N/A Alphanumeric Free-form text Max Length 100 characters N/A
Priorities Priorities:: OECA National Priority N N N Both N/A Multiselect Length of Largest Value REF_Priority where Region_Code=HQ Sort Order: Reverse Chronological Order by Fiscal Year Alphabetic – Ascending Order by Priority Description Priorities:: EPA Regional Priority N N N Both N/A Multiselect Length of Largest Value REF_Priority where Region_Code < > HQ Sort Order: Reverse Chronological Order by Fiscal Year Alphabetic – Ascending Order by Region Name Alphabetic – Ascending Order by Priority Initiatives:: Other Agency Initiative N N N Air N/A Alphanumeric Free-form text Max Length 200 characters N/A Compliance Monitoring Information CM Information:: Number of Days Physically Conducting Activity N N N FE&C N/A Numeric Max Length 10 characters N/A
CM of Hours Physically Conducting Activity N N N FE&C N/A Numeric Max Length 10 characters N/A CM Information:: Compliance Monitoring Action Outcome N N N FE&C N/A Dropdown Display REF_Activity_Outcome Valid values: Active values in REF_Activity_Outcome for Activity Type Code Sort Order: Alphabetical – Ascending by Activity Outcome Description CM Information:: Compliance Monitoring Rating Code N N N FE&C N/A Dropdown Display REF_Insp_Rating Valid values: Active values in REF_Insp_Rating Sort Order: Alphabetical – Ascending by Inspection Rating Description
Organization Number N N N Both N/A Numeric Max Length 10 number N/A (Note: where Organization Number:: ext N N N Both N/A Numeric Max Length 4 numbers N/A (Note: where Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Information::Fax Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where
Organization Address N N N Both N/A Alphanumeric Max Length 100characters N/A Organization N N N Both N/A Single select Dropdown Length of Largest Value REF_Region.Region_Code Sort Order: Alphabetic - Ascending by Region_Code ICIS_Contact.Region_Code Organization N N N Both N/A Single select dropdown Max Length 2 characters REF_State.State_Code Sort Order: Alphabetic - Ascending by State_Code ICIS_Contact.State_Code Media Media::Media Monitored N N N FE&C N/A Dropdown Display REF_Media Valid values: Active values in REF_Media Sort Order: Alphabetical – Ascending by Media Description Monitoring Multimedia Indicator N N N Both No Checkbox Valid Values: Yes No (default) ICIS_Activity.Multimedia_Flag
Cross Media Indicators Cross Media Indicators:: Federal Facility Activity N N N Both N/A Dropdown Length of Largest Value Display where REF_Cross_Media_Indicator Cross Media Indicators:: Federal Facility Activity Comment N N N Both N/A Alphanumeric Free form text Max Length 4000 characters N/A User Defined Fields User Defined Fields:: 1 N N N Both N Checkbox Valid Values: Yes No ICIS_Regional_Data.String1 User Defined Fields:: 2 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String2 User Defined Fields:: 3 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String3
Basic Information Continued Created By N N N Both System generated based on User ID Alphanumeric Max Length 30 characters N/A ICIS_Activity.Created_By Created Date N N N Both System generated based on date of data entry Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Created_Date Last Modified By N N N Both System generated based on User ID Alphanumeric Max Length 30 characters N/A ICIS_Activity.Updated_By Last Modified Date N N N Both System generated based on date of data entry Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Updated_Date
will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 3.52. FE&C Stack Test Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column Stack Test Basic Information Basic Information:: Unit or Stack Identifier N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_Stack_Test.Unit_Stack_UDF Basic Information:: Stack Test Status Y Y N Air Pending Single Select Dropdown Length of Largest Value REF_Air_Stack_Test_Status Valid Values: (Blank) Pass Fail Pending Incomplete Basic Information:: Other Purpose of Stack Test N N Y Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_Stack_Test.Other_Purpose Basic Information:: Observed By N N N Air N/A Multi Select Dropdown Length of Largest Value Ref_Agency_Type Basic Information:: Conducted By Y Y N Air Single Select Dropdown Length of Largest Value Default to Owner/Operator REF_Air_Conductor_Type Air_Stack_Test. Air_Conductor_Type_Code
Stack Test Dates Stack Test Dates:: Date Report Received N N N Both N/A Date Must be valid date in mm/dd/yyyy format N/A Stack Test Dates:: Date Test Results Were Reviewed N Y N Both N/A Date Must be valid date in mm/dd/yyyy format N/A Test Results Test Results:: Tested Y N N Air N/A Single Select Autocomplete REF_Pollutant where Pollutant_Category_Code = AIR Sort Order: Alphabetic – Ascending by Pollutant Name Test Results:: Test Result N N N Air N/A Single Select Dropdown REF_Air_Stack_Test_Status Valid Values (Blank) Pass Fail Pending Incomplete N/A Test Results:: Method Codes N N N Air N/A Multi-select with Autocomplete Length of Largest Value REF_Air_Stack_Test_Method Sort Order: Alphabetic - Ascending
Test Results:: Allowable Value N N N Air N/A Number 18 characters (if decimal places allows for 1 decimal place and 17 numbers) Minimum value is and maximum value is N/A Test Results:: Allowable Unit N N N Air N/A Single Select Search Typeahead REF_Pollutant_Unit Test Results:: Actual Value N N N Air N/A Number 18 characters (if decimal places allows for 1 decimal place and 17 numbers) Minimum value is and maximum value is N/A Test Results:: Actual Unit N N N Air Defaults to the value selected in Allowable Units Single Select Search Typeahead REF_Pollutant_Unit
Basic Information:: Certification Period End Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A Basic Information:: Facility Reported Compliance Status N Y N Air N/A Single Select Dropdown Length of Largest Value REF_Air_Fac_Rpt_Compliance Valid Values: (Blank) Continuous Intermittent Air_TVACC. Air_Fac_Rpt_Compliance_Code TV ACC Review TV ACC Review:: Reviewed Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A TV ACC Review:: Did Facility Report Deviations? N N N Air N/A Radio Buttons Yes No Valid Values: (Blank) N Y TV ACC Review:: Permit Conditions N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A TV ACC Review:: N N N Air N/A Radio Buttons Yes No Valid Values: (Blank) N Y Air_TVACC_Review. Excess_Excursion_Flag
that will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 3.53. CAFO Component Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column General Information General Info::Is the Animal Facility Type a CAFO? N N N FE&C N/A Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) General Info::CAFO Classification N N Y FE&C N/A Dropdown Display REF_CAFO_Classification Valid values: Active values in REF_CAFO_Classification Sort Order: Alphabetical – Ascending by CAFO Classification Description General Info::CAFO Designation Date N N Y FE&C N/A Date Must be valid date in mm/dd/yyyy format Must be less than or equal to current date N/A General Info::Designation Reason N N Y FE&C N/A Alphanumeric Max Length 500 characters N/A
General Info::Discharges During Year from Production Area N N N FE&C N/A Dropdown Display REF_Authorized_Discharge Valid values: Active values in REF_Authorized_Discharge Sort Order: Alphabetical – Ascending by Authorized Discharge Description Solid and Liquid Manure Solid and Liquid Manure:: Solid Manure or Litter Generated (Tons) N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Solid and Liquid Manure::Liquid Manure or Wastewater Generated (Gallons) N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Solid and Liquid Manure::Solid Manure or Litter Transferred (Tons) N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number
Solid and Liquid Manure::Liquid Manure or Wastewater Transferred (Gallons) N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Livestock Maximum Capacity N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Capacity Determination Basis N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Livestock Capacity N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number NMP (Nutrient Management Plan) NMP::Does the facility have an NMP developed or approved by a certified planner? N N N FE&C N/A Dropdown Valid values: Blank Yes (stored as Y) No (stored as N)
Animal Type::Other (Specify) N N Y FE&C N/A Alphanumeric Free-form text Max Length 50 characters N/A Animal Type::Open Confinement Count N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Animal Type::Housed Under Roof Confinement Count N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number Animal Type::Total Number N N Y FE&C N/A Numeric Max Length 9 characters Must be a whole number Required for each animal type checked
Manure, Litter, and Processed Wastewater Storage Type Manure, Litter, and Processed Wastewater Storage::Type N N N FE&C N/A Fixed text of each active value from REF_CAFO_Storage_Type Sort Order (sort order is available in ref_storage_type.sort_order): Wastewater Treatment Lagoon Storage Lagoon Evaporation Pond Above Ground Storage Tanks Below Ground Storage Tanks Roofed Storage Shed Concrete Pad Impervious Soil Pad Underflow Pits Anaerobic Digestor Outdoor Piles None *this element is a checkbox* Other (Specify): Manure, Litter, and Processed Wastewater Storage::Other (Specify) N N Y FE&C N/A Alphanumeric Free-form text Max Length 50 characters N/A Manure, Litter, and Processed Wastewater Storage::Storage Total Capacity Measure N N N FE&C N/A Numeric Max Length 9 characters Must be a whole number
will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 3.55. CSO Component Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column Event Information Event Information:: CSO Overflow Event Date Y Y N FE&C N/A Date Must be valid date in format Must be less than or equal to current date Must be less than or equal to the current date Event Information::Dry or Wet Weather N N N FE&C N/A Dropdown Valid values: Blank Wet (stored as W) Dry (stored as D) Event (Inches) N N N FE&C N/A Numeric Max Length 5 numbers Maximum 2 decimal places Must be between 0.00 – 999.99 N/A
Longitude Decimal Degrees N N Y FE&C N/A Alphanumeric Max Length 11 characters Decimal Degrees: Alphanumeric with six decimal positions First character can be - N/A Longitude Degrees, Minutes, Seconds N N Y FE&C N/A Must be entered as HDDDMMSST, where H = + or -, DDD = degrees, MM = minutes, SS = seconds, T = tenths of a second First character is defaulted to - N/A CSO Overflow Location Street Address:: SSO Overflow Location Street Address N N Y FE&C N/A Alphanumeric Free Form Text Max Length 4000 characters N/A CSO Overflow Location Street Feature Identifier N N Y FE&C N/A Alphanumeric Free Form Text Max Length 4 characters Must be a valid value in for the NPDES ID associated with the CM; system stores the associated ICIS_Perm_Feature.Perm_Feature_ID Table 3.56. FE&C Storm Water (Municipal) Component Data Element Mapping includes the data element name as displayed on the screen, whether the field is system required (SR?), programmatically required (PR?), and conditionally required (CR?). It also provides the default values that will be displayed when the user first arrives at the Add screen, how the data will be displayed on the
screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 3.56. FE&C Storm Water (Municipal) Component Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column General Information General Annual Expenditure N N N FE&C N/A Numeric Max Length 10 numbers Whole numbers N/A General Information:: MS4 Annual Expenditure Year N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Format YYYY N/A General Budget N N N FE&C N/A Numeric Max Length 10 numbers Whole numbers N/A General Budget Year N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Format YYYY N/A General Sources of Funding N N N FE&C N/A Multiselect Length of Largest Value REF_Source_Funding Active values in REF_Source_Funding Sort Order: Alphabetic – Ascending Order by Impact Description
General of Major MS4 Outfalls N N N FE&C N/A Numeric Max Length 5 numbers Whole numbers N/A General Outfalls N N N FE&C N/A Dropdown Valid values: Blank Estimated (stored as E) Measured (stored as M) General of Minor MS4 Outfalls N N N FE&C N/A Numeric Max Length 5 numbers Whole numbers N/A General Outfalls N N N FE&C N/A Dropdown Valid values: Blank Estimated (stored as E) Measured (stored as M) Table 3.57. Storm Water (Non-Municipal) Data Element Mapping includes the data element name as displayed on the screen, whether the field is system required (SR?), programmatically required (PR?), and conditionally required (CR?). It also provides the default values that will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the
Inspection of an Unpermitted Construction Site Inspection of an Unpermitted Construction Site::Project Type N N N FE&C N/A Single Select Drop Down REF_Project_Type Inspection of an Unpermitted Construction Site::Other N N N FE&C N/A Alphanumeric Free-form text Max Length 50 characters N/A Inspection of an Unpermitted Construction Site::Estimated Start Date N N N FE&C N/A Date Must be valid date in format N/A Inspection of an Unpermitted Construction Site::Estimated Complete Date N N N FE&C N/A Date Must be valid date in format N/A Inspection of an Unpermitted Construction Site::Estimated Area Disturbed N N N FE&C N/A Numeric Max Length 6 numbers Whole numbers N/A
Inspection of an Unpermitted Construction Site::Project Plan Size N N N FE&C N/A Single Select Dropdown Length of Largest Value REF_Project_Plan_Size Activate values in REF_Project_Plan_Size Sort By: Alphabetic - Ascending by Project Plan Size Description Table 3.58. Pretreatment Component Data Element Mapping includes the data element name as displayed on the screen, whether the field is system required (SR?), programmatically required (PR?), and conditionally required (CR?). It also provides the default values that will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 3.58. Pretreatment Component Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column Significant Industrial Users (SIUs) SIUs::SIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs Without Control Mechanism N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A
SIUs::SIUs Not Inspected N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs Not Sampled N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs in SNC with Pretreatment Standards N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs in SNC with Reporting Requirements N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs in SNC with Pretreatment Schedule N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::SIUs in SNC Published in Newspaper N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A
SIUs::SIUs on Schedules N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::Violation Notices Issued to SIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A Orders Issued to SIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::Civil Suits Filed Against SIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A SIUs::Criminal Suits Filed Against SIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A Categorical Industrial Users (CIUs) CIUs::CIUs N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A
CIUs::CIUs in SNC N N N FE&C N/A Numeric Max Length 4 numbers Whole numbers Valid values between 0-9999 N/A Penalties Penalties::Dollar Amount of Penalties Collected N N N FE&C N/A Numeric Max Length 14 numbers 2 Decimal Places Valid values between 0 – 999999999999.99 N/A Users (IUs) from which Penalties have been collected N N N FE&C N/A Numeric Max Length 4 numbers 2 Decimal Places Valid values between 0-9999 N/A Annual Frequency Annual Frequency of Influent Toxicant Sampling N N N FE&C N/A Numeric Max Length 2 numbers Whole numbers Valid values between 0-99 N/A Annual Frequency of Effluent Toxicant Sampling N N N FE&C N/A Numeric Max Length 2 numbers Whole numbers Valid values between 0-99 N/A
Local Limits::Local Limit Pollutants N N N FE&C N/A Search Multiselect Length of Largest Value Display Pollutant Code Pollutant Description REF_Pollutant Active values in REF_Pollutant Sort Order: Alphabetic – Ascending Order by Pollutant Description Removal Credits Removal Credits::Removal Credits Application Status N N N FE&C Defaults to Not Applicable Single Select Dropdown Length of Largest Value REF_Removal_Status Activate values in REF_Removal_Status Sort By: Alphabetic - Ascending by Removal_Status Description Removal Credits::Date of Most Recent Removal Credits Approval N N Y FE&C N/A Date Must be valid date in format Must be less than or equal to today’s date N/A Removal Credits::Removal Credits N N Y FE&C N/A Search Multiselect Length of Largest Value Display Pollutant Code Pollutant Description REF_Pollutant Active values in REF_Pollutant Sort Order: Alphabetic – Ascending Order by Pollutant Description Acceptance of Waste Acceptance of of Hazardous Waste N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N)
Acceptance of of Industrial Waste N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Acceptance of of Hauled Domestic Wastes N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Deficiencies Identified During IU File Review N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Mechanism Deficiencies N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Authority Deficiencies N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) of Sampling and Inspections N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N)
of Pretreatment Resources N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) in Data Management and Public Participation N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) in Interpretation and Application of Pretreatment Standards N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Deficiency_Interpretation_Flag Deficiencies:: Inadequacy of Sampling and Inspections N N N FE&C Defaults to N Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) Deficiencies:: Adequacy of Pretreatment Resources N N N FE&C Defaults to Y Dropdown Valid values: Blank Yes (stored as Y) No (stored as N)
Compliance Monitoring Category Y N N Both N/A Display Data Only in Context Header Alphanumeric Max Length 100 characters Display where REF_Comp_Monitor_Category EPA Region N N N Both System Generated based on user’s region in for regional users; selected from picklist by HQ users Display Data Only in Context Header Display Alphanumeric Max Length 2 characters N/A ICIS_Activity.Region_Code
Basic Information Basic Information:: State N N N Both System Generated based on user’s state in for state users; selected from picklist by EPA users Dropdown Length of Largest Value Display REF_State values where REF_State.Usage_Indicator in (‘B’,’N’) Order by State Code Ascending ICIS_Activity.State_Code Basic Information:: LCON N N N Air Not displayed N/A Always blank for State NPDES CM activities ICIS_Activity.Air_Lcon_Code Basic Information:: Lead Agency N Y N Air For State records, value is State. For LCON records, value is Local Dropdown Length of Largest Value Display where REF_Agency_Type values where
Basic Information:: Compliance Monitoring Activity Name N N N Both N/A Alphanumeric Free-form text Max Length 100 characters N/A ICIS_Activity.Activity_Name Basic Information:: Compliance Monitoring Type Y Y N Both N/A Multiselect Display for the Activity Type and CWA REF_Comp_Monitor_Type Sort by Alphabetic – Ascending Order by Compliance Monitoring Type Description Valid values: Values currently in REF_Comp_Monitor_Type Basic Compliance Monitoring Method N N Y FE&C N/A Dropdown Display REF_Comp_Monitor_Type Valid values: Status Flag = Active Sort Order: Alphabetic – Ascending Order by Biomonitoring Method Description Linked Facility Linked Facility:: Programmatic ID Y Y N Both N/A Alphanumeric Max Length 18 characters N/A Linked Facility:: Program System Acronym N N N Both N/A Alphanumeric Free-form text Max Length 10 characters Must be ‘NPDES’
Linked Facility:: Facility Site Name Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: Address Street 1 N N N Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: Address Street 2 N N N Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: County N N N Both N/A Display where REF_County Linked Facility:: State N N N Both N/A Alphanumeric Max Length 2 characters N/A Linked Facility:: Zip Code N N N Both N/A Numeric Max Length 14 characters N/A ICIS_Facility_Interest.Zip Linked Facility:: FRS ID N N N Both N/A Alphanumeric Max Length 12 characters N/A ICIS_Facility_Interest. Facility_UID Statutes/Programs Federal Statute:: Federal Statute Y Y N Both N/A Uneditable Always set to CWA N/A
Law Sections:: Law Sections Y Y N NPDES N/A Not displayed Always set to CWA, OTHER Programs:: Programs Y Y N NPDES Defaults to “NPDES – Base Program (Limits, Reporting, Schedule)” Multi-select with Autocomplete Display Uneditable by user REF_Program Valid values: Active values in REF_Program where Program_Category_Code = ‘NPDES’ Sort Order: Alphabetic - Ascending Order by Program Description Programs:: State Statutes N N N NPDES N/A Alphanumeric Max Length 100 characters N/A Program Deficiencies N N N box Display as Program Deficiency Category: Program Deficiency Description Filter by Program Code(s) associated to the Compliance Monitoring Activity (program_code) Ref_Prog_Deficiency Sort by Compliance Monitoring Dates
Compliance Monitoring Dates:: Planned Start Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Planned End Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Actual Start Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A
NAICS Codes NAICS Codes:: NAICS Codes N N N Both N/A Multi-select Search Autocomplete Display REF_NAICS Valid Values: Active values currently in REF_NAICS Sort Order: Ascending by NAICS Code SIC Codes SIC Codes:: SIC Codes N N N Both N/A Multi-select Search Autocomplete Display REF_SIC.SIC_Code REF_SIC.SIC_Desc REF_SIC Valid Values: Active values currently in REF_SIC Sort Order: Ascending by SIC Code XREF_Activity_SIC.SIC_Code Compliance Monitoring Details Compliance Monitoring Details::If State, Local, or Tribal Lead, did EPA Assist? N N N Both Defaults to N for State NPDES Activities Dropdown Valid values: Blank Yes (stored as Y) No (stored as N) ICIS_Activity.EPA_Assist_Flag Compliance Monitoring Details::Was this a State, Federal, or Joint (State/Federal) Compliance Monitoring Activity? N N N Both N/A Dropdown Valid values: Blank State (stored as S) Federal (stored as E) Joint (State/Federal) (stored as J)
Initiatives:: Other Agency Initiative N N N Air N/A Alphanumeric Free-form text Max Length 200 characters N/A Compliance Monitoring Information CM Information:: Number of Days Physically Conducting Activity N N N Both N/A Numeric Max Length 10 characters N/A CM of Hours Physically Conducting Activity N N N Both N/A Numeric Max Length 10 characters N/A CM Information:: Compliance Monitoring Action Outcome N N N Both N/A Dropdown Display REF_Activity_Outcome Valid values: Active values in REF_Activity_Outcome for Activity Type Code Sort Order: Alphabetical – Ascending by Activity Outcome Description
CM Information:: Compliance Monitoring Rating Code N N N Both N/A Dropdown Display REF_Insp_Rating Valid values: Active values in REF_Insp_Rating Sort Order: Alphabetical – Ascending by Inspection Rating Description Government Contacts Affiliation Type Both N/A Display where Dropdown Length of Largest Value Dropdown filtered based on Affiliation_Category Sort By: Alphabetic by Affiliation_Type_Desc First Name Both N/A Display only Max Length 30 characters N/A ICIS_Person.First_Name Last Name Both N/A Display only Max Length 30 characters N/A ICIS_Person.Last_Name Office Both N/A Display only Max Length 100 characters Sort Order: Alphabetic by Office_Name ICIS_Office.Office_Name
Organization Both N/A Display only Max Length 50 characters Sort Order: Alphabetic by Organization_Name Start Date of Association Both Current Date Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A End Date of Association Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Non-Government Contacts Personal Type Y N N Both N/A Single Select Drop Down REF_Affiliation.Affiliation_Type Dropdown filtered based on Affiliation_Category Sort By: Alphabetic - Ascending by Affiliation_Type_Desc Personal Name Y N N Both N/A Alphanumeric Free-form text Max Length 30 characters N/A ICIS_Contact.First_Name
Organization N N N Both N/A Alphanumeric Free-form text Max Length 80 characters Sort Order: Alphabetic - Ascending by Organization_Name Organization Number N N N Both N/A Numeric Max Length 10 number N/A (Note: where Organization Number:: ext N N N Both N/A Numeric Max Length 4 numbers N/A (Note: where Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Information::Fax Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where
Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Address N N N Both N/A Alphanumeric Max Length 100characters N/A Organization N N N Both N/A Single select Dropdown Length of Largest Value REF_Region.Region_Code Sort Order: Alphabetic - Ascending by Region_Code ICIS_Contact.Region_Code Organization N N N Both N/A Single select dropdown Max Length 2 characters REF_State.State_Code Sort Order: Alphabetic - Ascending by State_Code ICIS_Contact.State_Code Media Media::Media Monitored N/A Dropdown Display REF_Media Valid values: Active values in REF_Media Sort Order: Alphabetical – Ascending by Media Description Monitoring Multimedia Indicator No Checkbox Valid Values: Yes No (default) ICIS_Activity.Multimedia_Flag
Cross Media Indicators Cross Media Indicators:: Federal Facility Activity N N N Both N/A Dropdown Length of Largest Value Display where REF_Cross_Media_Indicator Cross Media Indicators:: Federal Facility Activity Comment N N N Both N/A Alphanumeric Free form text Max Length 4000 characters N/A User Defined Fields User Defined Fields:: 1 N N N Both N Checkbox Valid Values: Yes No ICIS_Regional_Data.String1 User Defined Fields:: 2 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String2 User Defined Fields:: 3 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String3
User Defined Fields:: 4 N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Regional_Data.Date1 User Defined Fields:: 5 N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Regional_Data.Date2 User Defined Fields:: 6 N N N Both N/A Alphanumeric Free-form text Max Length 4000 characters N/A ICIS_Regional_Data.String4 Comments Comments N N N Both N/A Alphanumeric Free-form text Max Length 4000 characters N/A and is blank
Sub Activities Sub Activity Type Y N N Fed N/A Display where = Dropdown Length of Largest Value Dropdown filtered based on Activity_Type_Code in (INS, INV, INF, OSR) and Status_Flag = A Sort By: Alphabetic by Sub_Activity_Type_Desc Planned Date N N N Fed N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Sub_Activity.Planned_Date Actual Date N N N Fed N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Sub_Activity.Actual_Date
Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Cancel System does not save the record and navigates to the Home screen. Home → Search Compliance Monitoring Activities → Compliance Monitoring Search Results → Add Compliance Monitoring Activity → Select Compliance Monitoring Type Stack Test Save System saves the record and remains on the View/Edit screen of the current record. Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Cancel System does not save the record and navigates to the Home screen. Home → Other Module Location → Compliance Monitoring tab→ Add Compliance Monitoring Activity → Select Compliance Monitoring Type Stack Test Save System saves the record and remains on the View/Edit screen of the current record. Save and Add Another System saves the record and navigates to the Add Compliance Monitoring Activity screen. Cancel System does not save the record and navigates to the Home screen. Sample Screen Delegated Agency Compliance Monitoring Activity screens will vary slightly depending on the Activity Type: Inspection/Evaluation, Investigation, or Information Request. Additionally the Inspection/Evaluation screens will vary based on Compliance Monitoring Type: FCE/PCE, Stack Test, TV ACC. The following is a list of additional data areas on the Add Inspection/Evaluation screen when Stack Test is selected as the Compliance Monitoring Type: Purpose of Stack Test Observed By Conducted By Stack Test Dates Test Results The following sample screens illustrate the Add Inspection/Evaluation Compliance Monitoring screen with Stack Test data from the perspective of a State user. Figure 5.51. Add Stack Test
TVA-015E1 When the Edit TV ACC Review screen is displayed, if Reviewer Agency is not already populated, it will default to Tribe (TRB) if the user is a State user and the state is a tribe. It can be edited. N/A Edit TVA-015F When the Edit TV ACC Review screen is displayed, if Reviewer Agency is not already populated, it will default to Local (LCL) if the user is an LCON user. It can be edited. N/A Edit TVA-018 The system shall ensure that the Reviewed Date is greater than or equal to the Actual End Date. Reviewed Date must be greater than or equal to the Actual End Date. Add, View/Edit TVA-019 The system shall set the TV ACC Review Web Entry Flag to Y when a TV ACC Review is created. N/A Add, View/Edit
Basic Information:: Lead Agency N Y N Air For State records, value is State. For LCON records, value is Local Dropdown Length of Largest Value Display where REF_Agency_Type values where Basic Information:: Compliance Monitoring Activity Name N N N Both N/A Alphanumeric Free-form text Max Length 100 characters N/A ICIS_Activity.Activity_Name Linked Facility Linked Facility:: Programmatic ID Y Y N Both N/A Alphanumeric Max Length 18 characters N/A Linked Facility:: Program System Acronym N N N Both N/A Alphanumeric Free-form text Max Length 10 characters N/A Linked Facility:: Facility Site Name Both N/A Alphanumeric Max Length 50 characters N/A Linked Facility:: Address Street 1 N N N Both N/A Alphanumeric Max Length 50 characters N/A
Compliance Monitoring Dates:: Planned End Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Actual Start Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Compliance Monitoring Dates:: Actual End Date N Y N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Actual_End_Date Statutes Statutes:: Federal Statutes Y Y N Both CAA Dropdown REF_Statute Sort Order: Alphabetic - Ascending Order by Statute Code
Air Programs Air Programs:: Air Programs Y Y N Both N/A Multi-select with Autocomplete Air Programs on Air Screen for Delegated Agency Display as (Program_Code) REF_Program Filter where program_category_code = AIR and ref_program.activity_filter_code has ref_activity_filter.air_da_flag = Y Sort Order: Ascending: order by ref_program.air_sort_order Air Programs:: Program Description N N N Air N/A Alphanumeric Max Length 100 characters N/A Pollutants Pollutants:: Pollutants Involved N N N Both N/A Add Multi Values with Autocomplete on Air Screen for Delegated Agency Length of Largest Value REF_Pollutant where Pollutant_Category_Code - AIR Sort Order: Alphabetic – Ascending by Pollutant Name Initiatives Initiatives:: EPA National Initiative N N N Both N/A Multiselect Length of Largest Value REF_Priority where Region_Code=HQ Sort Order: Reverse Chronological Order by Fiscal Year Alphabetic – Ascending Order by Priority Description
Initiatives:: EPA Regional Initiative N N N Both N/A Multiselect Length of Largest Value REF_Priority where Region_Code < > HQ Sort Order: Reverse Chronological Order by Fiscal Year Alphabetic – Ascending Order by Region Name Alphabetic – Ascending Order by Priority Initiatives:: Other Agency Initiative N N N Air N/A Alphanumeric Free-form text Max Length 200 characters N/A Government Contacts Affiliation Type Both N/A Display where Dropdown Length of Largest Value Dropdown filtered based on Affiliation_Category Sort By: Alphabetic by Affiliation_Type_Desc First Name Both N/A Display only Max Length 30 characters N/A ICIS_Person.First_Name Last Name Both N/A Display only Max Length 30 characters N/A ICIS_Person.Last_Name
Office Both N/A Display only Max Length 100 characters Sort Order: Alphabetic by Office_Name ICIS_Office.Office_Name Organization Both N/A Display only Max Length 50 characters Sort Order: Alphabetic by Organization_Name Start Date of Association Both Current Date Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A End Date of Association Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Non-Government Contacts Personal Type Y N N Both N/A Single Select Drop Down REF_Affiliation.Affiliation_Type Dropdown filtered based on Affiliation_Category Sort By: Alphabetic - Ascending by Affiliation_Type_Desc
Personal Name Y N N Both N/A Alphanumeric Free-form text Max Length 30 characters N/A ICIS_Contact.First_Name Personal Name or Initial N N N Both N/A Alphanumeric Free-form text Max Length 10 characters N/A ICIS_Contact.Middle_Name Personal Information::Last Name Y N N Both N/A Alphanumeric Free-form text Max Length 30 characters N/A ICIS_Contact.Last_Name Personal Title Y N N Both N/A Alphanumeric Free-form text Max Length 30 characters N/A ICIS_Contact.Title Contact Date N N N Both Current System Date Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A
Contact Association::End Date N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A Organization N N N Both N/A Alphanumeric Free-form text Max Length 80 characters Sort Order: Alphabetic - Ascending by Organization_Name Organization Number N N N Both N/A Numeric Max Length 10 number N/A (Note: where Organization Number:: ext N N N Both N/A Numeric Max Length 4 numbers N/A (Note: where Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where
Organization Information::Fax Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Number N N N Both N/A Numeric Max Length 10 numbers N/A (Note: where Organization Address N N N Both N/A Alphanumeric Max Length 100characters N/A Organization N N N Both N/A Single select Dropdown Length of Largest Value REF_Region.Region_Code Sort Order: Alphabetic - Ascending by Region_Code ICIS_Contact.Region_Code Organization N N N Both N/A Single select dropdown Max Length 2 characters REF_State.State_Code Sort Order: Alphabetic - Ascending by State_Code ICIS_Contact.State_Code Media Media:: Multimedia Indicator N N N Both N Checkbox Valid Values: Yes No ICIS_Activity.Multimedia_Flag
Evaluation Conclusion Evaluation Conclusion:: Were deficiencies found? N N N Air N/A Dropdown Valid Values/Sort Order: (blank) Yes No User Defined Fields User Defined Fields:: 1 N N N Both N Checkbox Valid Values: Yes No ICIS_Regional_Data.String1 User Defined Fields:: 2 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String2 User Defined Fields:: 3 N N N Both N/A Alphanumeric Free-form text Max Length 50 characters N/A ICIS_Regional_Data.String3 User Defined Fields:: 4 N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Regional_Data.Date1
User Defined Fields:: 5 N N N Both N/A Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Regional_Data.Date2 User Defined Fields:: 6 N N N Both N/A Alphanumeric Free-form text Max Length 4000 characters N/A ICIS_Regional_Data.String4 Comments Comments N N N Both N/A Alphanumeric Free-form text Max Length 4000 characters N/A and is blank Sensitive N N N Air N/A Alphanumeric Free-form text Max Length 4000 characters On Sensitive Comments list screen, only display comments with = STC or LCC set to: STC for State or LCC for LCON Sensitive Comments:: Author Air N/A Alphanumeric Max Length 30 characters N/A
Sensitive Comments:: Created By Air N/A Alphanumeric Max Length 30 characters N/A Sensitive Comments:: Created Date Air N/A Date Must be valid date in mm/dd/yyyy format N/A Basic Information Continued Created By N N N Both System generated based on User ID Alphanumeric Max Length 30 characters N/A ICIS_Activity.Created_By Created Date N N N Both System generated based on date of data entry Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Created_Date Last Modified By N N N Both System generated based on User ID Alphanumeric Max Length 30 characters N/A ICIS_Activity.Updated_By
Last Modified Date N N N Both System generated based on date of data entry Date EDT: Must be valid date in yyyy-mm-dd format Web: Must be valid date in mm/dd/yyyy format N/A ICIS_Activity.Updated_Date Table 5.102. Air Delegated Agency Stack Test Data Element Mapping includes the data element name as displayed on the screen, whether the field is system required (SR?), programmatically required (PR?), and conditionally required (CR?). It also provides the default values that will be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 5.102. Air Delegated Agency Stack Test Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column Stack Test Basic Information Basic Information:: Unit or Stack Identifier N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_Stack_Test.Unit_Stack_UDF
Basic Information:: Other Purpose of Stack Test N N Y Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_Stack_Test.Other_Purpose Basic Information:: Observed By N N N Air N/A Multi Select Dropdown Length of Largest Value Ref_Agency_Type Basic Information:: Conducted By Y Y N Air Single Select Dropdown Length of Largest Value REF_Air_Conductor_Type Stack Test Dates Stack Test Dates:: Date Report Received N N N Both N/A Date Must be valid date in mm/dd/yyyy format N/A Stack Test Dates:: Date Test Results Were Reviewed N Y N Both N/A Date Must be valid date in mm/dd/yyyy format N/A Test Results Test Results:: Tested Y N N Air N/A Single Select Autocomplete REF_Pollutant where Pollutant_Category_Code = AIR Sort Order: Alphabetic – Ascending by Pollutant Name
Test Results:: Test Result N N N Air N/A Single Select Dropdown REF_Air_Stack_Test_Status Valid Values (Blank) Pass Fail Pending Incomplete N/A Test Results:: Method Codes N N N Air N/A Multi-select with Autocomplete Length of Largest Value REF_Air_Stack_Test_Method Sort Order: Alphabetic - Ascending Test Results:: Allowable Value N N N Air N/A Number 18 characters (if decimal places allows for 1 decimal place and 17 numbers) Minimum value is and maximum value is N/A Test Results:: Allowable Unit N N N Air N/A Single Select Search Typeahead REF_Pollutant_Unit
be displayed when the user first arrives at the Add screen, how the data will be displayed on the screen, the source reference table, values for the selection boxes, and sort order, and where the data will be saved in the target database table and columns. Table 5.103. TV ACC Data Element Mapping Data Element Name FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column TV ACC Basic Information Basic Information:: Permit ID N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_TVACC.Permit_ID_UDF Basic Information:: Certification Period Start Date N N N Air Current System Date Date Must be valid date in mm/dd/yyyy format N/A Basic Information:: Certification Period End Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A Basic Information:: Facility Reported Compliance Status N Y N Air N/A Single Select Dropdown Length of Largest Value REF_Air_Fac_Rpt_Compliance Valid Values: (Blank) Continuous Intermittent TV ACC Review TV ACC Review:: Reviewed Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A
TV ACC Review:: Did Facility Report Deviations? N N N Air N/A Radio Buttons Yes No Valid Values: (Blank) N Y TV ACC Review:: Permit Conditions N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A TV ACC Review:: N N N Air N/A Radio Buttons Yes No Valid Values: (Blank) N Y
TV ACC Review:: Reviewer Agency N N N Air Defaults to user’s Agency as follows: State for non-tribe State users, LCON for LCON users, and Tribe for state Tribal users; ICIS determines if a State is a tribe by looking at the column in REF_State. Single Select Dropdown REF_Agency_Type.Agency_Type_Code Valid Values: REF_Agency_Type.Agency_Type_Desc TV ACC Review:: Reviewed By N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A TV ACC Review:: Reviewer Comments N N N Air N/A Alphanumeric Free-form text Max Length 500 characters N/A