Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
Program Facility
Basic identification information for a facility site, including the facility registry identifier, geographic address, and geopolitical descriptors.
Remarks. The 2012 EIA-860 dataset was downloaded from the U.S. Enerqv Information Administration (EIA) website. The dataset consisted of eiqht self-
extracting spreadsheets, of which FRS uses 4: PlantY2012, UtilityY2012, GeneratorY2012, and OwnerY20129. The final EIA-860 2012 dataset was released by
EIA October 10, 2013.
Environmental
Information System
Abbreviated Name
The abbreviated name that represents the name of an information management system
for an environmental program.
A(20)
'EIA-860'
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)
PlantY2012. PLANT_CODE
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)
PlantY2012.PLANT_NAME
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)
PlantY2012.STREET_ADDRESS
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)
PlantY2012.CITY
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)
County Name
The name of the U.S. county or county equivalent in which the facility site is physically
located.
A(35)
PlantY2012. COUNTY
1
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
State USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
PlantY2012.STATE
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)
PlantY2012.ZIP5
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) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.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)
'EIA-860'
Last Reported Date
The most recent date the corresponding facility site data was reported to the Source of
Data.
Date
12/31/2012
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) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.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.
Allowable Values', (examples)
Value Meaninq
SUPERFUND NPL Superfund National Priority List (NPL) Site
SUPERFUND Superfund Site
AIR MAJOR Clean Air Act Stationary Source Major
AIR MINOR Clean Air Act Stationary Source Minor
ELECTRIC GENERATOR Electric Power Plant
A(60)
'ELECTRIC GENERATOR'
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, Planned,
Retired).
A(50)
See endnote'
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', (examples)
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
4
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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'. (examDlesi
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)
'EIA-860'
Last Reported Date
The most recent date the corresponding environmental interest data was reported to the
Source of Data.
Date
12/31/2012
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)
5
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
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 th e 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)
PlantY2012. LATITUDE
Longitude Measure
The measure of the angular distance on a meridian east or west of the prime meridian.
(10,6)
PlantY2012. LONGITUDE
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)
6
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
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)
7
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
Code
The code that represents the method used to collect the vertical measure (i.e., the
altitude) of a reference point.
A(3)
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)
'EIA-860'
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) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
Organization Affiliate
A company, government body, or other type of organization that has some responsibility or role at the facility site.
Remarks: The Orqanization data is in the UtilitvY2012 spreadsheet, bv UTILITY ID. Each plant has a UTILITY ID in the PlantY2012 table, which represents
the "OWNER/OPERATOR". If that "OWNER/OPERATOR" is jointly owned or wholly owned by someone other than the operator, the organ izations are identified
by a code (OWNERSHIPJD) in the OwnerY2012 spreadsheet by generator. The OwnerY2012 spreadsheet has multiple records (generators) per facility;
however, for the most part, the PERCENT_OWNED is the same from one generator to the next for the same facility.
If the plant (PLANT_CODE) is found in OwnerY2012 and PlantY2012.UTILITY_ID <> OwnerY2012.UTILITY_ID and the PERCENT_OWNED = '100', then
create 2 FRS_RES_ORG records:
1) AFFILIATION TYPE = 'OPERATOR', using data from UtilityY2012 where PlantY2012.UTILITY_ID = UtilityY2012.UTILITY_ID
2) AFFILIATION TYPE = 'PARENT COMPANY' using data from Util2010 where OwnerY2012.OWNERSHIP_ID = UtilityY2012.UTILITY_ID.
Else If the plant (PLANT_CODE) is found in OwnerY2012 and the PERCENT_OWNED < '100', then create 2 types of FRS_RES_ORG records:
1) AFFILIATION TYPE = 'OWNER/OPERATOR', using data from UtilityY2012 where PlantY2012.UTILITY_ID = UtilityY2012.UTILITY_ID
2) AFFILIATION TYPE = 'JOINT PARENT COMPANY' where OwnerY2012.OWNERSHIP ID = UtilityY2012.UTILITY ID. Create additional Organization records
with AFFILIATION TYPE = 'JOINT PARENT COMPANY' by selecting distinct OWNERSHIP ID from OwnerY2012 for each PLANT CODE (excluding the same
UTILITYJD found in the PlantY2012 record).
Else if the plant (PLANT CODE) is not found in OwnerY2012, create one FRS RES ORG record with AFFILIATION TYPE = 'OWNER/OPERATOR', using data
from UtilityY2012 where PlantY2012.UTILITY_ID = UtilityY2012.UTILITY_ID.
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', 'JOINT
PARENT COMPANY',
'OPERATOR', or'PARENT
COMPANY' {See description
above}
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
9
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
Ownership Percentage
Percent of the associated facility owned by the organization.
N(3)
OwnerY2012. Percent_Owned
If AFFILIATION TYPE =
'OWNER/OPERATOR' {i.e.,
PLANT CODE not in
OwnerY2012}
Then 100
Organization Formal
Name
The legal, formal name of an organization that is affiliated with the facility site.
A(80)
UtilityY2012.UTILITY_NAME
Organization DUNS
Number
The Data Universal Numbering System (DUNS) number assigned by Dun and Bradstreet
to identify unique business establishments.
A(9)
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)
10
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
UtilityY2012.
STREET_ADDRESS
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)
Uti lity Y2012. CITY
Mailing Address State
USPS Code
The USPS abbreviation that represents the state or state equivalent for the U.S. and
Canada.
A(5)
UtilityY2012.STATE
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)
UtilityY2012.ZIP5
Source of Data
The source of the associated organization data.
A(25)
'EIA-860'
Last Reported Date
The most recent date the corresponding organization data was reported to the Source of
Data.
Date
12/31/2012
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'
11
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
Individual Affiliate
An individual person who has some responsibility or role at the facility site.
Remarks: No Individual Affiliation (i.e.. 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
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)
12
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
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 Mailina Address data.
Affiliation Type
The name that describes the type of mailing address affiliated with the facility site.
A (40) ||
13
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
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)
14
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
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)
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)
15
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012) revised October 29, 2013
Data Element Mapping
FRS Data Element
Name
FRS Data Element Definition
Format
EIA-860 WORKSHEET.COLUMN
{COMMENTS}
North American Industry Classification
The North American Industry Classification System (NAICS) code or type of industrial activity, occurring at the facility site.
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)
PlantY2012.
PRIMARY_PURPOSE
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)
'PRIMARY'
Source of Data
The source of the associated NAICS data.
A(25)
'EIA-860'
Last Reported Date
The most recent date the corresponding NAICS data was reported to the Source of Data.
Date
12/31/2012
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'
The GeneratorY2012 Spreadsheet has 3 worksheets: 'operable', 'proposed', and 'retired & canceled'.
To populate ACTIVE_STATUS:
For each PLANT_CODE, search for rows in the 'operable' Worksheet oV'GeneratorY2012"
If found and If STATUS = 'OP' {for one or more rows}
Then 'OPERATING'
Else if STATUS = 'SB' {for one or more rows}
16
-------
Facility Registry System (FRS) / Energy Information Administration (EIA-860 2012)
Data Element Mapping
revised October 29, 2013
Then 'STANDBY/BACKUP'
Else if STATUS = 'OA' {for one or more rows}
Then 'OUT OF SERVICE - WILL BE RETURNED'
Else if STATUS = 'OS' {for one or more rows}
Then 'OUT OF SERVICE - WILL NOT BE RETURNED'
Else search for rows in the 'proposed' Worksheet of "GeneratorY2012"
If found and If STATUS = 'TS' {for one or more rows}
Then 'CONSTRUCTION COMPLETE, NOT YET OPERATIONAL'
Else if STATUS = 'P' {for one or more rows}
Then 'PLANNED, APPROVALS NOT INITIATED'
Else if STATUS = 'L' {for one or more rows}
Then 'PLANNED, APPROVALS PENDING'
Else if STATUS = 'T' {for one or more rows}
Then 'PLANNED, APPROVALS RECEIVED'
Else if STATUS = 'U' {for one or more rows}
Then 'UNDER CONSTRUCTION, < 50 % COMPLETE'
Else if STATUS = 'V' {for one or more rows}
Then 'UNDER CONSTRUCTION, > 50 % COMPLETE'
Else if STATUS = 'OT' {for one or more rows}
Then 'OTHER'
Else search for rows in the 'retired & canceled' Worksheet of "GeneratorY2012"
If found and If STATUS = 'RE' {for one or more rows}
Then 'RETIRED'
Else if STATUS = 'IP' {for one or more rows}
Then 'CANCELED, POSTPONED, OR NO LONGER PLANNED'
Else 'UNKNOWN'
17
------- |