Table Name: AFS_VIOL_POLLUTANT

Description: The resolution table between the AFS_PLANT_ACTION and AFS_AFS_PLLT tables. This table resolves the many-to-many relationship existing between these two entities, i.e. one PLANT_ACTION can be issued for the emission of many POLLUTANTs and one POLLUTANT can be associated with many PLANT_ACTIONs. Attributes in AFS_VIOL_POLLUTANT are retrievable by EF_AFS_ID + ACTION_NUM + INDIRECT_SOURCE_ID + POLLUTANT_CODE.

Relationships:

No relationship information available at this time.

Columns:

ACTION_NUM
EF_AFS_ID
EMCIRN
INDIRECT_SOURCE_ID
POLLUTANT_CODE
SCSC_ID

Definition Source: Envirofacts Development Team

Return To:

AIRS/AFS Table & Column Information
Envirofacts Overview

Table Name: AFS_VIOL_POLLUTANT

Local Navigation