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 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 Event Information Event Y Y N FE&C N/A Must be less than or equal to the current Date Information:: date Must be valid CSO Overflow date in Event Date format Must be less than or equal to current date Event N N N FE&C N/A Dropdown Valid values: Information::Dry Blank or Wet Weather Wet (stored as W) Dry (stored as D) Event N N N FE&C N/A N/A Numeric Max Length 5 numbers (Inches) Maximum 2 decimal places Must be between 0.00 999.99 –
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
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx