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 FE&C/ Default Data Type Displayed Data Validation (REF Table, Valid Target Database Table & Name Value (Type, Length) Values, Sort Order) Column Air/Both Displayed General Information General N N N FE&C N/A N/A Numeric Max Length 10 numbers Annual Whole numbers Expenditure General N N N FE&C N/A N/A Numeric Max Length 4 Information:: numbers MS4 Annual Whole numbers Expenditure Year Format YYYY General N N N FE&C N/A N/A Numeric Max Length 10 numbers Budget Whole numbers General N N N FE&C N/A N/A Numeric Max Length 4 numbers Budget Year Whole numbers Format YYYY General N N N FE&C N/A Multiselect REF_Source_Funding Length of Largest Active values in Sources of Value REF_Source_Funding Funding Sort Order: Alphabetic Ascending Order – by Impact Description
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
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx