br_rcr_hhandler: Retrieve rcr hhandler data from br database

In markwh/envirofacts: Access EPA Data via the Envirofacts Web Services

Description

Retrieve rcr hhandler data from br database

Usage

br_rcr_hhandler(HANDLER_ID = NULL, ACTIVITY_LOCATION = NULL,
  SOURCE_TYPE = NULL, SEQ_NUMBER = NULL, RECEIVE_DATE = NULL,
  HANDLER_NAME = NULL, NON_NOTIFIER = NULL, ACKNOWLEDGE_DATE = NULL,
  ACKNOWLEDGE_FLAG = NULL, ACCESSIBILITY = NULL,
  LOCATION_STREET_NO = NULL, LOCATION_STREET1 = NULL,
  LOCATION_STREET2 = NULL, LOCATION_CITY = NULL,
  LOCATION_STATE = NULL, LOCATION_ZIP = NULL, COUNTY_CODE = 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_FIRST_NAME = NULL, CONTACT_MIDDLE_INITIAL = NULL,
  CONTACT_LAST_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 = NULL,
  CONTACT_PHONE_EXT = NULL, CONTACT_FAX = NULL,
  CONTACT_EMAIL_ADDRESS = NULL, CONTACT_TITLE = NULL,
  FED_WASTE_GENERATOR_OWNER = NULL, FED_WASTE_GENERATOR = NULL,
  STATE_WASTE_GENERATOR_OWNER = NULL, STATE_WASTE_GENERATOR = NULL,
  SHORT_TERM_GENERATOR = NULL, IMPORTER_ACTIVITY = NULL,
  MIXED_WASTE_GENERATOR = NULL, TRANSPORTER = NULL,
  TRANSFER_FACILITY = NULL, TSD_ACTIVITY = NULL,
  RECYCLER_ACTIVITY = NULL, ONSITE_BURNER_EXEMPTION = NULL,
  FURNACE_EXEMPTION = NULL, UNDERGROUND_INJECTION_ACTIVITY = NULL,
  OFF_SITE_RECEIPT = NULL, UNIVERSAL_WASTE_DEST_FACILITY = NULL,
  USED_OIL_TRANSPORTER = NULL, USED_OIL_TRANSFER_FACILITY = NULL,
  USED_OIL_PROCESSOR = NULL, USED_OIL_REFINER = NULL,
  USED_OIL_BURNER = NULL, USED_OIL_MARKET_BURNER = NULL,
  USED_OIL_SPEC_MARKETER = NULL, SUBPART_K_COLLEGE = NULL,
  SUBPART_K_HOSPITAL = NULL, SUBPART_K_NONPROFIT = NULL,
  SUBPART_K_WITHDRAWAL = NULL, INCLUDE_IN_NATIONAL_REPORT = NULL,
  REPORT_CYCLE = NULL, CDX_TRANSACTION_ID = 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.
RECEIVE_DATE	e.g. '17-SEP-93'. See Details.
HANDLER_NAME	e.g. 'USDA FS CHUGACH NF CORDOVA FOREST WORK C'. See Details.
NON_NOTIFIER	e.g. 'NA'. See Details.
ACKNOWLEDGE_DATE	e.g. '07-JAN-94'. See Details.
ACKNOWLEDGE_FLAG	e.g. 'N'. See Details.
ACCESSIBILITY	e.g. 'NA'. 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.
COUNTY_CODE	e.g. 'AK261'. 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. 'US'. See Details.
CONTACT_FIRST_NAME	e.g. 'SARAH'. See Details.
CONTACT_MIDDLE_INITIAL	e.g. 'NA'. See Details.
CONTACT_LAST_NAME	e.g. '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	e.g. '9072712556'. See Details.
CONTACT_PHONE_EXT	e.g. 'NA'. See Details.
CONTACT_FAX	e.g. 'NA'. See Details.
CONTACT_EMAIL_ADDRESS	e.g. 'NA'. See Details.
CONTACT_TITLE	e.g. 'NA'. 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.
SHORT_TERM_GENERATOR	e.g. 'N'. See Details.
IMPORTER_ACTIVITY	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.
TSD_ACTIVITY	e.g. 'N'. See Details.
RECYCLER_ACTIVITY	e.g. 'N'. See Details.
ONSITE_BURNER_EXEMPTION	e.g. 'N'. See Details.
FURNACE_EXEMPTION	e.g. 'N'. See Details.
UNDERGROUND_INJECTION_ACTIVITY	e.g. 'N'. See Details.
OFF_SITE_RECEIPT	e.g. 'N'. See Details.
UNIVERSAL_WASTE_DEST_FACILITY	e.g. 'N'. See Details.
USED_OIL_TRANSPORTER	e.g. 'N'. See Details.
USED_OIL_TRANSFER_FACILITY	e.g. 'N'. See Details.
USED_OIL_PROCESSOR	e.g. 'N'. See Details.
USED_OIL_REFINER	e.g. 'N'. See Details.
USED_OIL_BURNER	e.g. 'N'. See Details.
USED_OIL_MARKET_BURNER	e.g. 'N'. See Details.
USED_OIL_SPEC_MARKETER	e.g. 'N'. See Details.
SUBPART_K_COLLEGE	e.g. 'NA'. See Details.
SUBPART_K_HOSPITAL	e.g. 'NA'. See Details.
SUBPART_K_NONPROFIT	e.g. 'NA'. See Details.
SUBPART_K_WITHDRAWAL	e.g. 'NA'. See Details.
INCLUDE_IN_NATIONAL_REPORT	e.g. 'NA'. See Details.
REPORT_CYCLE	e.g. 'NA'. See Details.
CDX_TRANSACTION_ID	e.g. 'NA'. See Details.

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