Table Name: AFS_CMPL_HISTORY

Description: Monthly or quarterly EPA or State compliance status information for a plant air program. The EPA compliance status for a given date exists only if it differs from the state compliance status. Attributes in the AFS_CMPL_HISTORY table are retrievable by EF_AFS_ID + AIR_PROGRAM_CODE + HIST_CMPL_DATE + MONTH_QTR_FLAG + EPA_STATE_IND

Relationships:

No relationship information available at this time.

Columns:

AIR_PROGRAM_CODE
COMPL_STAT_CODE
EF_AFS_ID
EPA_STATE_IND
HIST_COMPL_DATE
MONTH_QTR_FLAG
SCSC_ID

Definition Source: Envirofacts Development Team

Return To:

AIRS/AFS Table & Column Information
Envirofacts Overview

Table Name: AFS_CMPL_HISTORY

Local Navigation