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