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 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 Info::Is N N N FE&C N/A Dropdown Valid values: the Animal Blank Facility Type a Yes (stored as Y) CAFO? No (stored as N) General N N Y FE&C N/A Dropdown REF_CAFO_Classification Info::CAFO Display Valid values: Classification Active values in REF_CAFO_Classification Sort Order: Alphabetical Ascending – by CAFO Classification Description General N N Y FE&C N/A N/A Date Info::CAFO Must be valid Designation Date date in mm/dd/yyyy format Must be less than or equal to current date General N N Y FE&C N/A N/A Alphanumeric Info::Designation Max Length 500 Reason characters
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
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx