N N N Air N/A Single Select REF_Air_Failure_Reason Dropdown Test Results:: Reason for Failure N N N Air N/A N/A Alphanumeric Free-form text Test Results:: Other Reasons Max Length 50 characters for Failure Table 3.53. TV ACC 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 3.53. TV ACC Data Element Mapping Data Element SR? 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 TV ACC Basic Information Basic N/A Air_TVACC.Permit_ID_UDF N N N Air N/A Alphanumeric Information:: Free-form text Permit ID Max Length 100 characters Basic N N N Air Current N/A Date Information:: System Must be valid Certification Date date in Period Start Date mm/dd/yyyy format
Test Results:: Reason for Failure N N N Air N/A Single Select Dropdown REF_Air_Failure_Reason Test Results:: Other Reasons for Failure N N N Air N/A Alphanumeric Free-form text Max Length 50 characters N/A Table 3.53. TV ACC 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 3.53. TV ACC Data Element Mapping Data Element Name SR? FE&C/ Air/Both Default Value Displayed Data Type Displayed (Type, Length) Data Validation (REF Table, Valid Values, Sort Order) Target Database Table & Column TV ACC Basic Information Basic Information:: Permit ID N N N Air N/A Alphanumeric Free-form text Max Length 100 characters N/A Air_TVACC.Permit_ID_UDF Basic Information:: Certification Period Start Date N N N Air Current System Date Date Must be valid date in mm/dd/yyyy format N/A