Retrieve effrs afscms data from afs database
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)
|
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. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.