Selection of Columns for EZ Search

STEP 2: Select Columns (Data Elements or Fields)

Select one or more column(s) by clicking the box next to the data element or field name displayed below.

TABLE NAME: V_TRI_FACILITY_EZ
	Tri Facility Id	The unique number assigned to each facility for purposes of the TRI program. Usually, only one number is assigned to each facility and the number is for the entire facility. One company may have multiple TRI Facility Identification (ID) numbers if they have multiple facilities. One facility with many establishments will usually have only one TRI Facility ID number. They will then use this number for all of their Form Rs even if they are submitting a Form R for different establishments with different names. In a few instances different establishments of the same facility will have different TRI Facility ID numbers. The format is ZZZZZNNNNNSSSSS, where ZZZZZ = ZIP code, NNNNN = the first 5 consonants of the name, and SSSSS = the first 5 non-blank non-special characters in the street address.
	Count Function for Tri Facility Id. DO NOT SELECT THE COLUMN LOCATED DIRECTLY ABOVE IF YOU SELECT THIS COLUMN!	Counts the number of distinct records for the column above: You must select an additional column other than a group function! HELP on STATISTICS! COUNT
	Facility Name	The name of the facility.
	Street Address	The street name in the address of the reporting facility.
	City Name	The name of the city in which the reporting facility is located.
	County Name	The standardized name of the county where the facility is located.
	State FIPS Code	Combination of the two-letter state abbreviation and the county code.
	Code Expansion for State FIPS Code	Selecting this option will provide you with the description for the code from the field above this one
	State Abbreviation	A two-letter code assigned by the U.S. Postal Service to identify the state in which the facility is located.
	Code Expansion for State Abbreviation	Selecting this option will provide you with the description for the code from the field above this one
	Zip Code	Five-digit standardized Zip code where the facility is located.
	Region	The EPA region in which the facility is located.
	Facility Closed Indicator	A flag that indicates whether a facility is open (value = 0), closed (value = 1), or inactive for TRI (value = 2).
	Mail Name	The mailing name of the facility.
	Mail Street Address	Street address of the facility mailing address.
	Mail City	City of facility mailing address.
	Mail State Abbr	State abbreviation of facility mailing address.
	Mail Country	Country of facility mailing address.
	Mail Zip Code	Zip code of facility mailing address.
	Asgn Agency	An abbreviation for the name of the agency supported by a federal or Government Owned/Contractor Operated (GOCO) reporting site.
	Code Expansion for Asgn Agency	Selecting this option will provide you with the description for the code from the field above this one
	Assigned Federal Indicator	An identifier that indicates the ownership status of a facility.
	Parent Company DNB Num	The unique identifying number assigned by Dun and Bradstreet to the parent company of the reporting facility.
	Parent Co Name	Name of the corporation or other business company that is the ultimate parent company, located in the United States, of the facility or establishment submitting the data. Generally, the parent company is the company that directly owns at least 50 percent of the voting stock of the reporting company (see 40 CFR 372.3 for more details). This does not include foreign parent companies. 'NA' indicates that the facility does not have a parent company.
	Foreign Parent Company DUNS Number	The unique identifying number assigned by Dun and Bradstreet to the foreign parent company of the reporting facility.
	Foreign Parent Company Name	Name of the corporation or other business company that is the ultimate parent company, located outside the United States, of the facility or establishment submitting the data. NA indicates that the facility does not have a foreign parent company. See 40 CFR 372.3 for more details.
	Standardized Foreign Parent Company	A data field developed by EPA that is intended to best reflect the current foreign parent company for the facility. EPA developed this field to facilitate the aggregation of TRI facility-level information to the associated foreign parent company by ensuring that each company is referenced consistently by the same name.
	Standardized Parent Company	A data field developed by EPA that is intended to best reflect the current ultimate US parent company for the facility. EPA developed this field to facilitate the aggregation of TRI facility-level information to the associated parent company by ensuring that each company is referenced consistently by the same name. Filers often submit names with small variations (e.g., Exopack vs. Exopack Holdings Corp) that make aggregation at the corporate level challenging when using parent names as reported. The standardized parent company field was developed by standardizing the self-submitted parent company names through a process described on the TRI website (e.g., eliminating periods, standardizing common acronyms such as Inc and Corp, etc.). The process also includes the replacement of subsidiary names with the name of the ultimate US parent in cases where EPA identified a subsidiary in the submitted parent company field.
	Epa Registry Id	Indicates the Facility Registry Service (FRS) id for a TRI Facility, POTW Facility or Off-site Transfer Location facility. The Facility Registry Service (FRS) is a centrally managed database at EPA that identifies facilities, sites or places subject to environmental regulations or of environmental interest. Using the FRS Id (EPA_REGISTRY_ID), data users can link data from different EPA programs together. See the Facility Registry Service at https://www.epa.gov/frs for more details.
	Latitude	The measure of the angular distance on a meridian north or south of the equator standardized to NAD83 horizontal datum. This data provided by EPA's Facility Registry System (FRS).
	Longitude	The measure of the angular distance on a meridian east or west of the prime meridian standardized to NAD83 horizontal datum. This data provided by EPA's Facility Registry System (FRS).
	Reference Point	The name that identifies the place for which geographic coordinates were established. This data provided by EPA's Facility Registry System (FRS).
	Reference Point Code	The code that represents the place for which geographic coordinates were established. This data provided by EPA's Facility Registry System (FRS).
	Collection Method	The text that describes the method used to determine the latitude and longitude coordinates for a point on the earth. This data provided by EPA's Facility Registry System (FRS).
	Collection Method Code	The code that represents the method used to determine the latitude and longitude coordinates for a point on the earth. This data provided by EPA's Facility Registry System (FRS).
	Accuracy Value	The measure of the accuracy (in meters) of the latitude and longitude coordinates. This data provided by EPA's Facility Registry System (FRS).
	Accuracy Score	The accuracy score (in meters) derived as the accuracy value either supplied by the location metadata or calculated based on the collection method and then modified based on QA boundary checks. This data provided by EPA's Facility Registry System (FRS).
	Horizontal Datum	The name that describes the reference datum used in determining latitude and longitude coordinates. Allowable Values: Value Meaning 001 NAD27 002 NAD83 003 WGS84. This data provide by EPA's Facility Registry System (FRS).
	Scale	The number that represents the proportional distance on the ground for one unit of measure on the map or photo. Remarks: Mandatory for all horizontal data collection methods except for methods using Global Positioning System (GPS). This data provide by EPA's Facility Registry System (FRS).
	Source	The name of the party responsible for providing the latitude and longitude coordinates. This data provide by EPA's Facility Registry System (FRS).
	Source Code	The code that represents the party responsible for providing the latitude and longitude coordinates. This data provided by EPA's Facility Registry System (FRS).
	Conveyor	Identification of the party that transmitted the associated latitude and longitude coordinates. This data provided by EPA's Facility Registry System (FRS).
	BIA Tribal Code	The Bureau of Indian Affairs (BIA) Tribal Code that indicates the tribal land that the facility is located on. A facility reports this three digit code to the Toxics Release Inventory (TRI) program on the form R or form A. There are over 300 BIA Tribal Codes. For a list of BIA Tribal Codes and associated Tribe Names click here.
	Tribe	The Tribal Land where the facility is located.
	Assigned Partial Indicator	Indicates whether the facility reports as a partial facility; partial facilities may have more than one submission for the same chemical in one reporting year.
	Assigned Public Contact	Individual that the public may contact if clarification of the information on the reporting is required, as assigned by TRI.
	Assigned Public Phone	Telephone number, including area code, of the public contact, as assigned by TRI.
	Assigned Public Email	The Email address of the public contact, as assigned by TRI.
	Assigned Public Phone Ext	The telephone extension of the Public Contact Person as reported on the form R
	Facility Registry System ID	The identification number assigned by the EPA Facility Registry System to uniquely identify a facility site. The Facility Registry System ID is not a TRI submission element. It is made available for use in this query by linking the TRI Program System ID (TRI_FACILITY_ID) contained within the TRI Program System Database, to the Program System ID (PGM_SYS_ID) contained within the Facility Registry System Database.