rcrainfo_rcr_hreport_univ: Retrieve rcr hreport univ data from rcrainfo database

Description Usage Arguments

Description

Retrieve rcr hreport univ data from rcrainfo database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
rcrainfo_rcr_hreport_univ(HANDLER_ID = NULL, ACTIVITY_LOCATION = NULL,
  SOURCE_TYPE = NULL, SEQ_NUMBER = NULL, HANDLER_NAME = NULL,
  NON_NOTIFIER = NULL, RECEIVE_DATE = NULL, REPORT_CYCLE = NULL,
  ACCESSIBILITY = NULL, REGION = NULL, STATE = NULL,
  EXTRACT_FLAG = NULL, ACTIVE_SITE = NULL, LOCATION_STREET_NO = NULL,
  LOCATION_STREET1 = NULL, LOCATION_STREET2 = NULL,
  LOCATION_CITY = NULL, LOCATION_STATE = NULL, LOCATION_ZIP = NULL,
  LOCATION_COUNTY_CODE = NULL, LOCATION_COUNTY_NAME = NULL,
  LOCATION_COUNTRY = NULL, STATE_DISTRICT_OWNER = NULL,
  STATE_DISTRICT = NULL, LAND_TYPE = NULL, MAIL_STREET_NO = NULL,
  MAIL_STREET1 = NULL, MAIL_STREET2 = NULL, MAIL_CITY = NULL,
  MAIL_STATE = NULL, MAIL_ZIP = NULL, MAIL_COUNTRY = NULL,
  CONTACT_NAME = NULL, CONTACT_STREET_NO = NULL,
  CONTACT_STREET1 = NULL, CONTACT_STREET2 = NULL,
  CONTACT_CITY = NULL, CONTACT_STATE = NULL, CONTACT_ZIP = NULL,
  CONTACT_COUNTRY = NULL, CONTACT_PHONE_AND_EXT = NULL,
  CONTACT_FAX = NULL, CONTACT_EMAIL_ADDRESS = NULL,
  CONTACT_TITLE = NULL, OWNER_NAME = NULL, OWNER_TYPE = NULL,
  OWNER_SEQ = NULL, OPERATOR_NAME = NULL, OPERATOR_TYPE = NULL,
  OPERATOR_SEQ = NULL, NAIC1 = NULL, NAIC2 = NULL, NAIC3 = NULL,
  NAIC4 = NULL, IN_HANDLER_UNIVERSES = NULL, IN_A_UNIVERSE = NULL,
  FED_WASTE_GENERATOR_OWNER = NULL, FED_WASTE_GENERATOR = NULL,
  STATE_WASTE_GENERATOR_OWNER = NULL, STATE_WASTE_GENERATOR = NULL,
  GENSTATUS = NULL, SHORT_TERM_GENERATOR = NULL, IMPORTER = NULL,
  MIXED_WASTE_GENERATOR = NULL, TRANSPORTER = NULL,
  TRANSFER_FACILITY = NULL, RECYCLER = NULL,
  ONSITE_BURNER_EXEMPT = NULL, FURNACE_EXEMPTION = NULL,
  UNDERGROUND_INJECTION = NULL, OFF_SITE_RECEIPT = NULL,
  UNIVWASTE = NULL, UNIVERSAL_WASTE_DEST_FACILITY = NULL,
  USED_OIL = NULL, FEDERAL_UNIVERSAL_WASTE = NULL,
  AS_FEDERALLY_REGULATED_TSDF = NULL, AS_CONVERTER_TSDF = NULL,
  AS_STATE_REGULATED_TSDF = NULL, FEDERAL_INDICATOR = NULL,
  HSM = NULL, SUBPART_K = NULL, COMMERCIAL_TSD = NULL,
  TSD_TYPE = NULL, GPRA_PERMIT = NULL, GPRA_RENEWAL = NULL,
  PERMIT_RENEWAL_WRKLD = NULL, PERMWRKLD = NULL, PERMPROG = NULL,
  PCWRKLD = NULL, CLOSWRKLD = NULL, GPRA_CA = NULL, CAWRKLD = NULL,
  SUBJCA = NULL, SUBJCA_NON_TSD = NULL, SUBJCA_TSD_3004 = NULL,
  SUBJCA_TSD_DISCRETION = NULL, NCAPS = NULL, EC_INDICATOR = NULL,
  IC_INDICATOR = NULL, CA725_INDICATOR = NULL,
  CA750_INDICATOR = NULL, OPERATING_TSDF = NULL,
  FULL_ENFORCEMENT = NULL, SNC = NULL, UNADDRESSED_SNC = NULL,
  ADDRESSED_SNC = NULL, SNC_WITH_COMP_SCHED = NULL,
  FA_REQUIRED = NULL, HHANDLER_LAST_CHANGE = NULL)

