Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) Data Element Mapping revised August 1, 2013

Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Program Facility

Basic identification information for a facility site, as reported by an information management system for an environmental program.

Remarks. Most values are selected from the GRANT PROPERTY table, except for STATE CODE. STATE NAME, and EPA REGION CODE, which are
derived also using the REF STATE table and the FIPS CODE, COUNTY NAME, TRIBAL LAND CODE and TRIBAL LAND NAME, which may be populated
from the JURISDICTION Table. To select from the JURISDICTION table, 4 tables are joined. GRANT PROPERTY is joined with GRANT PROPERTY ASSOC
using PROPERTY ID. GRANT PROPERTY ASSOC is joined with JURISDICTION ASSOC using GRANT ID and JURISDICTION ASSOC is joined with
JURISDICTION using JURISDICTION ID.

Environmental
Information System
Abbreviated Name

The abbreviated name that represents the name of an information
management system for an environmental program.

A(20)

ACRES'

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)

GRANT_PROPERTY.PROPERTY_ID

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)

GRANT_PROPERTY.PROPERTY_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)

GRANT_PROPERTY.ADDRESS1

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)

GRANT_PROPERTY.ADDRESS2

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 USPS mail delivery.

A(60)

GRANT_PROPERTY.CITY

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{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)

If GRANT_PROPERTY.COUNTY not null,
JURISDICTION.FIPS_CODE where
GRANT PROPERTY.COUNTY =
JURISDICTION.JURISDICTION NAME
and JURISDICTION.
JURISDICTION_TYPE_ID = '1002'

Else

JURISDICTION.FIPS CODE where
JURISDICTION.

JURISDICTION_TYPE_ID = '1002'

County Name

The name of the U.S. county or county equivalent in which the facility site
is physically located.

A(35)

If GRANT_PROPERTY.COUNTY not null,

GRANT_PROPERTY. COUNTY
Else

JURISDICTION.JURISDICTION NAME
where JURISDICTION.
JURISDICTION_TYPE_ID = '1002'

State USPS Code

The U.S. Postal Service abbreviation that represents the state or state
equivalent for the U.S. and Canada.

A(5)

REF STATE.LABEL STATE
where GRANT PROPERTY.STATE ID
= REF_STATE.STATE_ID

State Name

The name of a principal administrative subdivision of the United States,
Canada, or Mexico.

A(35)

REF STATE.LABEL STATE LONG
where GRANT PROPERTY.STATE ID
= REF_STATE.STATE_ID

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 U.S. Postal
Service 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)

GRANT_PROPERTY.ZIP_CODE

2

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

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 Meanina

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.

A(1)

If JURISDICTION.
JURISDICTION_TYPE_ID = '1004'
Then, 'Y'

Else, 'N'

Tribal Land Name

The name of an American Indian or Alaskan native area where the facility
site is located.

A(200)

JURISDICTION. JURISDICTION_NAME
{If Tribal Land Indicator Code = 'Y' as
described above}

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)



3

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

EPA Region Code

The code that represents an EPA region.

A(2)

substr( REF_STATE.REGION_ID,3,2)
where GRANT PROPERTY.STATE ID =
REF_STATE.STATE_ID

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 Brownfields Site

A(40)

'BROWNFIELDS SITE'

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 program facility data.

A(25)

ACRES'

Last Reported Date

The most recent date the corresponding facility site data was reported to
the Source of Data.

Date

GRANT_PROPERTY. MOD_DATE

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'

4

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{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 Meanina

SUPERFUND NPL Superfund National Priority List (NPL) Site
SUPERFUND Superfund Site
BROWNFIELDS PROPERTY Brownfields Property

A(60)

'BROWNFIELDS PROPERTY

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, state, tribal, or private 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

A(50)

First Reporting Year Earliest Inspection Date
First Report Received Date Operations Start Date
First Report Postmark Date Monitoring Start Date
Original Permit Issue Date

Environmental Interest
End Date

Date the agency ceased to be interested in the facility site for a particular
environmental interest type.

Date

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{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
Permit Expiration Date Reissued as General Permit Date
Operations End Date De-registration Effective Date
Final Cleanup Date

A(50)



Source of Data

The source of the associated environmental interest data.

A(25)

ACRES'

Last Reported Date

The most recent date the corresponding environmental interest data was
reported to the Source of Data.

Date

GRANT_PROPERTY. MOD_DATE

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.

Alternative Name

An alternative, historic or program-specific name for the facility site.

A(80)

GRANT_PROPERTY.P_ALIAS_NAME {If
not null and only if different from
PROPERTY_NAME}

GRANT_PROPERTY.P_EPA_FRS_SITE_
NAME {If not null and only if different from
PROPERTY_NAME and P.ALIAS_NAME}

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)

ALIAS NAME'

If P_RCRA_INDICATOR = 'Y'

'RCRAINFO PROGRAM NAME'
Else If P_WASTELAN_INDICATOR = 'Y'
'CERCLIS PROGRAM NAME'

Else,

ALIAS NAME'

6

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Source of Data

The source of the associated alternative name data.

A(25)

ACRES'

Last Reported Date

The most recent date the corresponding alternative name data was
reported to the Source of Data.

Date

GRANT_PROPERTY. MOD_DATE

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 Identification

An alternative identifier for the facility site, as maintained by an information management system for an environmental program.

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)

If P_RCRA_INDICATOR = 'Y'

'RCRAINFO'

Else If P_WASTELAN_INDICATOR = 'Y'
'CERCLIS'

Else,

'UNKNOWN'

Alternative Identifier

