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.