afs_effrs_afsplt2: Retrieve effrs afsplt2 data from afs database

Description Usage Arguments

Description

Retrieve effrs afsplt2 data from afs database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
afs_effrs_afsplt2(STATE_COUNTY_COMPLIANCE_SOURCE = NULL,
  ES_CLASS_CODE = NULL, ES_CLASS_CODE_DESC = NULL,
  ES_COMPLIANCE_STATUS = NULL, ES_COMPLIANCE_STATUS_DESC = NULL,
  EPA_CLASS_CODE = NULL, EPA_CLASS_CODE_DESC = NULL,
  EPA_COMPLIANCE_STATUS = NULL, EPA_COMPLIANCE_STATUS_DESC = NULL,
  STATE_CLASS_CODE = NULL, STATE_CLASS_CODE_DESC = NULL,
  STATE_COMPLIANCE_STATUS = NULL, STATE_COMPLIANCE_STATUS_DESC = NULL,
  ES_LATEST_FCE_DATE_ACHIEVED = NULL, ES_LATEST_FCE_ACTION_TYPE = NULL,
  STATE_LATEST_FCE_DATE_ACHIEVED = NULL,
  STATE_LATEST_FCE_ACTION_TYPE = NULL,
  EPA_LATEST_FCE_DATE_ACHIEVED = NULL,
  EPA_LATEST_FCE_ACTION_TYPE = NULL, CONTACT_PERSION_COMPLIANCE = NULL,
  PHONE_AREA_CODE_COMPLIANCE = NULL, PHONE_COMPLIANCE = NULL,
  MAILING_CITY = NULL, MAILING_PLANT_NAME = NULL,
  MAILING_STATE_ABBREV = NULL, MAILING_STATE_NAME = NULL,
  MAILING_STREET_ADDRESS = NULL, MAILING_ZIP = NULL)

Arguments

STATE_COUNTY_COMPLIANCE_SOURCE

e.g. '0100100001'. See Details.

ES_CLASS_CODE

e.g. 'A'. See Details.

ES_CLASS_CODE_DESC

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

ES_COMPLIANCE_STATUS

e.g. '4'. See Details.

ES_COMPLIANCE_STATUS_DESC

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

EPA_CLASS_CODE

e.g. 'NA'. See Details.

EPA_CLASS_CODE_DESC

e.g. 'NA'. See Details.

EPA_COMPLIANCE_STATUS

e.g. '4'. See Details.

EPA_COMPLIANCE_STATUS_DESC

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

STATE_CLASS_CODE

e.g. 'A'. See Details.

STATE_CLASS_CODE_DESC

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

STATE_COMPLIANCE_STATUS

e.g. '4'. See Details.

STATE_COMPLIANCE_STATUS_DESC

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

ES_LATEST_FCE_DATE_ACHIEVED

e.g. '30-SEP-13'. See Details.

ES_LATEST_FCE_ACTION_TYPE

e.g. 'FS'. See Details.

STATE_LATEST_FCE_DATE_ACHIEVED

e.g. '30-SEP-13'. See Details.

STATE_LATEST_FCE_ACTION_TYPE

e.g. 'FS'. See Details.

EPA_LATEST_FCE_DATE_ACHIEVED

e.g. 'NA'. See Details.

EPA_LATEST_FCE_ACTION_TYPE

e.g. 'NA'. See Details.

CONTACT_PERSION_COMPLIANCE

e.g. 'NA'. See Details.

PHONE_AREA_CODE_COMPLIANCE

e.g. 'NA'. See Details.

PHONE_COMPLIANCE

e.g. 'NA'. See Details.

MAILING_CITY

e.g. 'NA'. See Details.

MAILING_PLANT_NAME

e.g. 'NA'. See Details.

MAILING_STATE_ABBREV

e.g. 'NA'. See Details.

MAILING_STATE_NAME

e.g. 'NA'. See Details.

MAILING_STREET_ADDRESS

e.g. 'NA'. See Details.

MAILING_ZIP

e.g. 'NA'. See Details.


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