tri_tri_facility_history: Retrieve tri facility history data from tri database

Description Usage Arguments

Description

Retrieve tri facility history data from tri database

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
tri_tri_facility_history(TRI_FACILITY_ID = NULL, REPORTING_YEAR = NULL,
  FACILITY_NAME = NULL, STREET_ADDRESS = NULL, CITY_NAME = NULL,
  COUNTY_NAME = NULL, STATE_COUNTY_FIPS_CODE = NULL,
  STATE_ABBR = NULL, ZIP_CODE = NULL, REGION = NULL,
  MAIL_NAME = NULL, MAIL_STREET_ADDRESS = NULL, MAIL_CITY = NULL,
  MAIL_STATE_ABBR = NULL, MAIL_PROVINCE = NULL, MAIL_COUNTRY = NULL,
  MAIL_ZIP_CODE = NULL, ASGN_FEDERAL_IND = NULL, ASGN_AGENCY = NULL,
  PARENT_CO_DB_NUM = NULL, PARENT_CO_NAME = NULL,
  FAC_LATITUDE = NULL, FAC_LONGITUDE = NULL, PREF_LATITUDE = NULL,
  PREF_LONGITUDE = NULL, PREF_ACCURACY = NULL,
  PREF_COLLECT_METH = NULL, PREF_DESC_CATEGORY = NULL,
  PREF_HORIZONTAL_DATUM = NULL, PREF_SOURCE_SCALE = NULL,
  PREF_QA_CODE = NULL, ASGN_PARTIAL_IND = NULL,
  ASGN_PUBLIC_CONTACT = NULL, ASGN_PUBLIC_PHONE = NULL,
  ASGN_PUBLIC_CONTACT_EMAIL = NULL, BIA_CODE = NULL,
  STANDARDIZED_PARENT_COMPANY = NULL, ASGN_PUBLIC_PHONE_EXT = NULL)

Arguments

TRI_FACILITY_ID

e.g. '00602BXTRF111CO'. See Details.

REPORTING_YEAR

e.g. '1988'. See Details.

FACILITY_NAME

e.g. 'BAXTER FENWAL DIV.,'. See Details.

STREET_ADDRESS

e.g. '111 COLON ST.,'. See Details.

CITY_NAME

e.g. 'AGUADA'. See Details.

COUNTY_NAME

e.g. 'AGUADA'. See Details.

STATE_COUNTY_FIPS_CODE

e.g. 'NA'. See Details.

STATE_ABBR

e.g. 'PR'. See Details.

ZIP_CODE

e.g. '00602'. See Details.

REGION

e.g. '2'. See Details.

MAIL_NAME

e.g. 'NA'. See Details.

MAIL_STREET_ADDRESS

e.g. 'NA'. See Details.

MAIL_CITY

e.g. 'NA'. See Details.

MAIL_STATE_ABBR

e.g. 'NA'. See Details.

MAIL_PROVINCE

e.g. 'NA'. See Details.

MAIL_COUNTRY

e.g. 'NA'. See Details.

MAIL_ZIP_CODE

e.g. 'NA'. See Details.

ASGN_FEDERAL_IND

e.g. 'C'. See Details.

ASGN_AGENCY

e.g. 'NA'. See Details.

PARENT_CO_DB_NUM

e.g. 'NA'. See Details.

PARENT_CO_NAME

e.g. 'BAXTER SALES CORP.'. See Details.

FAC_LATITUDE

e.g. 'NA'. See Details.

FAC_LONGITUDE

e.g. 'NA'. See Details.

PREF_LATITUDE

e.g. 'NA'. See Details.

PREF_LONGITUDE

e.g. 'NA'. See Details.

PREF_ACCURACY

e.g. 'NA'. See Details.

PREF_COLLECT_METH

e.g. 'NA'. See Details.

PREF_DESC_CATEGORY

e.g. 'NA'. See Details.

PREF_HORIZONTAL_DATUM

e.g. 'NA'. See Details.

PREF_SOURCE_SCALE

e.g. 'NA'. See Details.

PREF_QA_CODE

e.g. 'NA'. See Details.

ASGN_PARTIAL_IND

e.g. 'NA'. See Details.

ASGN_PUBLIC_CONTACT

e.g. 'NA'. See Details.

ASGN_PUBLIC_PHONE

e.g. 'NA'. See Details.

ASGN_PUBLIC_CONTACT_EMAIL

e.g. 'NA'. See Details.

BIA_CODE

e.g. 'NA'. See Details.

STANDARDIZED_PARENT_COMPANY

e.g. 'NA'. See Details.

ASGN_PUBLIC_PHONE_EXT

e.g. 'NA'. See Details.


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