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.103. TV ACC 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 TV ACC Basic Information Basic N N N Air N/A N/A Air_TVACC.Permit_ID_UDF 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 Basic N N N Air N/A N/A Date Information:: Must be valid Certification date in Period End Date mm/dd/yyyy format Basic N Y N Air N/A Single Select REF_Air_Fac_Rpt_Compliance Information:: Dropdown Valid Values: Facility Reported Length of Largest (Blank) Compliance Value Continuous Status Intermittent TV ACC Review TV ACC N N N Air N/A N/A Date Review:: Must be valid Reviewed Date date in mm/dd/yyyy format
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.103. TV ACC 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 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 Basic Information:: Certification Period End Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A Basic Information:: Facility Reported Compliance Status N Y N Air N/A Single Select Dropdown Length of Largest Value REF_Air_Fac_Rpt_Compliance Valid Values: (Blank) Continuous Intermittent TV ACC Review TV ACC Review:: Reviewed Date N N N Air N/A Date Must be valid date in mm/dd/yyyy format N/A
ICIS_Compliance_Monitoring_Web_Design_v2.3.docx