Arguments

HANDLER_ID

e.g. 'AK0000000323'. See Details.

ACTIVITY_LOCATION

e.g. 'AK'. See Details.

SOURCE_TYPE

e.g. 'N'. See Details.

SEQ_NUMBER

e.g. '1'. See Details.

HANDLER_NAME

e.g. 'USDA FS CHUGACH NF CORDOVA FOREST WORK C'. See Details.

NON_NOTIFIER

e.g. 'NA'. See Details.

RECEIVE_DATE

e.g. '17-SEP-93'. See Details.

REPORT_CYCLE

e.g. 'NA'. See Details.

ACCESSIBILITY

e.g. 'NA'. See Details.

REGION

e.g. '10'. See Details.

STATE

e.g. 'AK'. See Details.

EXTRACT_FLAG

e.g. 'X'. See Details.

ACTIVE_SITE

e.g. 'H—-'. See Details.

LOCATION_STREET_NO

e.g. 'NA'. See Details.

LOCATION_STREET1

e.g. 'COR LEFEVRE ST & COPPER RIV HW'. See Details.

LOCATION_STREET2

e.g. 'Y'. See Details.

LOCATION_CITY

e.g. 'CORDOVA'. See Details.

LOCATION_STATE

e.g. 'AK'. See Details.

LOCATION_ZIP

e.g. '99574'. See Details.

LOCATION_COUNTY_CODE

e.g. 'AK261'. See Details.

LOCATION_COUNTY_NAME

e.g. 'VALDEZ-CORDOVA'. See Details.

LOCATION_COUNTRY

e.g. 'NA'. See Details.

STATE_DISTRICT_OWNER

e.g. 'NA'. See Details.

STATE_DISTRICT

e.g. 'NA'. See Details.

LAND_TYPE

e.g. 'F'. See Details.

MAIL_STREET_NO

e.g. 'NA'. See Details.

MAIL_STREET1

e.g. 'PO BOX 280'. See Details.

MAIL_STREET2

e.g. 'NA'. See Details.

MAIL_CITY

e.g. 'CORDOVA'. See Details.

MAIL_STATE

e.g. 'AK'. See Details.

MAIL_ZIP

e.g. '99574'. See Details.

MAIL_COUNTRY

e.g. 'NA'. See Details.

CONTACT_NAME

e.g. 'SARAH BAKER'. See Details.

CONTACT_STREET_NO

e.g. 'NA'. See Details.

CONTACT_STREET1

e.g. '3301 C ST STE 300'. See Details.

CONTACT_STREET2

e.g. 'NA'. See Details.

CONTACT_CITY

e.g. 'ANCHORAGE'. See Details.

CONTACT_STATE

e.g. 'AK'. See Details.

CONTACT_ZIP

e.g. '995033998'. See Details.

CONTACT_COUNTRY

e.g. 'US'. See Details.

CONTACT_PHONE_AND_EXT

e.g. '9072712556'. See Details.

CONTACT_FAX

e.g. 'NA'. See Details.

CONTACT_EMAIL_ADDRESS

e.g. 'NA'. See Details.

CONTACT_TITLE

e.g. 'NA'. See Details.

OWNER_NAME

e.g. 'US FOREST SERVICE CHUGACH NF'. See Details.

OWNER_TYPE

e.g. 'F'. See Details.

OWNER_SEQ

e.g. '1'. See Details.

OPERATOR_NAME

