afs_effrs_afsapp: Retrieve effrs afsapp data from afs database

Description Usage Arguments

Description

Retrieve effrs afsapp data from afs database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
afs_effrs_afsapp(STATE_COUNTY_COMPLIANCE_SOURCE = NULL,
  AIR_PROGRAM_CODE = NULL, POLLUTANT_CODE = NULL,
  POLLUTANT_CODE_DESC = NULL, CHEMICAL_ABSTRACT_SERVICE_NUM = NULL,
  CHEMICAL_ABSTRACT_SERVICE_DESC = NULL, ES_ATTAIN_IND_DESC = NULL,
  ES_ATTAIN_IND = NULL, ES_PLLT_COMPLIANCE_STATUS = NULL,
  ES_PLLT_COMPLIANCE_DESC = NULL, ES_PLLT_CLASS_CODE = NULL,
  ES_PLLT_CLASS_DESC = NULL, STATE_ATTAIN_IND = NULL,
  STATE_ATTAIN_IND_DESC = NULL, STATE_PLLT_COMPLIANCE_STATUS = NULL,
  STATE_PLLT_COMPLIANCE_DESC = NULL, STATE_PLLT_CLASS_CODE = NULL,
  STATE_PLLT_CLASS_DESC = NULL, EPA_ATTAIN_IND = NULL,
  EPA_ATTAIN_IND_DESC = NULL, EPA_PLLT_COMPLIANCE_STATUS = NULL,
  EPA_PLLT_COMPLIANCE_DESC = NULL, EPA_PLLT_CLASS_CODE = NULL,
  EPA_PLLT_CLASS_DESC = NULL, DATE_RECORD_UPDATED = NULL,
  AIR_PROGRAMS = NULL)

Arguments

STATE_COUNTY_COMPLIANCE_SOURCE

e.g. '0100100001'. See Details.

AIR_PROGRAM_CODE

e.g. '0'. See Details.

POLLUTANT_CODE

e.g. 'PM10'. See Details.

POLLUTANT_CODE_DESC

e.g. 'PARTICULATE MATTER < 10 UM'. See Details.

CHEMICAL_ABSTRACT_SERVICE_NUM

e.g. 'NA'. See Details.

CHEMICAL_ABSTRACT_SERVICE_DESC

e.g. 'NA'. See Details.

ES_ATTAIN_IND_DESC

e.g. 'ATTAINMENT AREA FOR A GIV'. See Details.

ES_ATTAIN_IND

e.g. 'A'. See Details.

ES_PLLT_COMPLIANCE_STATUS

e.g. '4'. See Details.

ES_PLLT_COMPLIANCE_DESC

e.g. 'IN COMPLIANCE - CERTIFICA'. See Details.

ES_PLLT_CLASS_CODE

e.g. 'A'. See Details.

ES_PLLT_CLASS_DESC

e.g. 'ACTUAL OR POTENTIAL EMISS'. See Details.

STATE_ATTAIN_IND

e.g. 'A'. See Details.

STATE_ATTAIN_IND_DESC

e.g. 'ATTAINMENT AREA FOR A GIV'. See Details.

STATE_PLLT_COMPLIANCE_STATUS

e.g. '4'. See Details.

STATE_PLLT_COMPLIANCE_DESC

e.g. 'IN COMPLIANCE - CERTIFICA'. See Details.

STATE_PLLT_CLASS_CODE

e.g. 'A'. See Details.

STATE_PLLT_CLASS_DESC

e.g. 'ACTUAL OR POTENTIAL EMISS'. See Details.

EPA_ATTAIN_IND

e.g. 'NA'. See Details.

EPA_ATTAIN_IND_DESC

e.g. 'NA'. See Details.

EPA_PLLT_COMPLIANCE_STATUS

e.g. 'NA'. See Details.

EPA_PLLT_COMPLIANCE_DESC

e.g. 'NA'. See Details.

EPA_PLLT_CLASS_CODE

e.g. 'NA'. See Details.

EPA_PLLT_CLASS_DESC

e.g. 'NA'. See Details.

DATE_RECORD_UPDATED

e.g. '21-JUN-99'. See Details.

AIR_PROGRAMS

e.g. 'AMV069'. See Details.


markwh/envirofacts documentation built on May 21, 2019, 12:26 p.m.