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