e.g. 'NA'. See Details.

OPERATOR_TYPE

e.g. 'NA'. See Details.

OPERATOR_SEQ

e.g. 'NA'. See Details.

NAIC1

e.g. 'NA'. See Details.

NAIC2

e.g. 'NA'. See Details.

NAIC3

e.g. 'NA'. See Details.

NAIC4

e.g. 'NA'. See Details.

IN_HANDLER_UNIVERSES

e.g. 'Y'. See Details.

IN_A_UNIVERSE

e.g. 'Y'. See Details.

FED_WASTE_GENERATOR_OWNER

e.g. 'HQ'. See Details.

FED_WASTE_GENERATOR

e.g. '3'. See Details.

STATE_WASTE_GENERATOR_OWNER

e.g. 'NA'. See Details.

STATE_WASTE_GENERATOR

e.g. 'NA'. See Details.

GENSTATUS

e.g. 'CEG'. See Details.

SHORT_TERM_GENERATOR

e.g. 'N'. See Details.

IMPORTER

e.g. 'N'. See Details.

MIXED_WASTE_GENERATOR

e.g. 'N'. See Details.

TRANSPORTER

e.g. 'N'. See Details.

TRANSFER_FACILITY

e.g. 'N'. See Details.

RECYCLER

e.g. 'N'. See Details.

ONSITE_BURNER_EXEMPT

e.g. 'N'. See Details.

FURNACE_EXEMPTION

e.g. 'N'. See Details.

UNDERGROUND_INJECTION

e.g. 'N'. See Details.

OFF_SITE_RECEIPT

e.g. 'N'. See Details.

UNIVWASTE

e.g. 'N'. See Details.

UNIVERSAL_WASTE_DEST_FACILITY

e.g. 'N'. See Details.

USED_OIL

e.g. 'NNNNNNN'. See Details.

FEDERAL_UNIVERSAL_WASTE

e.g. 'N'. See Details.

AS_FEDERALLY_REGULATED_TSDF

e.g. '——'. See Details.

AS_CONVERTER_TSDF

e.g. '——'. See Details.

AS_STATE_REGULATED_TSDF

e.g. '———'. See Details.

FEDERAL_INDICATOR

e.g. 'LO-'. See Details.

HSM

e.g. 'N'. See Details.

SUBPART_K

e.g. '—-'. See Details.

COMMERCIAL_TSD

e.g. 'N'. See Details.

TSD_TYPE

e.g. '—–'. See Details.

GPRA_PERMIT

e.g. 'N'. See Details.

GPRA_RENEWAL

e.g. 'N'. See Details.

PERMIT_RENEWAL_WRKLD

e.g. '——'. See Details.

PERMWRKLD

e.g. '——'. See Details.

PERMPROG

e.g. '——'. See Details.

PCWRKLD

e.g. '——'. See Details.

CLOSWRKLD

e.g. '——'. See Details.

GPRA_CA

e.g. 'N'. See Details.

CAWRKLD

e.g. 'N'. See Details.

SUBJCA

e.g. 'N'. See Details.

SUBJCA_NON_TSD

e.g. 'N'. See Details.

SUBJCA_TSD_3004

e.g. 'N'. See Details.

SUBJCA_TSD_DISCRETION

e.g. 'N'. See Details.

NCAPS

e.g. 'N'. See Details.

EC_INDICATOR

e.g. 'N'. See Details.

IC_INDICATOR

e.g. 'N'. See Details.

CA725_INDICATOR

e.g. 'N'. See Details.

CA750_INDICATOR

e.g. 'N'. See Details.

OPERATING_TSDF

e.g. '——'. See Details.

FULL_ENFORCEMENT

e.g. '——'. See Details.

SNC

e.g. 'N'. See Details.

UNADDRESSED_SNC

e.g. 'N'. See Details.

ADDRESSED_SNC

e.g. 'N'. See Details.

SNC_WITH_COMP_SCHED

e.g. 'N'. See Details.

FA_REQUIRED

e.g. '—–'. See Details.

HHANDLER_LAST_CHANGE

e.g. '15-SEP-00'. See Details.


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