Action Type EnforcementAgencyTypeCode Ref_agency_type Code that represents the type of air Use code with an agency associated with the ACTIVITY_GROUP_CODE of “EFA” enforcement action. (Fixed 3 and a STATUS_FLAG of “A”. alphanumeric field) N/A EnforcementAgencyName The name of the air agency responsible for the enforcement action. (Variable length 100 character field) N/A AffiliationTypeText Code that represents the type of Use code with an governmental contact or address for AFFILIATION_CATEGORY of the enforcement action. (Fixed 3 a STATUS_FLAG of “Government”, character field) and the code can be found in the “A”, XREF_AFFILIATION_MODULE table with an APP_MODULE_CODE of “SEA”. N/A ElectronicAddressText Email address of the government contact person for the enforcement action. (Variable length 100 character field) N/A Format is ccyy-mm-dd. If not StartDateOfContactAssociation The date the contact person was reported as being associated with the provided, default is date of submission. enforcement action. (Date field) N/A EndDateOfContactAssociation The date the contact person was Format is ccyy-mm-dd. reported as no longer being associated with the enforcement action. (Date field) N/A OtherAgencyInitiativeText Description of state or local initiatives that applied to or prompted the initiation of the enforcement action. (Variable length 200 character field) Pollutant Code AirPollutantCode Ref_pollutant Code that represents a pollutant Use codes involved in the enforcement action. POLLUTANT_CATEGORY_CODE of (Variable length 10 digit field) and a STATUS_FLAG of “AIR” “A”.
EnforcementAgencyTypeCode Action Type Ref_agency_type Code that represents the type of air agency associated with the enforcement action. (Fixed 3 alphanumeric field) Use code with an ACTIVITY_GROUP_CODE of “EFA” and a STATUS_FLAG of “A”. EnforcementAgencyName N/A The name of the air agency responsible for the enforcement action. (Variable length 100 character field) AffiliationTypeText N/A Code that represents the type of governmental contact or address for the enforcement action. (Fixed 3 character field) Use code with an AFFILIATION_CATEGORY of “Government”, a STATUS_FLAG of “A”, and the code can be found in the XREF_AFFILIATION_MODULE table with an APP_MODULE_CODE of “SEA”. ElectronicAddressText N/A Email address of the government contact person for the enforcement action. (Variable length 100 character field) StartDateOfContactAssociation N/A The date the contact person was reported as being associated with the enforcement action. (Date field) Format is ccyy-mm-dd. If not provided, default is date of submission. EndDateOfContactAssociation N/A The date the contact person was reported as no longer being associated with the enforcement action. (Date field) Format is ccyy-mm-dd. OtherAgencyInitiativeText N/A Description of state or local initiatives that applied to or prompted the initiation of the enforcement action. (Variable length 200 character field) AirPollutantCode Pollutant Code Ref_pollutant Code that represents a pollutant involved in the enforcement action. (Variable length 10 digit field) Use codes POLLUTANT_CATEGORY_CODE of “AIR” and a STATUS_FLAG of “A”.
ICIS-Air_EDT_Mapping_Guidelines_3-17-15.docx