Last Modified N N N Both System N/A ICIS_Activity.Updated_Date Date Date generated EDT: Must be based on valid date in date of data yyyy-mm-dd entry format Web: Must be valid date in mm/dd/yyyy format 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 FE&C/ Default Data Type Displayed Data Validation (REF Table, Valid Target Database Table & Value Name (Type, Length) Values, Sort Order) Column Air/Both Displayed Stack Test Basic Information Basic N N N Air N/A N/A Air_Stack_Test.Unit_Stack_UDF Alphanumeric Information:: Free-form text Unit or Stack Max Length 100 Identifier characters
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
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx