afs_effrs_afsact1: Retrieve effrs afsact1 data from afs database

Description Usage Arguments

Description

Retrieve effrs afsact1 data from afs database

Usage

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)

Arguments

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.


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