An alternative identification number maintained by an information
management system for an environmental program.

A(30)

GRANT_PROPERTY.P_EPA_FRS_ID {if
not null or blank}

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)

ACRES'

Last Reported Date

The most recent date the corresponding alternative name data was
reported to the Source of Data.

Date

GRANT_PROPERTY. MOD_DATE

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'

7

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

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)

GRANT PROPERTY.
LATITU D E_M E AS U R E

Longitude Measure

The measure of the angular distance on a meridian east or west of the
prime meridian.

(10,6)

GRANT PROPERTY.
LONGITUDE_MEASURE

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)

GRANT_PROPERTY.HCM_ID

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)

GRANT_PROPERTY.SRC_MAP_SCALE_
NUM {convert to a number}

Horizontal Accuracy
Measure

The measure of the accuracy (in meters) of the latitude and longitude
coordinates.

N(6)

GRANT PROPERTY.
HORIZ_ACCURACY_MEASURE

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)

GRANT_PROPERTY.REF_POINT_ID

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)

GRANT_PROPERTY.DATUM_CODE_ID

Name

The name that describes the reference datum used in determining latitude
and longitude coordinates.

A(7)



8

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

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)



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)



9

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

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

GEOMETRY



Conveyor of Record

The source of the associated geographic coordinate data.

A(25)

ACRES'

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)



Organization Affiliate

A company, government body, or other type of organization that has some responsibility or role at the facility site.

Affiliation Type

The name that describes the capacity or function that an individual serves

for a facility site.

Allowable Values (examples)'.

Owner/Operator Responsible Party

Operator Parent Company

Owner Property Owner

A (40)

'PROPERTY OWNER'

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



Ownership Percentage

Percent of the associated facility owned by the organization.

N(3)



10

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Organization Formal
Name

The legal, formal name of an organization that is affiliated with the facility
site.

A(80)

GRANT_PROPERTY.CURRENT_OWNER

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)

If GRANT PROPERTY.
OWNERSHIP_ENTITY_ID =
'1' 'GOVERNMENT'
'2' 'PRIVATE'

Else Null

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)



11

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{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 organization data.

A(25)

ACRES'

Last Reported Date

The most recent date the corresponding organization data was reported
to the Source of Data.

Date



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'

12

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Individual Affiliate





An individual person who has some responsibility or role at the facility site.

Remarks. GRANT PROPERTY is ioined with GRANT PROPERTY ASSOC usinq PROPERTY ID and GRANT PROPERTY ASSOC is ioined with
USER_GRANT_ASSOC using GRANTJD. Selecting only USERJDs where FLAG_PRIMARY = 'Y', USER_GRANT_ASSOC is joined with USERS and USERS
is joined with ROLE ASSOC. ROLE ASSOC is joined with REF ROLE using ROLE ID. Only active contact records are selected (where
USERS.FLAG_ACTIVE_USER <> 'N').

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)

REF_ROLE.LABEL_ROLE
Where REF ROLE.ROLE ID =
ROLE_ASSOC.ROLE_ID

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)

USERS.FIRST NAME ||' '||
USERS.MIDDLE INITIAL ||' '||
USERS.LAST_NAME ||' '|| SUFFIX
{Include '' only if next data element has a
value.}

Individual Title Text

The title held by a person in an organization.

A(40)

USERS. JOB_TITLE

Company Division
Name

The name of a division or a department of a company.

A(50)

si/£>sf/tUSERS.ORGANIZATION, 1, 50)

E-mail Address

The text that describes an electronic mail address of an individual person
affiliated with the facility site.

A(120)

USERS.E_MAIL

Telephone Number

The primary telephone number of an individual person affiliated with the
facility site.

A(30)

USERS.PHONE

13

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

FAX Number

The telephone number to which a facsimile can be sent to an individual
person affiliated with the facility site.

A(30)

USERS.FAX

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)

USERS. ADDRESS1

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)

USERS. ADDRESS2

Mailing Address City
Name

The name of the city, town, or village where the mail is delivered.

A(30)

USERS.CITY

Mailing Address State
USPS Code

The USPS abbreviation that represents the state or state equivalent for
the U.S. and Canada.

A(5)

REF_STATE.LABEL_STATE

where USERS.STATE ID =
REF STATE.STATE ID

Mailing Address State
Name

The name of the state where mail is delivered.

A(35)

REF_STATE.LABEL_STATE_LONG
where USERS.STATE ID =
REF_STATE.STATE_ID

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)

USERS.ZIP_CODE

Source of Data

The source of the associated individual data.

A(25)

ACRES'

Last Reported Date

The most recent date the corresponding organization data was reported
to the Source of Data.

Date

USERS. MOD_DATE

Sensitive Indicator

Indicates whether or not the associated data is enforcement sensitive.

A(1)

'N'

14

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Public Indicator

Indicates whether or not the associated data is accessible by the public
on the internet.

A(1)

'Y'

Mailing Address

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 U.S. Postal Service.

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 U.S. Postal Service abbreviation that represents the state or state
equivalent for the U.S. and Canada.

A(2)



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 U.S. Postal
Service 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)



15

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

Last Reported Date

The most recent date the corresponding organization 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)

Last Reported Date

The most recent date the corresponding organization 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)

-------
Facility Registry System (FRS) / Assessment, Cleanup and Redevelopment Exchange System (ACRES) revised August 1,2013
Data Element Mapping

FRS Data Element
Name

FRS Data Element Definition

Format

ACRES Table Name.Column Name

{COMMENTS}

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 organization 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 7

-------