Retrieve effrs afsact1 data from afs database
1 2 3 4 5 6 7 8 9 | afs_effrs_afsact1(STATE_COUNTY_COMPLIANCE_SOURCE = NULL,
ACTION_NUMBER = NULL, KEY_ACTION_NUMBERS = NULL,
AIR_PROGRAM_CODES = NULL, NATIONAL_ACTION_TYPE = NULL,
NATIONAL_ACTION_DESC = NULL, ACTION_TYPE = NULL,
ACTION_DESC = NULL, DATE_ACHIEVED = NULL, PENALTY_AMT = NULL,
RESULTS_CODE = NULL, RESULTS_CODE_DESC = NULL,
POLLUTANT_CODE = NULL, REGIONAL_DATA_ELEMENT = NULL,
REGIONAL_DATA_ELEMENT_16 = NULL, HPV_ADDRESSING_ACTION_DESC = NULL,
CREATION_DATE = NULL)
|
STATE_COUNTY_COMPLIANCE_SOURCE |
e.g. '0100100001'. See Details. |
ACTION_NUMBER |
e.g. '00460'. See Details. |
KEY_ACTION_NUMBERS |
e.g. 'NA'. See Details. |
AIR_PROGRAM_CODES |
e.g. 'M'. See Details. |
NATIONAL_ACTION_TYPE |
e.g. 'TS'. See Details. |
NATIONAL_ACTION_DESC |
e.g. 'STATE/LOCAL RECEIPT OF STACK TEST REPORT'. See Details. |
ACTION_TYPE |
e.g. 'TS'. See Details. |
ACTION_DESC |
e.g. 'STATE RECEIPT OF STACK TEST REPORT'. See Details. |
DATE_ACHIEVED |
e.g. '21-JUL-10'. See Details. |
PENALTY_AMT |
e.g. 'NA'. See Details. |
RESULTS_CODE |
e.g. 'PP'. See Details. |
RESULTS_CODE_DESC |
e.g. 'STACK TEST PASSED'. See Details. |
POLLUTANT_CODE |
e.g. 'PT'. See Details. |
REGIONAL_DATA_ELEMENT |
e.g. 'NA'. See Details. |
REGIONAL_DATA_ELEMENT_16 |
e.g. 'NA'. See Details. |
HPV_ADDRESSING_ACTION_DESC |
e.g. 'NA'. See Details. |
CREATION_DATE |
e.g. '18-AUG-10'. See Details. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.