Table & Column Information
The following table names in the Air Releases (AIRS) are provided for Envirofacts users who will be accessing AIRS directly using Oracle. Use the AIRS/AFS Query Form to obtain formatted reports on other AIRS data.
- AFS_ACTION_COMMENT
- AFS_ACTION_TYPE
- AFS_ACTION_VIOL
- AFS_AFS_PLLT
- AFS_AIRPGMPLT_ATNM
- AFS_AIRPGMPLT_CLSS
- AFS_AIRPGMPLT_CMPL
- AFS_AIRPGM_EER
- AFS_AIRPGM_PNTACT
- AFS_AIR_PGM_ACTION
- AFS_AIR_PGM_CLASS
- AFS_AIR_PGM_CMPL
- AFS_AIR_PGM_PLLT
- AFS_CMPL_HISTORY
- AFS_CODES
- AFS_EMISSION_EER
- AFS_EMISS_MONITOR
- AFS_EMISS_MTHD
- AFS_EMISS_TYPE
- AFS_FIPS_AREA
- AFS_GEO_CODES
- AFS_GEO_PLLT
- AFS_INSPECTION
- AFS_KEY_ACTION
- AFS_KEY_PNT_ACTION
- AFS_PLANT_ACTION
- AFS_PLANT_AIR_PGM
- AFS_PLANT_CLASS
- AFS_PLANT_COMMENT
- AFS_PLANT_COMPL
- AFS_PLANT_CONTACT
- AFS_PLANT_DESC
- AFS_PLANT_FEE
- AFS_PLANT_GENERAL
- AFS_PLANT_MAIL_ADDR
- AFS_PLANT_PLLT
- AFS_PLANT_SIC
- AFS_PLANT_SV
- AFS_PLLT_CHEMICAL
- AFS_PLLT_VLDTYFLG
- AFS_PNTAIRPGM_CMPL
- AFS_PNT_ACTION_VIOL
- AFS_PNT_CMPL_HIST
- AFS_PNT_VIOL_POLL
- AFS_POINT_ACTION
- AFS_POINT_AIR_PGM
- AFS_POINT_COMMENT
- AFS_POINT_GENERAL
- AFS_POINT_INSPECT
- AFS_POINT_PLLT
- AFS_RESULT
- AFS_SEGMENT_GEN
- AFS_SEGMENT_PLLT_1
- AFS_SEGMENT_PLLT_2
- AFS_SEGPLT_CTL_EQP
- AFS_SEG_COMMENT
- AFS_SIC
- AFS_SIC_MEANS
- AFS_SIPINV
- AFS_SIPINV_AVLREVW
- AFS_SIPINV_COMMENT
- AFS_SIPINV_REGREVW
- AFS_SRC_CLS_GRP
- AFS_SRC_CLS_PROC
- AFS_STACK_COMMENT
- AFS_STACK_GENERAL
- AFS_STACK_PLLT
- AFS_STAFF
- AFS_STATE
- AFS_STATUS_AREA
- AFS_VIOL_POLLUTANT
Return To: