Action Type LeadAgencyChangeSuperseded Ref_agency_type Code that refers to the type of air Only use a code assigned to an activity agency that took over managing the group code of and the “CMD” case file from another agency due to appropriate agency: lack of resources or exceeding the Do not use an inactive lead agency type timeline established in HPV policy. code. (Fixed length 4 alphanumeric field) N/A AdvisementMethodTypeCode Code that represents the method of Do not use an inactive code. advisement provided by an air agency to the air facility regarding alleged violation(s). (Fixed 3 character code) N/A AdvisementMethodDate The date the air agency advised the Format is ccyy-mm-dd. air facility of the alleged violation(s). (Date field) Violation Type Code AirViolationTypeCode Code that represents an issue Do not use an inactive code. 1 through 7 warranting additional research or analysis for an alleged FRV, HPV, NFR or other violation. (Variable length 6 alphanumeric field) Air Program Code 1 AirViolationProgramCode Ref_program Code that represents an Air Program Do not use an inactive code. through 6 related to the alleged violation. (Variable length 9 character field) N/A Description of an air program that is Must be provided if Air Violation Federally Enforceable. (Variable Program Code contains “CAAFENF”. length 100 character field) Violating Pollutant 1 AirViolationPollutantCode Ref_pollutant Code that represents the pollutant Only use codes assigned to a program through 3 warranting additional research or category of Do not use an “AIR”. analysis from an alleged violation. inactive code. (Variable length 10 digit field) Action Date Achieved FRVDeterminationDate The date an alleged violation met the criteria for being designated as an FRV. (Date field) Action Date Achieved Format is ccyy-mm-dd. HPVDayZeroDate The date an alleged violation met the criteria for being designated as an HPV. (Date field)
LeadAgencyChangeSuperseded Action Type Ref_agency_type Code that refers to the type of air agency that took over managing the case file from another agency due to lack of resources or exceeding the timeline established in HPV policy. (Fixed length 4 alphanumeric field) Only use a code assigned to an activity group code of “CMD” and the appropriate agency: Do not use an inactive lead agency type code. AdvisementMethodTypeCode N/A Code that represents the method of advisement provided by an air agency to the air facility regarding alleged violation(s). (Fixed 3 character code) Do not use an inactive code. AdvisementMethodDate N/A The date the air agency advised the air facility of the alleged violation(s). (Date field) Format is ccyy-mm-dd. AirViolationTypeCode Violation Type Code 1 through 7 Code that represents an issue warranting additional research or analysis for an alleged FRV, HPV, NFR or other violation. (Variable length 6 alphanumeric field) Do not use an inactive code. AirViolationProgramCode Air Program Code 1 through 6 Ref_program Code that represents an Air Program related to the alleged violation. (Variable length 9 character field) Do not use an inactive code. N/A Description of an air program that is Federally Enforceable. (Variable length 100 character field) Must be provided if Air Violation Program Code contains “CAAFENF”. AirViolationPollutantCode Violating Pollutant 1 through 3 Ref_pollutant Code that represents the pollutant warranting additional research or analysis from an alleged violation. (Variable length 10 digit field) Only use codes assigned to a program category of “AIR”. Do not use an inactive code. FRVDeterminationDate Action Date Achieved The date an alleged violation met the criteria for being designated as an FRV. (Date field) HPVDayZeroDate Action Date Achieved The date an alleged violation met the criteria for being designated as an HPV. (Date field) Format is ccyy-mm-dd.
ICIS-Air_EDT_Mapping_Guidelines_3-17-15.docx