RSEI Data Dictionary: Submission Data

The following tables provide descriptions for each field in each table. Note that for the Geographic Microdata, "Other Geographies" includes block groups, census tracts, and ZIP code files. For more information, see the RSEI methodology document and the RSEI Microdata documentation.

Tables in the RSEI Data Dictionary
Facility	Chemical	Disaggregated Grid Cell Geographic Microdata	Aggregated Grid Cell Geographic Microdata for States
Off-site	MCL	Aggregated Grid Cell Geographic Microdata	Water Geographic Microdata
Submissions	Releases	Disaggregated Geographic Microdata for Other Geographies	Grid Shapefiles
Elements	Media	Aggregated Geographic Microdata for Other Geographies	Census Crosswalks
NAICS	Category	Geographic Microdata Shapefiles for Other Geographies	Population Data

The Submissions table contains Form R information submitted to TRI.

The Submissions, Elements, and Releases tables are too large for spreadsheet format.

This table is from RSEI Version 2.3.12 (RY 2022) and cannot be used with tables from any other version.

RSEI Submissions Table (Text Format) (zip)

Submissions Data
Variable	Description
DCN	Unique identifier assigned by TRI to each facility submission (document control number).
SubmissionNumber	Internal identifier assigned to each submission.
FacilityNumber	Internal identifier unique to each facility (links to Facility table).
FacilityID	Unique TRI Identifier for facility (TRI Facility ID).
CAS	Chemical Abstracts Service (CAS) Registry Number, which identifies a unique chemical. For chemical categories, CAS Numbers begin with “N”, followed by three digits (no hyphens).
ChemicalNumber	Internal identifier unique to each chemical (links to Chemical table).
SubmissionYear	Year of facility release.
MPOUse	Code describing how chemical is used in reporting facility, as reported on TRI Reporting Form R.
MaxOnsite	Code describing the maximum amount of the chemical on-site at reporting facility, as reported in TRI Reporting Form R.
EntireFac	'1' if “Entire” was checked on the Form R, indicating that the submitted Form R report is an entire report.
OneTimeReleaseQty	Quantity of the chemical released into the environment in the current reporting year due to catastrophe or remedial action.
OneTimeReleaseQtyNA	'1' if “NA” was entered for the one time release quantity on the Form R.
PartialFac	'1' if “Partial” was checked on the Form R, indicating that the submitted Form R report is a partial report.
TradeSecretInd	'1' if Trade Secret “YES” was checked on the Form R, indicating that the reporting facility claims the identity of the chemical or chemical category as a trade secret.
FormTypeIndicator	An indicator identifying whether a Form R or a Certification Statement was submitted. L = Long form (Form R) S = Short Form (Form A, Certification Statement)

RSEI Data Dictionary: Submission Data

Submissions Data

Risk-Screening Environmental Indicators (RSEI) Model