Table Name: AFS_AIRPGMPLT_CMPL

Description: This table maps the relationship existing between a plant, the air program monitoring a specific pollutant emitted by that plant, and the compliance status code(s). The codes are used to measure the plant's attainment of certain air pollution standards. Attributes in AFS_AIRPGMPLT_CMPL are retrievable by EF_AFS_ID + AIR_PROGRAM_CODE + POLLUTANT_CODE (or CAS_NUM) + EPA_STATE_IND.

Relationships:

No relationship information available at this time.

Columns:

AIR_PROGRAM_CODE
CAS_NUM
COMPL_STAT_CODE
EF_AFS_ID
EMCIRN
EPA_STATE_IND
POLLUTANT_CODE
SCSC_ID

Definition Source: Envirofacts Development Team

Return To:

AIRS/AFS Table & Column Information
Envirofacts Overview

Table Name: AFS_AIRPGMPLT_CMPL

Local Navigation