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 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 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 Basic Y Y N Air Pending Single Select REF_Air_Stack_Test_Status Information:: Dropdown Valid Values: Stack Test Status Length of Largest (Blank) Value Pass Fail Pending Incomplete Basic N N Y Air N/A N/A Air_Stack_Test.Other_Purpose Alphanumeric Information:: Free-form text Other Purpose of Max Length 100 Stack Test characters Basic N N N Air N/A Multi Select Ref_Agency_Type Information:: Dropdown Observed By Length of Largest Value Basic Y Y N Air Air_Stack_Test. Single Select REF_Air_Conductor_Type Information:: Dropdown Air_Conductor_Type_Code Conducted By Length of Largest Value Default to Owner/Operator
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
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx