afs_effrs_afscms: Retrieve effrs afscms data from afs database

Description Usage Arguments

Description

Retrieve effrs afscms data from afs database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
afs_effrs_afscms(STATE_COUNTY_COMPLIANCE_SOURCE = NULL,
  EPA_PLANT_ID = NULL, PLANT_ID = NULL, REGION_CODE = NULL,
  STATE_ABBREV = NULL, STATE_NAME = NULL, COUNTY_NAME = NULL,
  DUN_BRADSTREET_NUMBER = NULL, CMS_SOURCE_CATEGORY = NULL,
  CMS_START_DATE = NULL, FY2008_CMS_IND = NULL,
  FY2008_CMS_IND_DESC = NULL, FY2009_CMS_IND = NULL,
  FY2009_CMS_IND_DESC = NULL, FY2010_CMS_IND = NULL,
  FY2010_CMS_IND_DESC = NULL, FY2011_CMS_IND = NULL,
  FY2011_CMS_IND_DESC = NULL, FY2012_CMS_IND = NULL,
  FY2012_CMS_IND_DESC = NULL, FY2013_CMS_IND = NULL,
  FY2013_CMS_IND_DESC = NULL, FY2014_CMS_IND = NULL,
  FY2014_CMS_IND_DESC = NULL, FY2015_CMS_IND = NULL,
  FY2015_CMS_IND_DESC = NULL)

Arguments

STATE_COUNTY_COMPLIANCE_SOURCE

e.g. '0100100001'. See Details.

EPA_PLANT_ID

e.g. '110011734935'. See Details.

PLANT_ID

e.g. '0013025'. See Details.

REGION_CODE

e.g. '04'. See Details.

STATE_ABBREV

e.g. 'AL'. See Details.

STATE_NAME

e.g. 'ALABAMA'. See Details.

COUNTY_NAME

e.g. 'AUTAUGA'. See Details.

DUN_BRADSTREET_NUMBER

e.g. '039044318'. See Details.

CMS_SOURCE_CATEGORY

e.g. 'A'. See Details.

CMS_START_DATE

e.g. '01-OCT-01'. See Details.

FY2008_CMS_IND

e.g. 'A'. See Details.

FY2008_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2009_CMS_IND

e.g. 'A'. See Details.

FY2009_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2010_CMS_IND

e.g. 'A'. See Details.

FY2010_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2011_CMS_IND

e.g. 'A'. See Details.

FY2011_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2012_CMS_IND

e.g. 'A'. See Details.

FY2012_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2013_CMS_IND

e.g. 'A'. See Details.

FY2013_CMS_IND_DESC

e.g. 'TITLE V MAJOR'. See Details.

FY2014_CMS_IND

e.g. 'NA'. See Details.

FY2014_CMS_IND_DESC

e.g. 'NA'. See Details.

FY2015_CMS_IND

e.g. 'NA'. See Details.

FY2015_CMS_IND_DESC

e.g. 'NA'. See Details.


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