Retrieve rcr hreport univ data from rcrainfo database
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)
|
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. |
Add the following code to your website.
For more information on customizing the embed code, read Embedding Snippets.