Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Program Facility
Basic identification information for a facility site, including the facility registry identifier, geographic address, and geopolitical descriptors.
Remarks: The 2010 data files (XLS) (17.2M) were downloaded from the eGRID website (http://www.epa.qov/cleanenerqv/enerqv-resources/eqrid/index.html).
The data file consists of a spreadsheet containing several worksheets; the 4th worksheet, PLNT10 contains all data needed for this crosswalk. Both a logical and
database name is given.
Environmental
Information System
Abbreviated Name
The abbreviated name that represents the name of an information management system
for an environmental program.
A(20)
'EGRID'
Environmental
Information System
Identification Number
The identification number, such as the permit number, assigned by an information
management system that represents a facility site, waste site, operable unit, or other
feature tracked by that Environmental Information System.
A(30)
DOE/EIA ORIS plant or facility
code (ORISPL)'
Facility Site Name
The public or commercial name of a facility site (i.e., the full name that commonly
appears on invoices, signs, or other business documents, or as assigned by the state
when the name is ambiguous).
A(80)
Plant name (PNAME)
Location Address
The address that describes the physical (geographic) location of the front door or main
entrance of a facility site, including urban-style street address or rural address.
A(50)
Supplemental Location
Text
The text that provides additional information about a place, including a building name
with its secondary unit and number, an industrial park name, an installation name or
descriptive text where no formal address is available.
A(50)
Locality Name
The name of the city, town, village or other locality, when identifiable, within whose
boundaries (the majority of) the facility site is located. This is not always the same as the
city used for United States Postal Service (USPS) mail delivery.
A(60)
County and State FIPS
Code
The code that represents the county or county equivalent and the state or state
equivalent of the United States.
A(5)
Plant FIPS state code || Plant
FIPS county code
(FIPSST||FIPSCNTY)
County Name
The name of the U.S. county or county equivalent in which the facility site is physically
located.
A(35)
Plant county name
(CNTYNAME)
1
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
State USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
Plant state abbreviation
(PSTATABB)
State Name
The name of a principal administrative subdivision of the United States, Canada, or
Mexico.
A(35)
Country Name
The name that represents a primary geopolitical unit of the world.
Default USA
A(44)
'USA'
Location ZIP Code
The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit
extension code (if available) that represents the geographic segment that is a subunit of
the ZIP Code, assigned by the USPS to a geographic location; or the postal zone specific
to the country, other than the U.S., where the facility site is located.
A(14)
Location Description
A brief explanation of where the facility site is located, including navigational directions
and/or more descriptive information about the location of the facility site.
A(256)
Federal Facility
Indicator Code
Code indicating whether or not the facility is the property of the Federal Government.
Allowable Values'.
Value Meaninq
Y Yes, the facility is the property of the Federal Government.
N No, the facility is not the property of the Federal Government.
A(1)
Federal Agency Code
The Federal Agency/Bureau code. The five character code consists of a letter followed
by four numbers. There are four possible letters that can occupy the first character
position: 'C' for Civilian Federal Agency; 'D' for Department of Defense; 'E' for
Department of Energy; 'X' for Unknown. The second and third characters represent the
agency code, while the fourth and fifth characters represent the bureau code.
A(5)
Tribal Land Indicator
Code
Code indicating whether or not the facility site is located on tribal land.
Allowable Values'.
Value Meanina
Y Yes, the facility is located on tribal land.
N No, the facility is not located on tribal land.
A(1)
Tribal Land Name
The name of an American Indian or Alaskan native area where the facility site is located.
A(200)
2
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Legislative District
Number
The number that represents a Legislative District within a state.
A(2)
Hydrologic Unit Code
(HUC) 8-digit
The 8-digit hydrologic unit code (HUC) that represents a geographic area representing
part or all of a surface drainage basin, a combination of drainage basins, or a distinct
hydrologic feature.
A(8)
Hydrologic Unit Code
(HUC) 12-digit
The 12-digit hydrologic unit code (HUC) that represents a geographic area representing
part or all of a surface drainage basin, a combination of drainage basins, or a distinct
hydrologic feature.
A(12)
EPA Region Code
The code that represents an EPA region.
A(2)
Facility Site Type
Name
The descriptive name for the type of site the facility occupies.
Allowable Values'.
Stationary Contaminated Site
Mobile Contamination Addressed
Monitoring Station Potentially Contaminated Site
Water System
A(40)
'STATIONARY'
Small Business
Indicator
Code indicating whether or not a business is requesting relief under EPA's Small
Business Policy, which applies to businesses having less than 100 employees.
A(1)
Environmental Justice
Code
The code that identifies the type of environmental justice concern affecting the facility or
enforcement action.
A(3)
Source of Data
The source of the associated facility site data.
A(25)
'EGRID'
Last Reported Date
The most recent date the corresponding facility site data was reported to the Source of
Data.
Date
2/24/2014
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
'N'
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
'Y'
3
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Environmental Interest
The environmental permits and regulatory programs that apply to the facility site.
Environmental Interest
Type
The environmental permit or regulatory program that applies to the facility site.
A(60)
See End Note"
Active Status
The status of the environmental interest at the facility or site (e.g., Active, Inactive,
Operating, Proposed for NPL, Deleted from Final NPL, Currently on Final NPL).
A(50)
Federal/State Source
Indicator
A flag which indicates whether the environmental interest data was provided by a federal
or state environmental information system.
Allowable Values'. 'F' for Federal. 'S' for State. 'T' for Tribal, and 'P' for Private
A(1)
'F'
Environmental Interest
Start Date
Date the agency became interested in the facility site for a particular environmental
interest type.
Date
Environmental Interest
Start Date Qualifier
The qualifier that specifies the meaning of the date being used as an approximation for
the environmental interest start date.
Allowable Values'. (examplesi
First Reporting Year Earliest Inspection Date
First Report Received Date Operations Start Date
First Report Postmark Date Monitoring Start Date
Original Permit Issue Date
A(50)
Environmental Interest
End Date
Date the agency ceased to be interested in the facility site for a particular environmental
interest type.
Date
Environmental Interest
End Date Qualifier
The qualifier that specifies the meaning of the date being used as an approximation for
the environmental interest end date.
Allowable Values', (examples)
Facility Inactive Date Year Reporting Stopped
De-registration Effective Date Permit Expiration Date
Operations End Date Final Cleanup Date
A(50)
Source of Data
The source of the associated environmental interest data.
A(25)
'EGRID'
4
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Last Reported Date
The most recent date the corresponding environmental interest data was reported to the
Source of Data.
Date
2/24/2014
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
'N'
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
'Y'
Alternative Name
An alternative, historic or program-specific name for the facility site.
Remarks: No alternative name data.
Alternative Name
An alternative, historic or program-specific name for the facility site.
A(80)
Alternative Name Type
The type of the alternative, historical, or program-specific name for the facility site (e.g.,
primary, legal, historical, local).
A(25)
Source of Data
The source of the associated alternative name data.
A(25)
Last Reported Date
The most recent date the corresponding alternative name data was reported to the
Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
Alternative Identification
An alternative identifier for the facility site, as maintained by an information management system for an environmental program.
Remarks: No alternative identification data.
Alternative Identifier
Type
The type of alternative identification number (e.g., CDS, STATE PERMIT NUMBER), or
the abbreviated name of the environmental information system that references the
alternative identification number (e.g., TRIS, PCS).
A(30)
Alternative Identifier
An alternative identification number maintained by an information management system
for an environmental program.
A(30)
5
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
County and State FIPS
Code
The code that represents the county or county equivalent and the state or state
equivalent of the United States.
A(5)
Source of Data
The source of the associated alternative identification data.
A(25)
Last Reported Date
The most recent date the corresponding alternative identification data was reported to
the Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
Geographic Coordinates
A geographic point or set of points, defined by latitude and longitude coordinates used to locate a facility site, usually the front door or centroid, including the
associated method, accuracy, and description data.
Latitude Measure
The measure of the angular distance on a meridian north or south of the equator.
N(9,6)
If County centroid flag
(CCFLAG) <> '1' , then
Plant latitude (LAT)
Else, null
Longitude Measure
The measure of the angular distance on a meridian east or west of the prime meridian.
(10,6)
If County centroid flag
(CCFLAG) <> '1' , then
Plant longitude (LON)
Else, null
Horizontal Collection Method (Textual Data or Code Data acceptable)
Code
The code that represents the method used to determine the latitude and longitude
coordinates for a point on the earth.
A(3)
Text
The text that describes the method used to determine the latitude and longitude
coordinates for a point on the earth.
A(60)
Source Map Scale
Number
The number that represents the proportional distance on the ground for one unit of
measure on the map or photo.
N( 10)
6
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Horizontal Accuracy
Measure
The measure of the accuracy (in meters) of the latitude and longitude coordinates.
N(6)
Data Collection Date
The calendar data when data were collected.
Date
Reference Point (Textual Data or Code Data acceptable)
Code
The code that represents the place for which geographic coordinates were established.
A(3)
Text
The text that identifies the place for which geographic coordinates were established.
A(60)
Horizontal Reference Datum (Textual Data or Code Data acceptable)
Code
The code that represents the reference datum used in determining latitude and longitude
coordinates.
A(3)
Name
The name that describes the reference datum used in determining latitude and longitude
coordinates.
A(7)
Coordinate Data Source (Textual Data or Code Data acceptable)
Code
The code that represents the party responsible for providing the latitude and longitude
coordinates.
A(3)
Name
The name of the party responsible for providing the latitude and longitude coordinates.
A(35)
Geometric Type (Textual Data or Code Data acceptable)
Code
The code that represents the geometric entity represented by one point or a sequence of
latitude and longitude points.
A(3)
Name
The name that identifies the geometric entity represented by one point or a sequence of
latitude and longitude points.
A(6)
Location Comments
Text
The text that provides additional information about the geographic coordinates.
A(150)
Vertical Collection Method (Textual Data or Code Data acceptable)
Code
The code that represents the method used to collect the vertical measure (i.e., the
altitude) of a reference point.
A(3)
7
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Text
The text that describes the method used to collect the vertical measure (i.e., the altitude)
of a reference point.
A(60)
Vertical Reference Datum (Textual Data or Code Data acceptable)
Code
The code that represents the reference datum used to determine the vertical measure
(i.e., the altitude).
A(3)
Name
The name of the reference datum used to determine the vertical measure (i.e., the
altitude).
A( 17)
Vertical Accuracy
Measure
The measure of the accuracy (in meters) of the vertical measure (i.e., the altitude) of a
reference point.
N(7)
Vertical Measure
The measure of elevation (i.e., the altitude), in meters, above or below a reference
datum.
N( 10)
Sub-Entity
Identification Number
The identification number for an operable unit or sub-unit of a facility site.
A(30)
Sub-Entity Type Code
The code that represents the type of operable unit, or sub-unit of a facility site (i.e., stack,
sampling point).
A(4)
Sub-Entity Type
Description
The text that represents the type of operable unit, or sub-unit of a facility site (i.e., stack,
sampling point).
A(200)
Shape
Coordinates that define the geometry of the point feature.
SDO GE
OMETRY
Conveyor of Record
The source of the associated geographic coordinate data.
A(25)
'EGRID'
Review Flag
A flag that indicated whether or not the associated record has been verified by EPA. 'Y'
indicates the record has been verified.
A(1)
Reviewed By Name
Indicates the user or agency that verified the record.
A(30)
8
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Organization Affiliate
A company, government body, or other type of organization that has some responsibility or role at the facility site.
Remarks: A record is created for each Plant owner name (up to sixteen) and each Plant operator name, if different from the owner name. If the operator
matches the owner, the AF FILI AT I ON_TYP E = 'OWNER/OPERATOR'. If not, the AF FILI AT I ON_TYP E of the operator record = 'OPERATOR'. If the Plant owner
percent < 100.00, multiple records are created with AFFILIATION TYPE = 'JOINT PARENT COMPANY'. If the Plant owner percent = 100 and is not equal to
the operator, the AFFILIATION_TYPE = 'PARENT COMPANY'.
Affiliation Type
The name that describes the capacity or function that an organization serves for a facility
site.
Allowable Values (examples)'.
Owner/Operator Responsible Party
Operator Parent Company
Owner Joint Parent Company
A (40)
'OWNER/OPERATOR',
'OPERATOR',
'JOINT PARENT COMPANY',
'PARENT COMPANY'
Affiliation Start Date
The date on which the affiliation between the facility site and the organization began.
Date
Affiliation End Date
The date on which the affiliation between the facility site and the organization ended.
Date
Ownership Percentage
Percent of the associated facility owned by the organization.
N(3)
Plant owner percent (first -
sixteenth) (OWNRPR01-16)
Organization Formal
Name
The legal, formal name of an organization that is affiliated with the facility site.
A(80)
Plant owner name (first -
sixteenth) (OWNRNM01-16)
Plant operator name
(OPRNAME) {if different from
Plant owner names}
Organization DUNS
Number
The Data Universal Numbering System (DUNS) number assigned by Dun and Bradstreet
to identify unique business establishments.
A(9)
9
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Organization Type
The type of organization (e.g., federal, state, private).
Allowable Values (examples)'.
Federal Indian
State Public
County Private
District Public Private
Municipal Government-Owned Contractor Operated
Other
A(40)
Company Division
Name
The name of a division or a department of a company.
A(50)
E-mail Address
The text that describes an electronic mail address of an individual person affiliated with
the facility site.
A(120)
Telephone Number
The primary telephone number of an individual person affiliated with the facility site.
A(30)
FAX Number
The telephone number to which a facsimile can be sent to an individual person affiliated
with the facility site.
A(30)
Alternate Telephone
Number
An alternate telephone number of an individual person affiliated with the facility site.
A(30)
Employer Identification
Number
The unique tax identification number issued by the Internal Revenue Service to the
employer.
A(14)
State Business
Identification Number
The uniform business number assigned to an official business by a state.
A(30)
Mailing Address
The exact address where a mail piece is intended to be delivered, including urban-style
street address, rural route, and PO Box.
A(50)
Supplemental Address
Text
The text that provides additional information to facilitate the delivery of a mail piece,
including building name, secondary units, and mail stop or local box numbers not
serviced by the USPS.
A(50)
Mailing Address City
Name
The name of the city, town, or village where the mail is delivered.
A(30)
10
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Mailing Address State
USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
Mailing Address State
Name
The name of the state where mail is delivered.
A(35)
Mailing Address
Country Name
The name of the country where the addressee is located.
Default United States
A(44)
Mailing Address ZIP
Code
The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit
extension code (if available) that represents the geographic segment that is a subunit of
the ZIP Code, assigned by the USPS to a geographic location to facilitate mail delivery;
or the postal zone specific to the country, other than the U.S., where the mail is delivered.
A(14)
Source of Data
The source of the associated organization data.
A(25)
'EGRID'
Last Reported Date
The most recent date the corresponding organization data was reported to the Source of
Data.
Date
2/24/2014
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
'N'
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
'Y'
Individual Affiliate
An individual person who has some responsibility or role at the facility site.
Remarks: No individual affiliation (contact) data.
Affiliation Type
The name that describes the capacity or function that an individual serves for a facility
site.
Allowable Values (examples)'.
Regulatory Contact Cognizant Official
Public Contact Responsible Party
Technical Contact Emergency Contact
A (40)
Affiliation Start Date
The date on which the affiliation between the facility site and the individual person began.
Date
Affiliation End Date
The date on which the affiliation between the facility site and the individual person ended.
Date
11
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Individual Full Name
The complete name of a person, including first name, middle name or initial, and
surname.
A(70)
Individual Title Text
The title held by a person in an organization.
A(40)
Company Division
Name
The name of a division or a department of a company.
A(50)
E-mail Address
The text that describes an electronic mail address of an individual person affiliated with
the facility site.
A(120)
Telephone Number
The primary telephone number of an individual person affiliated with the facility site.
A(30)
FAX Number
The telephone number to which a facsimile can be sent to an individual person affiliated
with the facility site.
A(30)
Alternate Telephone
Number
An alternate telephone number of an individual person affiliated with the facility site.
A(30)
Mailing Address
The exact address where a mail piece is intended to be delivered, including urban-style
street address, rural route, and PO Box.
A(50)
Supplemental Address
Text
The text that provides additional information to facilitate the delivery of a mail piece,
including building name, secondary units, and mail stop or local box numbers not
serviced by the USPS.
A(50)
Mailing Address City
Name
The name of the city, town, or village where the mail is delivered.
A(30)
Mailing Address State
USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
Mailing Address State
Name
The name of the state where mail is delivered.
A(35)
12
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Mailing Address
Country Name
The name of the country where the addressee is located.
Default United States
A(44)
Mailing Address ZIP
Code
The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit
extension code (if available) that represents the geographic segment that is a subunit of
the ZIP Code, assigned by the USPS to a geographic location to facilitate mail delivery;
or the postal zone specific to the country, other than the U.S., where the mail is delivered.
A(14)
Source of Data
The source of the associated individual data.
A(25)
Last Reported Date
The most recent date the corresponding individual (contact) data was reported to the
Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
Mailing Address (Related to Facility)
The standard address used to send mail to a facility site.
Remarks: No mailinq address data.
Affiliation Type
The name that describes the type of mailing address affiliated with the facility site.
A (40)
Mailing Address
The exact address where a mail piece is intended to be delivered, including urban-style
street address, rural route, and PO Box.
A(50)
Supplemental Address
Text
The text that provides additional information to facilitate the delivery of a mail piece,
including building name, secondary units, and mail stop or local box numbers not
serviced by the USPS.
A(50)
Mailing Address City
Name
The name of the city, town, or village where the mail is delivered.
A(30)
Mailing Address State
USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
Mailing Address State
Name
The name of the state where mail is delivered.
A(35)
13
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Mailing Address
Country Name
The name of the country where the addressee is located.
Default United States
A(44)
Mailing Address ZIP
Code
The combination of the 5-digit Zone Improvement Plan (ZIP) code and the four-digit
extension code (if available) that represents the geographic segment that is a subunit of
the ZIP Code, assigned by the USPS to a geographic location to facilitate mail delivery;
or the postal zone specific to the country, other than the U.S., where the mail is delivered.
A(14)
Source of Data
The source of the associated mailing address data.
A(25)
Last Reported Date
The most recent date the corresponding mailing address data was reported to the
Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
Standard Industrial Classification
The Standard Industrial Classification (SIC) or type of business activity, occurring at the facility site.
Remarks: No SIC data.
Standard Industrial
Classification (SIC)
Code
The code that represents the economic activity of a company (4-digits).
A(4)
SIC Primary Indicator
The name that indicates whether the associated SIC Code represents the primary activity
occurring at the facility site.
Allowable Values:
Value Meanina
Primary The SIC Code represents the primary activity occurring at the facility
site.
Secondary The SIC Code represents a secondary activity occurring at the facility
site.
Unknown It is not known whether the SIC Code represents the primary or
secondary activity at the facility site.
A(10)
Source of Data
The source of the associated SIC data.
A(25)
14
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
FRS Data Element
Name
FRS Data Element Definition
Format
eGRID
Table.Column {comments}
Last Reported Date
The most recent date the corresponding SIC data was reported to the Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
North American Industry Classification
The North American Industry Classification System (NAICS) code or type of industrial activity, occurring at the facility site.
Remarks: No NAICS data.
North American U.S.
National Industry
Classification System
(NAICS) Code
The code that represents a subdivision of an industry that accommodates user needs in
the United States (6-digits).
A(6)
NAICS Primary
Indicator
The name that indicates whether the associated NAICS Code represents the primary
activity occurring at the facility site.
Allowable Values:
Value Meanina
Primary The NAICS Code represents the primary activity occurring at the facility
site.
Secondary The NAICS Code represents a secondary activity occurring at the
facility site.
Unknown It is not known whether the NAICS Code represents the primary or
secondary activity at the facility site.
A(10)
Source of Data
The source of the associated NAICS data.
A(25)
Last Reported Date
The most recent date the corresponding NAICS data was reported to the Source of Data.
Date
Sensitive Indicator
Indicates whether or not the associated data is enforcement sensitive.
A(1)
Public Indicator
Indicates whether or not the associated data is accessible by the public on the internet.
A(1)
1 This plant code was originally developed for power plants by the Office of the Regulatory Information System (ORIS), which was a part of the Federal Power
Commission. It is now assigned by the Energy Information Administration (EIS) and is used as a unique plant identification code for many EPA electric power
15
-------
Facility Registry System (FRS) / Emissions & Generation Resource Integrated Database (eGRID2012)
Data Element Mapping
revised March 7, 2014
databases. One plant code, for Laramie River, has been altered.
If Plant primary fuel generation category (PLPFGNCT) =
'GEOTHERMAL'
'NUCLEAR'
'SOLAR'
'HYDRO'
'WIND'
INTEREST_TYPE=
INTEREST_TYPE=
INTEREST_TYPE=
INTEREST_TYPE=
INTEREST TYPE =
'ELECTRIC POWER GENERATOR (GEOTHERMAL BASED)'
'ELECTRIC POWER GENERATOR (NUCLEAR BASED)'
'ELECTRIC POWER GENERATOR (SOLAR BASED)'
'ELECTRIC POWER GENERATOR (WATER BASED)'
'ELECTRIC POWER GENERATOR (WIND BASED)'
Else If Plant primary coal/oil/gas/other fossil fuel category (PLFUELCT):
'COAL'
'OIL'
'GAS'
'OFSL'
INTEREST_TYPE=
INTEREST_TYPE=
INTEREST_TYPE=
INTEREST TYPE =
'ELECTRIC POWER GENERATOR (COAL BASED)'
'ELECTRIC POWER GENERATOR (OIL BASED)'
'ELECTRIC POWER GENERATOR (GAS BASED)'
'ELECTRIC POWER GENERATOR (OTHER FOSSIL FUEL BASED)'
((Null or Blank) and Plant primary fuel (PLPRMFL) = 'OTH' or 'PUR' or 'WH') or PLPFGNCT = 'WSTHTOTPUR'
Else,
INTEREST_TYPE=
INTEREST TYPE =
'ELECTRIC POWER GENERATOR (UNKNOWN/OTHER SOURCE)'
'ELECTRIC POWER GENERATOR (BIOMASS BASED)'
16
------- |