vvEm
United States Office of
Environmental Protection Solid Waste
Agency Washington, DC 20460 November 2003
RCRAInfo
File Specification Guide
2003 Hazardous Waste
Report Submissions
-------
-------
TABLE OF CONTENTS
Page
1.0 INTRODUCTION 4
1.1 Overview of Document 4
1.2 Intended Audience 4
1.3 Hazardous Waste Report Forms 5
1.4 Data Files 5
1.5 Questions/Comments 6
2.0 CHANGES I ROM PREVIOUS CYCLES 7
2.1 Data Collection Changes 7
2.2 Changes to the File Specification Standards 7
2.3 Changes to Data Element Edits 7
3.0 DATA SUBMISSION OVERVIEW 9
3.1 Data Requirements 9
3.2 Data Submission 9
3.3 Amount of Data in a Single Submission 10
3.4 States/Regions not using the 2003 Hazardous Waste Report, Instructions and Forms 10
3.4.1 Identify Sites 11
3.4.2 Access Equivalent Data 11
3.4.3 Data Quality/Equivalency 12
3.4.4 Write Translated Data to Flat Files 12
3.4.5 Generating a Control File 13
4.0 TECHNICAL SPECIFICATIONS 14
4.1 Include in National Report Flags 14
4.2 State Generator Status 14
4.3 Rules and Format Conventions Required for Data Flat Files 14
4.3.1 Alphanumeric Fields 14
4.3.2 Integer Fields 15
4.3.3 Fixed Decimal Fields 15
4.3.4 Sequence Number Fields 16
4.3.5 Negative Numbers 16
4.4 Indicating Don't Know (DK) and Not Applicable (NA) 16
4.5 Record Termination 16
4.6 Empty Fields 16
4.7 Flat File Hierarchy 16
4.8 Confidential Business Information (CBI) 16
APPENDIX A - Required Data Elements A-l
Required Fields for Flat File SI1 A-l
Required Fields for Flat File SI2 A-2
Required Fields for Flat File SI6 A-3
Required Fields for Flat File SI7 A-3
Required Fields for Flat File SI9 A-3
Required Fields for Flat File GM1 A-4
Required Fields for Flat File GM2 or GM3 A-4
Required Fields for Flat File GM4 A-5
Required Fields for Flat File GM5 A-5
Required Fields for Flat File WR1 A-6
Required Fields for Flat File WR2 or WR3 A-6
November 2003
File Specification Guide
-------
TABLE OF CONTENTS
APPENDIX B - Flat File Specifications B-l
B. 1 Key For Flat File Tables B-l
B.2 Flat File Naming Convention B-l
B.3 Flat Files B-2
FLAT FILE ID# - CTL B-2
FLAT FILE ID# - SI 1 B-3
FLAT FILE ID# - SI2 B-6
FLAT FILE ID# - SI3 B-8
FLAT FILE ID# - SI4 B-9
FLAT FILE ID# - SI5 B-10
FLAT FILE ID# - SI6 B-l 1
FLAT FILE ID# - SI7 B-12
FLAT FILE ID# - SI8 B-l3
FLAT FILE ID# - SI9 B-14
FLAT FILE ID# - GM1 B-l6
FLAT FILE ID# - GM2 B-l 8
FLAT FILE ID# - GM3 B-19
FLAT FILE ID# - GM4 B-20
FLAT FILE ID# - GM5 B-21
FLAT FILE ID# - WR1 B-22
FLAT FILE ID# - WR2 B-24
FLAT FILE ID# - WR3 B-25
FLAT FILE ID# - Oil B-26
APPENDIX C - Data Assessment Edits C-l
C. 1 Generic Data Edits C-l
C.2 Control File Edits C-2
C.3 Site Identification Form Edits C-3
C.4 Form GM Edits C-9
C.5 Form WR Edits (-12
APPENDIX D - Hazardous Waste Report Annotated Forms D-l
APPENDIX E - Flat File Hierarchy E-l
APPENDIX F - State Postal Codes F-l
November 2003
File Specification Guide
-------
1.0 INTRODUCTION
This document describes the file specifications for reporting data for the 2003 Hazardous Waste Report
(also called the Biennial Report). The material in this guide covers submissions by States and Regions to
EPA Headquarters (HQ). The file specifications in this guide are not intended to be used to cover
submissions by individual reporting sites. Also, this guide is only intended to specify the file and data
formats for the submission and is not intended to cover any procedural or EPA programmatic issues.
This document is designed to be used in conjunction with the 2003 Hazardous Waste Report, Instructions
and Forms, EPA Form 8700-13A/B that is referenced throughout this document. You should have a
complete copy of the 2003 Hazardous Waste Report, Instructions and Forms in your possession while
using this guide. Copies of the 2003 Hazardous Waste Report, Instructions and Forms are available at
http: //www .epa. gov/epaoswer/hazwaste/data/ #brs.
1.1 Overview of Document
The File Specification Guide for 2003 Biennial Report Hazardous Waste Submissions is divided into four
sections:
Section 1 (Introduction) defines the intended audience for this guide, offers a brief description of the
forms contained in the 2003 Hazardous Waste Report, Instructions and Forms, and describes the general
purpose and outline of this document.
Section 2 (Changes from Previous Cycles) outlines the major changes to the file specifications from
previous Biennial Report cycles.
Section 3 (Data Submission Overview) describes the overall characteristics for a data submission.
Section 4 (Technical Specifications) discusses the technical details of the data files and programs
necessary for data submission.
Several appendices are included with this document. These appendices provide background material as
well as detailed technical information necessary to properly prepare file submissions.
1.2 Intended Audience
The intended audience for this guide is any State or EPA Region that is using its own software and
procedures to extract hazardous waste data from a State or Regional system for submission to EPA HQ
for inclusion in the RCRAInfo database for the 2003 Hazardous Waste Report; or any commercial
software vendor who is preparing software for use/purchase by States and Regions for preparation of
State or Regional submission of data for the 2003 Hazardous Waste Report.
(Note: States or Regions who use a data collection instrument different than the Hazardous Waste Report,
Instructions and Forms developed by EPA HQ are called translators. This guide will serve as guidance
for both translators and commercial software vendors.)
This document was written assuming the reader 1) is familiar with the 2003 Hazardous Waste Report,
Instructions and Forms and 2) understands basic computer concepts and terminology.
November 2003
4
File Specification Guide
-------
1.3
Hazardous Waste Report Forms
The 2003 Hazardous Waste Report, Instructions and Forms document captures information on the
following forms:
RCRA Subtitle C Site Identification Form
The Site Identification Form collects information on the site completing the Biennial Report
forms package. The form is divided into thirteen items, twelve of which must be completed for
the Hazardous Waste Report. States and Regions submit Site ID form information via the SI1,
SI2, SI3, SI4, SI5, SI6, SI7, and SI9 flat files.
Note: The SI8 flat file allows implementers to include State specific activities in their Biennial
Report submission. This information is not found on the RCRA Subtitle C Site Identification
Form, but rather is implementer defined to meet the State's regulatory requirements.
Form GM
Form GM is for reporting on-site hazardous waste generation, management, and off-site
shipment. Form GM is divided into three sections that document 1) the source, characteristics,
and quantity of hazardous waste generated; 2) the quantity of hazardous waste managed on-site
along with the management method used; and 3) the quantity of hazardous waste shipped off-site
for treatment, disposal, or recycling along with the off-site management method used. States and
Regions submit GM form information via the GM1, GM2, GM3, GM4, and GM5 flat files.
Form WR
Form WR identifies hazardous wastes that were received from other hazardous waste sites and
the method(s) used to manage them. Form WR is divided into three identical parts (i.e., waste
blocks), labeled Waste 1, Waste 2, and Waste 3, that collect information on the quantities and
characteristics of each hazardous waste received from an off-site source during 2003 and
managed on-site. States and Regions submit WR form information via the WR1, WR2, and WR3
flat files.
Form OI
Form OI documents the names and addresses of off-site installations and transporters. OI
information is not loaded into the RCRAInfo database, but a file specification has been included
to facilitate data sharing.
1.4 Data Files
Information gathered from the Hazardous Waste Report is submitted to EPA HQ via a series of flat files.
Each form contains information that relates to the form in a one-to-one (1:1) relationship (e.g., Form GM,
Section 1, Block D, source code). These data elements are captured in the primary flat file for that form
(e.g., SI1, GM1, and WR1). Information that relates to the form in a many-to-one (n: 1) relationship (e.g.,
Form GM, Section 1, Block B, EPA hazardous waste codes) is captured in secondary flat files (e.g.,
GM2-GM5, WR2-WR3).
November 2003
5
File Specification Guide
-------
The remainder of this document describes in detail the steps necessary to ensure a successful data
submission including identifying which sites should be reported, the types of files that must be included
with each submission, and technical aspects of the file creation process.
1.5 Questions/Comments
Questions about this document should be directed to the RCRAInfo help desk at rcrainfo.help@,epa.gov.
Questions submitted to the help desk must only concern the file specification for submission of data from
the States or EPA Regions to the RCRAInfo database. Questions on submissions of data by individual
sites should be directed to appropriate State or EPA Regional personnel.
November 2003
6
File Specification Guide
-------
2.0
CHANGES FROM PREVIOUS CYCLES
2.1 Data Collection Changes
The EPA has made modifications to the Hazardous Waste Report for the 2003 reporting cycle. For
further details on these changes, please refer to page 2 of the 2003 Hazardous Waste Report, Instructions
and Forms.
2.2 Changes to the File Specification Standards
The 2003 flat file specifications are being modified to reflect the current forms. Specific changes to the
flat file definitions include:
CTL - Added BR Cycle Year
SI 1 - Added State District as a non-required field
SI8 - State Activity Type field length changed from 1 character to 5 characters
GM1 - Added On-Site Management as a required field
GM1 - Added Off-Site Shipment as a required field
2.3 Changes to Data Element Edits
This section shows changes in the edits to data elements. These edit changes were necessary to comply
with the 2003 Hazardous Waste Report, Instructions and Forms and/or to ensure correctness of the data.
• CTL - The control file name must be named ssCTLnnn.FIL where ss is the state postal code and
nnn is the Julian date when the file was created.
SI 1 - If the submittal reason is Hazardous Waste Report, the handler must already exist in RCRAInfo
SI 1 - Site Land Type is required
SI 1 - County Name must be a valid value in LU_COUNTY
SI 1 - Mailing State must not be provided if the mailing address is not within the United States
SI 1 - Mailing Country must be a valid value in LU COUNTRY
SI1 - Transporter Activity is required and allowed values are 'Y' and 'N'
SI1 - Recycler Activity is required and allowed values are 'Y' and 'N'
SI1 - Small Quantity On-Site Burner Exemption is required and allowed values are 'Y' and 'N'
SI 1 - Smelting, Melting, Refining Furnace Exemption is required and allowed values are 'Y' and 'N'
511 - Underground Injection Control is required and allowed values are 'Y' and 'N'
512 - Large Quantity Generator of Batteries is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Accumulator of Batteries is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Generator of Pesticides is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Accumulator of Pesticides is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Generator of Thermostats is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Accumulator of Thermostats is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Generator of Lamps is required and allowed values are 'Y' and 'N'
SI2 - Large Quantity Accumulator of Lamps is required and allowed values are 'Y' and 'N'
SI2 - Destination Facility for Universal Waste is required and allowed values are 'Y' and 'N'
SI2 - Used Oil Transporter is required and allowed values are 'Y' and 'N'
SI2 - Used Oil Transfer Facility is required and allowed values are 'Y' and 'N'
SI2 - Used Oil Processor is required and allowed values are 'Y' and 'N'
SI2 - Used Oil Refiner is required and allowed values are 'Y' and 'N'
November 2003
7
File Specification Guide
-------
• SI2 - Off-Specification Used Oil Burner is required and allowed values are 'Y' and 'N'
• SI2 - Used Oil Fuel Marketer Who Directs Shipment of Off-Specification Used Oil to Off-
Specification Used Oil Burner is required and allowed values are 'Y' and 'N'
• SI2 - Used Oil Fuel Marketer Who First Claims the Used Oil Meets the Specifications is required
and allowed values are Y' and 'N'
• SI6 - NAICS code must be a valid value in LU_NAICS
• SI7 - Certification date must be greater than or equal to January 1, 2004 and less than today
• SI9 - Current Owner/Operator information required for Submittal Reason = 'R' or 'B'
• GM1 - Added source codes G27, G63, G64, G65, G66, G67, G68, G69, G70, G71, G72, G73,
G74, G75
• GM1 - Deleted source code G62
• GM1 - The generated quantity must be > 0 and less than 99,999,999,998.999999 or equal to 0
• GM1 - The management method must be blank unless the source code = G25
• GM1 - Deleted RCRA-Radioactive Mixed flag
• GM1 - On-site management indicator must equal 'Y' or 'N'
• GM1 - If the on-site management indicator equals 'Y' then GM5 information must be provided
• GM1 - If the on-site management indicator equals 'N' then GM5 information must not be provided
• GM1 - Off-site shipment indicator must equal 'Y' or 'N'
• GM1 - If the off-site shipment indicator equals 'Y' then GM4 information must be provided
• GM1 - If the off-site shipment indicator equals 'N' then GM4 information must not be provided
• GM4 - The shipped quantity must be > 0 and less than 99,999,999,998.999999
• GM5 - The managed quantity must be > 0 and less than 99,999,999,998.999999
• WR1 - The received quantity must be > 0 and less than 99,999,999,998.999999
• WR1 - Deleted RCRA-Radioactive Mixed flag
November 2003
8
File Specification Guide
-------
3.0 DATA SUBMISSION OVERVIEW
3.1 Data Requirements
Data collected via the 2003 Hazardous Waste Report, Instructions and Forms may or may not be required
to be included in the Hazardous Waste Report submission. For the purposes of this document, "required"
refers to data elements that must be provided and cannot have a value of blank. The required data
elements are listed in Appendix A.
States and Regions are encouraged to provide as much data (required or not) as possible. This
information enhances the analytical usefulness of the Hazardous Waste Report data within RCRAInfo.
Specifically, non-required data elements of interest include form codes for all records contained in the
GM1 and WR1 files.
State, Regional, and commercial software packages must provide data for required data elements. Flat
files containing required data elements include:
• Form Site ID data (RCRA Subtitle C Site Identification Form):
Flat Files SI1, SI2, SI6, SI7, and SI9
• Form GM data (Waste Generation and Management):
Flat Files GM1, GM2, GM4, and GM5
• Form WR data (Waste Received from Off-site):
Flat Files WR1 and WR2
All data elements must be properly formatted and meet required data quality standards to be loaded into
RCRAInfo. The data quality standards for these elements are presented in Appendix C.
The Hazardous Waste Report data submission must also include a control file for proper loading into the
RCRAInfo database. The control file specifies each flat file to be loaded and the number of records
included in the flat file.
Appendix B contains the flat file specifications for all files (including the control file) needed to produce
the Hazardous Waste Report data submission.
3.2 Data Submission
It is the responsibility of the State, Regional, or commercial software package to produce a complete set
of correctly formatted files of a given State for inclusion in the RCRAInfo database. The RCRAInfo
application can only accommodate submissions containing all data for a given State, that is, data for a
single site cannot be loaded into RCRAInfo.
November 2003
9
File Specification Guide
-------
Flat files are transferred to the EPA Unix server via the RCRA Central Data Exchange (CDX) application
in accordance with the Memorandum of Understanding between the Region and the State. The data is
transferred to the EPA in the form of Windows-compatible ZIP files. The RCRAInfo File Transfer
Process extracts the files from these zip files and stores the data in Oracle database "staging" records for
further processing. The RCRA staging process is designed to run as a background process that
continuously looks for files to process. Therefore, there is no user interaction required once the
environment is configured and the process is started.
CDX provides an interface for submitters to upload a ZIP file from their local file location (commonly the
C:/ drive) to the CDX/RCRAInfo environments. The uploaded file must be in the form of a ZIP file and
must contain a mandatory control file that lists the names of the other files in the ZIP file. The ZIP file
must conform to PKWARE's (de facto) compression standard. The EPA has tested and approved two
compression utilities for use by submitters. They are available for download at
http: //www .epa. gov/cdx/te st/zipintro .htm.
The submitter must have a valid CDX user ID and password as well as a valid RCRAInfo (pre-
production) user ID and password. CDX user ID and passwords may be obtained at http://cdx.epa.gov or
at 888-890-1995. In addition, the Biennial Report Load Implementor of Record setting within
RCRAInfo must be appropriately set (Region or State).
3.3 Amount of Data in a Single Submission
Each data submission must contain ALL data for the State for which data is being submitted. Each data
submission will overwrite ALL existing 2003 Hazardous Waste Report data for the State in the
RCRAInfo database.
3.4 States/Regions not using the 2003 Hazardous Waste Report, Instructions and Forms
The information contained in this guide is equally applicable to States and Regions who use a different
data collection package than the 2003 Hazardous Waste Report, Instructions and Forms. Translators are
required to provide data equivalent to that collected by the 2003 Hazardous Waste Report, Instructions
and Forms (required data elements). The following information is provided to help translators become
familiar with the steps to ensure a successful data submission:
• Identify all sites for which information is to be translated.
• Access information that is equivalent to the 2003 Hazardous Waste Report data.
• Validate that the equivalent data conforms to the appropriate data quality standards.
• Write translated data to appropriate flat files.
• Generate a control file for the translated flat files.
November 2003
10
File Specification Guide
-------
3.4.1 Identify Sites
The State/Region must submit information for sites required to file the 2003 Hazardous Waste Report,
Instructions and Forms. The criteria that defines these sites is presented on page iii of the 2003
Hazardous Waste Report, Instructions and Forms under "Sites Required to File the Hazardous Waste
Report." States and Regions are not precluded from submitting information for sites not required to file
the 2003 Hazardous Waste Report, Instructions and Forms.
3.4.2 Access Equivalent Data
The required data elements for the sites being reported must be provided (see Appendix A for a complete
list of required data elements). The translator State/Region must identify in their system the data
elements and relationships equivalent to the data elements/relationships represented by the flat file
specifications provided in Appendix B.
The Form GM, Form WR, and Form 01 allow for multiple form submissions by a handler. Translator
States/Regions must also accommodate multiple "forms" by a handler as follows:
Form GM
Form GM collects data associated with a single reported waste. Translators must provide records
in the GM1 - GM5 files for each waste generated or managed during the reporting cycle. Thus,
each page number for the GM flat file records represents a single reported waste. All "GM" flat
file records containing data associated with the same waste reported for the same EPA ID will
have the same page number. Page number takes the value of "00001" for the first reported waste
(Form GM) and is incremented by one (1) with each following reported waste. (Note: The
instructions on assignment of page number for translators are different than for those
States/Regions/commercial software vendors supporting the 2003 Hazardous Waste Report,
Instructions and Forms. For vendors supporting the 2003 Hazardous Waste Report, Instructions
and Forms, page number should be the same as the number assigned by the respondent to the
actual form.)
Form WR
Form WR collects data associated with each reported waste received from off-site. Translators
must provide records in the WR1 - WR3 files for each waste received from off-site. All "WR"
flat file records containing data associated with the same received waste reported for the same
handler will have the same page number. Page number takes the value of "00001" for the first
received waste (Form WR) and is incremented by one (1) with each separate received waste
reported. The sub-page number for Form WR data must always be assigned the value of "1".
(Note: The instructions on assignment of page number and sub-page number for translators are
different than for those States/Regions/commercial software vendors supporting the 2003
Hazardous Waste Report, Instructions and Forms. For vendors supporting the 2003 Hazardous
Waste Report, Instructions and Forms, page number and sub-page number should be the same as
the number assigned by the respondent to the actual form. Sub-page number is '1' for the waste
reported in the "Waste 1" block of the WR form, '2' for the waste reported in the "Waste 2"
block of the WR form, and '3' for the waste reported in the "Waste 3" block of the WR form.)
November 2003
11
File Specification Guide
-------
Form OI
Form OI collects data identifying 1) handlers from whom waste was received and to whom waste
was shipped and 2) all transporters used to ship waste during the reporting cycle. These source,
destination, and transporting entities are identified by their EPA ID, name, and address. The page
number for the OI flat file records represents a single handler record. Page number takes the
value of "00001" for the first handler record and is incremented by one (1) with each separate
handler record reported.
3.4.3 Data Quality/Equivalency
The State/Region's translator data must provide an accurate representation of hazardous waste activity for
that State. In addition, the translator's data must pass a minimum set of data edits (see Appendix C) in
order to provide information comparable to data gathered with the 2003 Hazardous Waste Report,
Instructions and Forms and to be properly loaded into the RCRAInfo database. Data failing to conform
to the appropriate data quality edits will result in the entire data submission to RCRAInfo being rejected.
Appendix D contains an annotated copy of the 2003 Hazardous Waste Report forms showing in which
flat file each data element is located. In addition, all codes used in the submission must conform to
acceptable data values as specified in Appendix C.
3.4.4 Write Translated Data to Flat Files
Translator States/Regions must extract data from their State/Regional system and re-produce the data in
the flat file formats outlined in Appendix B. A complete translation effort may not necessarily include all
flat files. For example, a translator submitting Form GM data is not required to include the "GM3" flat
file (State waste codes) since it is non-required data. However, the State/Region is encouraged to include
in the Hazardous Waste Report data submission all data (required and non-required) that the State/Region
currently collects.
The flat file specifications for the Hazardous Waste Report data are based on a series of parent-child
relationships. A parent file (i.e., SI1, GM1, WR1) may have one or more child relationships with other
flat files (i.e., SI2-SI9, GM2-GM5, WR2-WR3). Child records may not exist without the existence of the
parent record (e.g., a record for site XYZ cannot exist in the GM2 file if a corresponding record does not
exist in the GM1 file). Appendix E shows the parent-child relationships for all flat files comprising the
Hazardous Waste Report data submission.
Data for a site should only be included in the Hazardous Waste Report data submission after all records
for that site pass all appropriate edit checks. If a site's data is incomplete, then the site's information
must not be included in the State's Hazardous Waste Report data submission. It is not sufficient to
eliminate the data element in error and submit the remainder of the site's data.
November 2003
12
File Specification Guide
-------
3.4.5 Generating a Control File
The translator must include a "control" file with all Hazardous Waste Report data submissions. The
specifications for this file are included in Appendix B. The control file records contain information
describing the flat files being submitted. One control file record is created for each submitted flat file.
These records MUST be in the following order:
SI1, SI2, SI3, SI4, SI5, SI6, SI7, SI8, SI9, GM1, GM2, GM3, GM4, GM5, WR1, WR2, WR3
Exhibit 1. Control File Flat File Order
Note: The control file should contain information only on the flat files submitted. If a flat file is not
submitted, no information for the file should be placed in the control file. The Oil flat file
should never be included in the control file because this form is not to be submitted to the
RCRAInfo database.
November 2003
13
File Specification Guide
-------
4.0 TECHNICAL SPECIFICATIONS
This section contains the standards that must be met when producing flat files for the Hazardous Waste
Report data submission. Failure to meet these specifications will result in the rejection of the flat files
and failure to load the data into the RCRAInfo database.
4.1 Include in National Report Flags
SI1, GM1, and WR1 file specifications include a field labeled INCLUDEINNATIONALREPORT.
The purpose of this field is to allow implementers to submit additional Hazardous Waste Report data (for
purposes of data sharing) but keep that data from being included in the National Biennial Hazardous
Waste Report. The field is defined as follows: If the INCLUDE IN NATIONAL REPORT flag in the
SI1 file is 'N' (No), then all the INCLUDE_IN_NATIONAL_REPORT flags for the site must also equal
'N' (No) else the submission will be in error. If the INCLUDE_IN_NATIONAL_REPORT flag in the SI1
file is 'Y' (Yes), implementers may set the flag in the GM1 and WR1 file as either 'Y' (Yes) or 'N' (No) to
indicate whether that particular waste should be included in the National Biennial Hazardous Waste
Report. It is anticipated that many implementers will default the value for these flags to Y' (Yes) in all
cases, however the specific implementation of how these flags are populated is determined by the
implementer.
4.2 State Generator Status
Implementers are required to furnish both the State specific generator status and the Federal generator
status for each site in their submission. Appropriate fields are included in the SI1 file specification for
this purpose. It is anticipated that many States whose regulations closely match the federal regulations,
either by reference or by inclusion, will choose for the values of these fields to be the same. The method
to populate these fields is determined by the implementer, however both fields must be provided or the
submission will be rejected.
4.3 Rules and Format Conventions Required for Data Flat Files
The following sections detail the correct field formats for the data in the flat files.
4.3.1 Alphanumeric Fields
Alphanumeric fields are identified in Appendix B as Data Type "A" fields. Data Type "A" fields must be
left-justified with all trailing spaces filled with the space character (i.e., ASCII HEX 0x20 or ASCII
Decimal 32).
Valid characters for alphanumeric fields are limited to:
~ ! # $ % A *()_+'- \ = :;?,./' " @ & [ ] | 1234567890ABCDEFGHIJKLMNOPQRSTUVWXYZ
Invalid characters for alphanumeric fields include:
{}<>
If the ' '<" or ">" symbols are used to indicate less than or greater than, it is recommended that these
symbols be replaced with "LT" or "GT".
As part of the RCRAInfo load routines, all lowercase letters (a-z) will be converted to uppercase
characters (A-Z). Lowercase letters will not cause a submission to be rejected, however the lowercase
letters will be converted to uppercase characters.
November 2003
14
File Specification Guide
-------
4.3.2 Integer Fields
Integer fields are identified in Appendix B as Data Type "I" fields.
Allowed values for integer fields are numbers 0-9 and the space character (ASCII Hex 0x20 or ASCII
Decimal 32).
Examples of incorrect and correct entries for an integer field defined with a length of five (5) are
presented in Exhibit 2 below.
INCORRECT
CORRECT
1A
1
10,000
10000
750.25
750
Exhibit 2. Incorrect and Correct Integer Entries
4.3.3 Fixed Decimal Fields
Fixed place decimal fields are identified in Appendix B as Data Type "D" fields.
For all "D" field entries, the flat file specifications indicate the number of digits that the data element is
allowed before the decimal and after the decimal. For example, D11.6 indicates that the number may
have up to 11 digits before the decimal and 6 digits after the decimal (99999999999.999999). The field
length includes the decimal character.
Allowed values for fixed decimal fields are numbers 0-9, the decimal character and the space
character (ASCII Hex 0x20 or ASCII Decimal 32).
Although some data blocks on the 2003 Hazardous Waste Report, Instructions and Forms provide for
only one decimal place, the translator flat files may allow additional decimal places to be represented in
"D" fields. Exhibit 3 shows incorrect and correct entries in a type "D5.2" field.
INCORRECT
CORRECT
10,032.1
10032.10
10,032A
10032
Exhibit 3. Incorrect and Correct Fixed Decimal Entries
November 2003
15
File Specification Guide
-------
4.3.4 Sequence Number Fields
Some of the files in Appendix B require a sequence number to be provided for each record. The SI6 file,
for example, requires a sequence number (NAICS_SEQ) for the NAICS codes. The sequence number is
needed for data elements, such as the NAICS code, which may have more than one value. The sequence
number should be assigned the value " 1" for the first occurrence of the sequenced data element for the
EPA ID and should then be incremented by one with each successive occurrence of that same EPA ID.
4.3.5 Negative Numbers
Negative numbers are not allowed in the data submission.
4.4 Indicating Don't Know (DK) and Not Applicable (NA)
The 2003 Hazardous Waste Report, Instructions and Forms document does not allow the use of "Don't
Know" (DK) or "Not Applicable" (NA). Flat files cannot contain any values indicating "Don't Know" or
"Not Applicable."
4.5 Record Termination
Each flat file record must be terminated by a line feed character (ASCII Hex OxOA or ASCII Decimal
010), or a carriage return character (ASCII Hex OxOD or ASCII Decimal 013) followed by a line feed
character.
4.6 Empty Fields
For fields that require no response, the field should be filled with the space character (i.e., blanks).
4.7 Flat File Hierarchy
Appendix E shows the flat file hierarchy for the Hazardous Waste Report data submission. Files
connected by lines have a parent-child relationship. The file identified at the left terminus of a line is the
parent. The file identified at the right terminus of a line is the child. Each record with a unique EPA ID
in a child flat file must have at least one corresponding record in the parent flat file. When a parent flat
file distinguishes records using more than one key, it is the combination of the keys that identifies
uniqueness. For example, the "GM" series flat files use two keys (Handler ID and GM Page Number) to
identify each "waste" being reported for a site. Thus, for each unique occurrence of the combined keys
(Handler ID and GM Page Number) in the GM2 flat file, there must be a corresponding record in the
GM1 file with the same values for the entire key.
4.8 Confidential Business Information (CBI)
Under existing RCRA statutes, sites may claim that certain items of information submitted as part of their
Hazardous Waste Report contain Confidential Business Information (CBI). The procedures for handling
CBI can be found in Procedures for Handling RCRA Confidential Business Information (available from
the EPA HQ RCRA Document Control Officer). A subset of these procedures is documented in
Procedures for Handling RCRA Confidential Business Information Submitted for the Biennial Report.
(Copies of these documents can be requested from the RCRAInfo help desk at rcrainfo ,help@epa. gov).
In brief, it is not allowable to mingle CBI data with non-CBI data. In addition, CBI data must be handled
on a secure computer (either a computer that is kept in a secure environment or a computer that uses
November 2003
16
File Specification Guide
-------
removable media where the media is kept in a secure environment). CBI data must be submitted
separately from non-CBI data using data handling methods outlined in the Procedures for Handling
RCRA Confidential Business Information documentation.
In previous Biennial Report cycles, some States/Regions that have received CBI have masked the CBI
data (in other words, changed the CBI data so it no longer is CBI). This practice is not a requirement of
EPA HQ, but as long as the masking is acceptable to the site and the implementer, and the data meets the
minimum edit standards as detailed in the appendices, this solution is acceptable.
November 2003
17
File Specification Guide
-------
APPENDIX A
Required Data Elements
-------
APPENDIX A - Required Data Elements
For the purposes of this document, "required" refers to data elements that must be provided that cannot
have a value of blank.
Required Fields for Flat File SI1
Field Name
Description
Form
Location
HANDLERID
EPA Identification Number
SI-2
SUBMITT ALREASON
Reason for Submittal
SI-1
NAME
Name
SI-3
LOCATIONSTREET1
Location Street 1
SI-4
LOCATIONCITY
Location City
SI-4
COUNTYNAME
County Name
SI-4
LOCATIONSTATE
Location State
SI-4
LO C ATIONZIP
Location Zip Code
SI-4
MAILSTREET1
Mailing Street 1
SI-7
MAILCITY
Mailing City
SI-7
MAILSTATE*
Mailing State
SI-7
MAILZIP
Mailing Zip Code
SI-7
LANDTYPE
Site Land Type
SI-5
CONTACTFIRSTNAME
Contact First Name
SI-8
CONTACTLASTNAME
Contact Last Name
SI-8
CONTACTPHONE
Contact Phone Number
SI-8
ST ATEGENERATORST ATU S
State Specific Generator Status
GENERATORACTIVITY
Generator Activity
SI-10-A-1
IMPORTERACTIVITY
U.S. Importer of Hazardous Waste
SI-10-A-1
MIXEDWASTEGENERATOR
Mixed Waste (hazardous and radioactive)
Generator
SI-10-A-1
TRAN SPORTERACTIVITY
Transporter of Hazardous Waste
SI-10-A-2
TSDACTIVITY
Treater, Storer, or Disposer of Hazardous
Waste
SI-10-A-3
RECY CLERACTIVITY
Recycler of Hazardous Waste
SI-10-A-4
H WFUELON SITEBURNEREXEMPT
Small Quantity On-Site Burner Exemption
SI-10-A-5
November 2003
A-1
File Specification Guide
-------
Fill 1) N Wll.
1)1.S( kll'l |<»N
Fokm
l.<>< \ll<>\
HWFUELFURNACEEXEMPT
Smelting, Melting, Refining Furnace
Exemption
SI-10-A-5
UNDERGROUNDINJECTIONACTIVITY
Underground Injection Control
SI-10-A-6
INCLUDEINNATIONALREPORT
Include this Information in the National
Hazardous Waste Report
* Required if MAILCOUNTRY is blank or MAILCOUNTRY = 'UNITED STATES'.
Required Fields for Flat File SI2
Field Name
DKSC RII'TION
Form
Location
HANDLERID
EPA Identification Number
SI-2
GENBATTERIES
Large Quantity Generator of Batteries
SI-10-B-1-A
ACCBATTERIES
Large Quantity Accumulator of Batteries
SI-10-B-1-A
GENPESTICIDES
Large Quantity Generator of Pesticides
SI-10-B-1-B
ACCPESTICIDES
Large Quantity Accumulator of Pesticides
SI-10-B-1-B
GENTHERMOSTATS
Large Quantity Generator of Thermostats
SI-10-B -1-C
ACCTHERMOSTATS
Large Quantity Accumulator of Thermostats
SI-10-B-1-C
GENLAMPS
Large Quantity Generator of Lamps
SI-10-B-1-D
ACCLAMPS
Large Quantity Accumulator of Lamps
SI-10-B-1-D
UNI VERS ALWASTEDESTFACILITY
Destination Facility for Universal Waste
SI-10-B-2
U SEDOILTRAN SPORTER
Used Oil Transporter
SI-10-C-1-A
U SEDOILTRAN SFERF ACILITY
Used Oil Transfer Facility
SI-10-C-1-B
U SEDOILPROCES SOR
Used Oil Processor
SI-10-C-2-A
USEDOILREFINER
Used Oil Refiner
SI-10-C-2-B
U SEDOILBURNER
Off-Specification Used Oil Burner
SI-10-C-3
U SEDOILMARKETBURNER
Used Oil Fuel Marketer Who Directs
Shipment of Off-Specification Used Oil to
Off-Specification Used Oil Burner
SI-10-C-4-A
U SEDOILSPECMARKETER
Used Oil Fuel Marketer Who First Claims
the Used Oil Meets the Specifications
SI-10-C-4-B
November 2003
A-2
File Specification Guide
-------
Required Fields for Flat File SI6
Field Namk
DESCRIPTION
Form
Location
HANDLERJD
EPA Identification Number
SI-2
NAICSSEQ
NAICS Sequence Number
NAICSCODE
North American Industry Classification System
Code
SI-6
Required Fields for Flat File SI7
Field Namk
Description
Form
Location
HANDLERJD
EPA Identification Number
SI-2
CERTSEQ
Certification Sequence Number
CERTFIRSTNAME
Certification First Name
SI-13
CERTLASTNAME
Certification Last Name
SI-13
CERTTITLE
Certification Title
SI-13
CERTSIGNEDDATE
Date Certification Was Signed
SI-13
Required Fields for Flat File SI9
Note: Information must be provided for both Current Owner and Current Operator
Field Name
Description
Form
Location
HANDLERJD
EPA Identification Number
SI-2
OWNER OPERATOR SEQ NO
Owner/Operator Sequence Number
OWNER OPERATOR INDICATOR
Owner/Operator Indicator
OWNEROPERATORNAME
Site's Legal Owner/Operator
SI-9-A, SI-9-B
OWNEROPERATORDATE
Date Became Owner/Operator
SI-9-A, SI-9-B
OWNEROPERATORTYPE
Owner/Operator Type
SI-9-A, SI-9-B
November 2003
A-3
File Specification Guide
-------
Required Fields for Flat File GM1
Field Namk
DESCRIPTION
Form
Location
HANDLERJD
EPA Identification Number
SI-2
HZPG
Page Number
UNITOF MEASURE
Unit of Measure
GM-l-G
WSTDENSITY*
Density
GM-l-G
DENSITY UNIT OF MEASURE*
Density Unit of Measure
GM-l-G
ORIGIN MANAGEMENT METHOD * *
Origin management method for source code
G25
GM-l-D
SOURCECODE
Source Code
GM-l-D
GENQTY
Quantity Generated in Reporting Year
GM-l-F
INCLUDEINNATIONALREPORT
Include Information in the National Hazardous
Waste Report
ONSITEMANAGEMENT
Was any of this waste managed on-site during
2003
GM-2
OFFSITESHIPMENT
Was any of this waste shipped off-site in 2003
for treatment, disposal, or recycling
GM-3-A
* Required only if the unit of measure = 5 (gallons), 6 (liters), or 7 (cubic yards).
** Required only if the source code is G25.
Required Fields for Flat File GM2 or GM3
Field Namk
DESC RIl'ITON
Form Lot ation
HANDLERID
EPA Identification Number
SI-2
HZPG
Page Number
WASTECODE
EPA/State Hazardous Waste Code
GM-l-B / GM-l-C
* For each waste stream, either EPA Hazardous Waste Code information must be provided (GM2) or State
Hazardous Waste Code information must be provided (GM3).
November 2003
A-4
File Specification Guide
-------
Required Fields for Flat File GM4
Field Namk
DESCRIPTION
Form
Location
HANDLERJD
EPA Identification Number
SI-2
HZPG
Page Number
IO PG NUM SEQ
Off-site Sequence Number
GM-3 Site#
Block
IOJDRJD
EPA ID Number of the Off-Site Facility
Shipped To
GM-3-B
IOTDRQTY
Total Quantity Shipped to EPA ID in Current
Reporting Year
GM-3-D
* If the off-site shipment indicator in GM1 is equal to 'Y' then Off-site Shipment information (GM4) must be
provided.
Required Fields for Flat File GM5*
Field Namk
Description
Form
Location
HANDLERJD
EPA Identification Number
SI-2
HZPG
Page Number
S Y S PG NUM SEQ
On-Site Sequence Number
GM-2 System#
Block
MANAGEMENT _METHOD
On-Site Management Method
GM-2
SYS TDR QTY
Quantity Treated, Disposed, or Recycled On-
site in Current Reporting Year
GM-2
*If the on-site management indicator in GM1 is equal to 'Y' then On-Site Management information (GM5) must be
provided.
November 2003
A-5
File Specification Guide
-------
Required Fields for Flat File WR1
Field Namk
Description
Form
Location
HANDLERJD
EPA Identification Number
SI-2
HZPG
Page Number
SUBPGNUM
Waste Number
UNITOF MEASURE
Unit of Measure
WR-F
WSTDENSITY*
Density
WR-F
DENSITY UNIT OF MEASURE*
Density Unit of Measure
WR-F
MANAGEMENTMETHOD
Management Method
WR-H
IOTDRID
Off-site Source EPA ID Number
WR-D
IOTDRQTY
Quantity Received in Current Reporting Year
WR-E
INCLUDEINNATIONALREPORT
Include Information in the National Hazardous
Waste Report
* Required only if the unit of measure = 5 (gallons), 6 (liters), or 7 (cubic yards).
Required Fields for Flat File WR2 or WR3
Field Namk
Description
Form
Location
HANDLERID
EPA Identification Number
SI-2
HZPG
Page Number
SUBPGNUM
Waste Number
WASTECODE
EPA/State Hazardous Waste Code
WR-B / WR-C
* For each waste stream, either EPA Hazardous Waste Code information must be provided (WR2) or State
Hazardous Waste Code information must be provided (WR3).
November 2003
A-6
File Specification Guide
-------
APPENDIX B
Flat File Specifications
-------
APPENDIX B - Flat File Specifications
B.l Key For Flat File Tables
Data Type
A Alphanumeric
I Integer
D Fixed Decimal
B.2 Flat File Naming Convention
Flat files names are constructed in the following manner:
SSFFFNNN.FIL
Where:
SS = State Postal Code
FFF = Flat file identifier (for example, GM1 or GM2)
NNN = Julian Date when file was created
Files must be named using all uppercase characters.
Note: The three-character file ID distinguishes each flat file produced during the translation. For
example, the correct name for the SI3 file, containing VA data, produced on January 4th, is
VASI3004.FIL.
November 2003
B-1
File Specification Guide
-------
B.3 Flat Files
FLAT FILE ID# -CTL
Source Form:
NA
Description: Name and statistical information for each flat file being submitted
This file is used to describe the flat files being submitted electronically. There must be one record in the control file for each flat file being submitted.
Each CTL record contains a flat file name (field 1), the date the flat file was created in "CCYYMMDD" format (field 2), and the number of records
(lines) in the flat file (field 3).
When creating the Control File, first list records SI1-SI9, followed by GM1-GM5, followed by WR1-WR3. The control file must never contain entries
for file Oil. Only create control records for files that contain one or more records.
File name must be in uppercase characters in the following format: SSCTLNNN.FIL where SS = State Postal Code and NNN = Julian Date when file
was created.
Field
Number
Starting
Column
Field
Length
Data
Type
Description
Edit Number
1
1
12
A
File Name
CL000, CL010, CL020,
CL030
2
13
8
I
Date Created
(Format = CCYYMMDD)
CL040
3
21
8
I
Record Count
CL050
4
29
4
I
BR Reporting Cycle Year (2003)
CL060
Total Record Length:
32
November 2003
B-2
File Specification Guide
-------
FLAT FILE ID# -SI 1
Source Form: Site ID Description: Handler Identification, Address, and Hazardous Waste Activities Information
This file must contain one and only one record for each Handler ID reporting. Also, any Handler ID appearing as the key in ANY of the "GM", "WR", or "01" files must also
be present in this file.
Key Fields: Handler ID Number (HANDLERID). Each record in the SI1 file must contain a unique Handler ID Number.
Note: The SI1 file is REQUIRED. One record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data
Type
Deseription
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI000,
SI005
2
SUBMITTALREASON
13
1
A
Reason for Submittal
(As a component of the Hazardous Waste Report = 'R', As a
component of the Hazardous Waste Report AND any other
reason for submittal = 'B')
SI-1
SI015
3
NAME
14
40
A
Name
SI-3
SI020
4
LOCATIONSTREETNO
54
12
A
Location Street Number
SI-4
5
LOCATIONSTREET1
66
30
A
Location Street 1
SI-4
SI040
6
LOCATIONSTREET2
96
30
A
Location Street 2
SI-4
7
LOCATIONCITY
126
25
A
Location City
SI-4
SI050
8
COUNTYNAME
151
25
A
County Name
SI-4
SI060
9
LOCATIONSTATE
176
2
A
Location State
SI-4
SI070,
SI090
10
LO C ATIONZIP
178
14
A
Location Zip Code
SI-4
SI080,
SI085
11
MAILSTREETNO
192
12
A
Mailing Street Number
SI-7
12
MAILSTREET1
204
30
A
Mailing Street 1
SI-7
SHOO
13
MAILSTREET2
234
30
A
Mailing Street 2
SI-7
November 2003
B-3
File Specification Guide
-------
FLAT FILE ID# -SI 1
Source Form: Site ID Description: Handler Identification, Address, and Hazardous Waste Activities Information
This file must contain one and only one record for each Handler ID reporting. Also, any Handler ID appearing as the key in ANY of the "GM", "WR", or "01" files must also
be present in this file.
Key Fields: Handler ID Number (HANDLERID). Each record in the SI1 file must contain a unique Handler ID Number.
Note: The SI1 file is REQUIRED. One record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data
Type
Deseription
Location
on Form
Edit
Number
14
MAILCITY
264
25
A
Mailing City
SI-7
SI110
15
MAILSTATE
289
2
A
Mailing State
SI-7
SI120
16
MAILCOUNTRY
291
50
A
Mailing Country Name
SI-7
SI140
17
MAILZIP
341
14
A
Mailing Zip Code
SI-7
SI130,
SI135
18
LANDTYPE
355
1
A
Site Land Type
(Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian
= 'I', Municipal = 'M', State = 'S', Other = 'O', Unchecked = '')
SI-5
SI310
19
CONTACTFIRSTNAME
356
15
A
Contact First Name
SI-8
SI150
20
CONTACT MIDDLE INITIAL
371
1
A
Contact Middle Initial
SI-8
21
CONTACTLASTNAME
372
15
A
Contact Last Name
SI-8
SI160
22
CONTACTPHONE
387
10
A
Contact Phone Number
SI-8
SI170
23
CONTACTPHONEEXT
397
6
A
Contact Phone Number Extension
SI-8
24
STATEGENERATORST ATU S
403
1
A
State Specific Generator Status
SI-10-A-1
SI175
25
GENERATORACTIVITY
404
1
A
Generator Activity
(LQG = '1', SQG = '2', CESQG = '3', Not a generator = 'N')
SI-10-A-1
SI 180
26
IMPORTERACTIVITY
405
1
A
U.S. Importer of Hazardous Waste
(Yes = Y', No = 'N')
SI-10-A-1
SI460
November 2003
B-4
File Specification Guide
-------
FLAT FILE ID# -SI 1
Source Form: Site ID Description:
Handler Identification, Address, and Hazardous Waste Activities Information
This file must contain one and only one record for each Handler ID reporting. Also, any Handler ID appearing as the key in ANY of the "GM", "WR",
be present in this file.
or "OI" files must also
Key Fields: Handler ID Number (HANDLERID). Each record in the SI1 file must contain a unique Handler ID Number.
Note: The SI1 file is REQUIRED. One record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data
Type
Description
Location
on Form
Edit
Number
27
MIXEDWASTEGENERATOR
406
1
A
Mixed Waste (hazardous and radioactive) Generator
(Yes = Y', No = 'N')
SI-10-A-1
SI470
28
TRAN SPORTERACTIVITY
407
1
A
Transporter of Hazardous Waste
(Yes = Y', No = 'N')
SI-10-A-2
SI480
29
TSDACTIVITY
408
1
A
Treater, Storer, or Disposer of Hazardous Waste
(Yes = Y', No = 'N')
SI-10-A-3
SI 190
30
RECY CLERACTIVITY
409
1
A
Recycler of Hazardous Waste
(Yes = Y', No = 'N')
SI-10-A-4
SI490
31
HWFUEL_ONSITE_BURNER_EXEMPT
410
1
A
Small Quantity On-Site Burner Exemption
(Yes = Y', No = 'N')
SI-10-A-5
SI500
32
HWFUELFURNACEEXEMPT
411
1
A
Smelting, Melting, Refining Furnace Exemption
(Yes = Y', No = 'N')
SI-10-A-5
SIS 10
33
UNDERGROUND INJECTION ACTIVITY
412
1
A
Underground Injection Control
(Yes = Y', No = 'N')
SI-10-A-6
SI520
34
INCLUDE JNJsTATIONAL_REPORT
413
1
A
Include this Information in the National Hazardous Waste
Report (Yes = Y', No = 'N')
SI999
35
NOTES
414
240
A
Comments/Notes
SI-12
36
CONT ACTEM AIL
654
240
A
Contact E-Mail Address
37
STATEDISTRICT
894
10
A
State District
Total Record Length:
903
November 2003
B-5
File Specification Guide
-------
FLAT FILE ID# - SI2
Source Form: Site ID Description:
Handler Universal Waste and Used Oil Activities
This file captures the information contained in Section 10, Block B, Questions 1A - ID of the Site ID form. This file should contain one and only one record for each Handler ID
reporting.
Key Fields: Handler ID Number (HANDLERID). Each record in the SI2 file must contain a unique Handler ID Number.
Note: The SI2 file is REQUIRED. One record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data Tvpc
Description
Location on
Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI530
2
GENBATTERIES
13
1
A
Large Quantity Generator of Batteries
(Yes = 'Y', No = 'N')
SI-10-B-1-A
SI540
3
ACCBATTERIES
14
1
A
Large Quantity Accumulator of Batteries
(Yes = 'Y', No = 'N')
SI-10-B-1-A
SI550
4
GENPESTICIDES
15
1
A
Large Quantity Generator of Pesticides
(Yes = 'Y', No = 'N')
SI-10-B-1-B
SI560
5
ACCPESTICIDES
16
1
A
Large Quantity Accumulator of Pesticides
(Yes = 'Y', No = 'N')
SI-10-B-1-B
SI570
6
GENTHERMOSTATS
17
1
A
Large Quantity Generator of Thermostats
(Yes = 'Y', No = 'N')
SI-10-B-1-C
SI580
7
ACCTHERMOSTATS
18
1
A
Large Quantity Accumulator of Thermostats
(Yes = 'Y', No = 'N')
SI-10-B-1-C
SI590
8
GENLAMPS
19
1
A
Large Quantity Generator of Lamps
(Yes = 'Y', No = 'N')
SI-10-B-1-D
SI600
9
ACCLAMPS
20
1
A
Large Quantity Accumulator of Lamps
(Yes = 'Y', No = 'N')
SI-10-B-1-D
SI610
10
UNI VERS ALWASTEDESTFACILITY
21
1
A
Destination Facility for Universal Waste
(Yes = 'Y', No = 'N')
SI-10-B-2
SI620
November 2003
B-6
File Specification Guide
-------
FLAT FILE ID#-SI2
Source Form: Site ID Description:
Handler Universal Waste and Used Oil Activities
This file captures the information contained in Section 10, Block B, Questions 1A - ID of the Site ID form. This file should contain one and only one record for each Handler ID
reporting.
Key Fields: Handler ID Number (HANDLERID). Each record in the SI2 file must contain a unique Handler ID Number.
Note: The SI2 file is REQUIRED. One record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location on
Form
Edit
Number
11
U SEDOILTRAN SPORTER
22
1
A
Used Oil Transporter
(Yes = 'Y', No = 'N')
SI-10-C-1-A
SI630
12
U SED_OIL_TRAN SFER_F ACILIT Y
23
1
A
Used Oil Transfer Facility
(Yes = 'Y', No = 'N')
SI-10-C-1-B
SI640
13
U SEDOILPROCES SOR
24
1
A
Used Oil Processor
(Yes = 'Y', No = 'N')
SI-10-C-2-A
SI650
14
USEDOILREFINER
25
1
A
Used Oil Re-refiner
(Yes = 'Y', No = 'N')
SI-10-C-2-B
SI660
15
USEDOILBURNER
26
1
A
Off-Specification Used Oil Burner
(Yes = 'Y', No = 'N')
SI-10-C-3
SI670
16
U SEDOILMARKETBURNER
27
1
A
Used Oil Fuel Marketer Who Directs Shipment of Off-
Specification Used Oil to Off-Specification Used Oil Burner
(Yes = 'Y', No = 'N')
SI-10-C-4-A
SI680
17
U SEDOILSPECMARKETER
28
1
A
Used Oil Fuel Marketer Who First Claims the Used Oil Meets
the Specifications
(Yes = 'Y', No = 'N')
SI-10-C-4-B
SI690
Total Record Length:
28
November 2003
B-7
File Specification Guide
-------
FLAT FILE ID# - SI3
Source Form: Site ID Description:
Handler Other Universal Waste Activities
This file captures the information contained in Section 10, Block B, Question IE of the Site ID form. The relationship of these data records to the reported site is n: 1, that is,
there can be multiple other waste activities for each site.
Key Fields: Handler ID Number (HANDLERID); Other Universal Waste Activities (UNIVERSAL WASTE). Each record in the SI3 file must contain a unique combination
of the Handler ID Number and Other Universal Waste Activities.
Note: The SI3 file is NOT REQUIRED. The edits for this file apply only if you provide data for this file.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location on
Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI700
2
UNIVERSALWASTE
13
1
A
Other Universal Waste Activities
SI-10-B-1-E
SI720
3
GENERATED
14
1
A
Generated Other Universal Waste Activities
(Yes = 'Y', No = 'N')
SI-10-B-1-E
SI730, SI750
4
ACCUMULATED
15
1
A
Accumulated Other Universal Waste Activities
(Yes = Y', No = 'N')
SI-10-B-1-E
SI740, SI750
Total Record Length:
15
November 2003
B-8
File Specification Guide
-------
FLAT FILE ID# - SI4
Source Form: Site ID Description:
Waste Codes for Federally Regulated Hazardous Wastes
This file captures the information contained in Section 11, Block A of the Site ID form. The relationship of these data records to the reported site is n : 1, that is, there can be
multiple federal waste codes for each site.
Key Fields: Handler ID Number (HANDLER ID); Federal Waste Code (EPA WASTE CODE). Each record in the SI4 file must contain a unique combination of the Handler
ID Number and Federal Waste Code.
Note: The SI4 file is NOT REQUIRED. The edits for this file apply only if you provide data for this file.
Field
Starting
Field
Location
Edit
No.
Field Name
Column
Length
Data Tvpe
Description
on Form
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI760
2
EPAWASTECODE
13
4
A
Waste Codes for Federally Regulated Hazardous Wastes
SI-11-A
SI780
Total Record Length:
16
November 2003
B-9
File Specification Guide
-------
FLAT FILE ID# - SI5
Source Form: Site ID Description:
Waste Codes for State-Regulated Hazardous Wastes
This file captures the information contained in Section 11, Block B of the Site ID form. The relationship of these data records to the reported site is «: 1. that is, there can be
multiple state waste codes for each site.
Key Fields: Handler ID Number (HANDLER ID); State Waste Code (STATE WASTE CODE). Each record in the SI5 file must contain a unique combination of the
Handler ID Number and State Waste Code.
Note: The SI5 file is NOT REQUIRED. The edits for this file apply only if you provide data for this file.
Field
Starting
Field
Location
Edit
No.
Field Name
Column
Length
Data Type
Description
on Form
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI790
2
STATEWASTECODE
13
6
A
Waste Code for State-Regulated Hazardous Waste
SI-ll-B
SI810
Total Record Length:
18
November 2003
B-10
File Specification Guide
-------
FLAT FILE ID# - SI6
Source Form: Site ID Description:
North American Industry Classification System Codes for the Site
This file captures the information contained in Section 6 of the Site ID form. The relationship of these data records to the reported site is n: l. that is, there can be multiple
NAICS for each site.
Key Fields: Handler ID Number (HANDLERID); NAICS Sequence Number (NAICSSEQ). Each record in the SI6 file must contain a unique combination of the Handler ID
Number and the NAICS Sequence Number.
Note: The SI6 file is REQUIRED. At least one record with a sequence number of 1 must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location on
Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI200,
SI230
2
NAICSSEQ
13
4
I
NAICS Sequence Number
Assigned by
Respondent
SI210,
SI235
3
NAICSCODE
17
6
A
North American Industry Classification System Code
SI-6
SI220
Total Record Length:
22
November 2003
B-11
File Specification Guide
-------
FLAT FILE ID# - SI7
Source Form: Site ID
Description:
Site Identification Form Certification
This file captures the information contained in Section 13 of the Site ID form. The relationship of these data records to the reported site is n: 1, that is, there can be multiple
certifications for each site.
Key Fields: Handler ID Number (HANDLERID); Certification Sequence Number (CERTSEQ). Each record in the SI7 file must contain a unique combination of the
Handler ID Number and Certification Sequence Number.
Note: The SI7 file is REQUIRED. At least one record must be provided for each handler.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI-2
SI240,
SI290
2
CERTSEQ
13
2
I
Certification Sequence Number
Assigned by
Respondent
SI250
3
CERTFIRSTNAME
15
15
A
Certification First Name
SI-13
SI265
4
CERTMIDDLEINITIAL
30
1
A
Certification Middle Initial
SI-13
5
CERTLASTNAME
31
15
A
Certification Last Name
SI-13
SI260
6
CERTTITLE
46
15
A
Certification Title
SI-13
SI270
7
CERTSIGNEDDATE
61
8
I
Date Certification was Signed (CCYYMMDD)
SI-13
SI280
Total Record Length:
68
November 2003
B-12
File Specification Guide
-------
FLAT FILE ID# - SI8
Source Form: NA Description: State Specific Activities
This file reports the state specific activities for each site. Although not on the EPA Form 8700-13A/B, this file is available for states who wish to report this information. The
relationship of these data records to the reported site is n : 1. that is, there can be multiple state specific activities for each site.
Key Fields: Handler ID Number (HANDLERID); State Activity Type (STATEACTIVITYTYPE). Each record in the SI8 file must contain a unique combination of the
Handler ID Number and State Activity Type.
Note: The SI8 file is NOT REQUIRED. The edits for this file apply only if you provide data for this file.
Field
No.
Field Name
Starting
Column
Field
Length
Data Tvpe
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI820
2
STATEACTIVITYTYPE
13
5
A
State Activity Type
SI830
3
NOTES
18
240
A
Notes/Comments
Total Record Length:
257
November 2003
B-13
File Specification Guide
-------
FLAT FILE ID# - SI9
Source Form: Site ID Description: Owner/Operator Name and Address
This file reports the owner and operator name and address for each site. The owner/operator name, date and type are on the EPA Form 8700-13A/B. The file specification
includes owner/operator address information for states who wish to report this information. The relationship of these data records to the reported site is n: 1, that is, there can be
multiple owner and operator names and addresses for each site.
Key Fields: Handler ID Number (HANDLERID); Owner/Operator Sequence Number (OWNEROPERATORSEQNO). Each record in the SI9 file must contain a unique
combination of the Handler ID Number and Owner/Operator Sequence Number.
Note: The SI9 file is REQUIRED . At least two records must be provided for each handler - one record for current owner and one record for current operator.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA Identification Number
SI840
2
OWNEROPERATORSEQNO
13
4
I
Owner/Operator Sequence Number
3
OWNER_OPERATOR_INDICATOR
17
2
A
Owner/Operator Indicator
(Current Owner = 'CO', Current Operator = 'CP')
SI910,
SI920
4
OWNEROPERATORNAME
19
40
A
Site's Legal Owner/Operator
SI-9-A,
SI-9-B
SI440
5
OWNEROPERATORDATE
59
8
I
Date Became Owner/Operator (CCYYMMDD)
SI-9-A,
SI-9-B
SI420
6
OWNEROPERATORTYPE
67
1
A
Owner/Operator Type
(Private = 'P', County = 'C', District = 'D', Federal = 'F', Indian =
'I', Municipal = 'M', State = 'S', Other = 'O')
SI-9-A,
SI-9-B
SI430
7
OWNER_OPERATOR_STREET_NO
68
12
A
Owner/Operator Street Number
SI-9-A
8
OWNEROPERATORSTREET1
80
30
A
Owner/Operator Street 1
SI-9-A
9
OWNEROPERATORSTREET2
110
30
A
Owner/Operator Street 2
SI-9-A
10
OWNEROPERATORCITY
140
25
A
Owner/Operator City
SI-9-A
11
0 WNEROPERATORST ATE
165
2
A
Owner/Operator State
SI-9-A
SI850
November 2003
B-14
File Specification Guide
-------
FLAT FILE ID#-SI9
Source Form: Site ID Description: Owner/Operator Name and Address
This file reports the owner and operator name and address for each site. The owner/operator name, date and type are on the EPA Form 8700-13A/B. The file specification
includes owner/operator address information for states who wish to report this information. The relationship of these data records to the reported site is n: 1, that is, there can be
multiple owner and operator names and addresses for each site.
Key Fields: Handler ID Number (HANDLERID); Owner/Operator Sequence Number (OWNEROPERATORSEQNO). Each record in the SI9 file must contain a unique
combination of the Handler ID Number and Owner/Operator Sequence Number.
Note: The SI9 file is REQUIRED . At least two records must be provided for each handler - one record for current owner and one record for current operator.
Field
No.
Field Name
Starting
Column
Field
Length
Data Tvpe
Description
Location
on Form
Edit
Number
12
OWNEROPERATORZIP
167
14
A
Owner/Operator Zip Code
SI-9-A
SI870
13
OWNER_OPERATOR_COUNTRY
181
50
A
Owner/Operator Country
SI-9-A
SI890
14
OWNEROPERATORNOTES
231
240
A
Owner/Operator Notes
Total Record Length:
470
November 2003
B-15
File Specification Guide
-------
FLAT FILE ID#-GM1
Source Form: GM Description: Waste Measurement Information
This file captures data elements that have a 1:1 relationship to the reported waste. These data elements are as follows: GM Section 1, Block A and Blocks D through G.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG). Each record in the GM1 file must contain a unique combination of the Handler ID Number and
Page Number.
Note: The GM1 File is REQUIRED for handlers that generated RCRA hazardous waste that, in 2003, was accumulated on-site; managed on-site in a treatment, storage, or
disposal unit; and / or shipped off-site for management.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Loeation
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID
Block
GM000
2
HZPG
13
5
I
Page Number
Assigned By
Respondent
GM010
3
FORMCODE
18
4
A
Waste Form Code
GM-l-E
GM220
4
UNIT OF MEASURE
22
1
A
Unit of Measure
(Pounds = '1', Short Tons = '2', Kilograms = '3', Metric
Tonnes = '4', Gallons = '5', Liters = '6', Cubic Yards = '7')
GM-l-G
GM020
5
WSTDENSITY
23
6
D3.2
Density
GM-l-G
GM030,
GM040
6
DEN SITYUNITOFME ASURE
29
1
A
Density Unit of Measure
(lbs/gal = '1', sg = '2')
GM-l-G
GM030
7
ORIGINMANAGEMENTMETHOD
30
4
A
Origin management method for source code G25
GM-l-D
GM230
***OBSOLETE FIELD***
34
1
A
Obsolete Field - must leave blank (formerly RCRA-
Radioactive Mix)
8
SOURCECODE
35
3
A
Source Code
GM-l-D
GM270
9
GENQTY
38
18
D11.6
Quantity Generated in Reporting Year
GM-l-F
GM050
November 2003
B-16
File Specification Guide
-------
FLAT FILE ID#-GM1
Source Form: GM Description:
Waste Measurement Information
This file captures data elements that have a 1:1 relationship to the reported waste. These data elements are as follows: GM Section I, Block A and Blocks D through G.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZ PG). Each record in the GM1 file must contain a unique combination of the Handler ID Number and
Page Number.
Note: The GM1 File is REQUIRED for handlers that generated RCRA hazardous waste that, in 2003, was accumulated on-site; managed on-site in a treatment, storage, or
disposal unit; and / or shipped off-site for management.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
10
INCLUDE IN NATIONAL REPORT
56
1
A
Include Information in the National Hazardous Waste
Report
(Yes = 'Y', No = 'N')
GM310
11
DESCRIPTION
57
240
A
Waste Stream Description
GM-l-A
12
NOTES
297
240
A
Comments/Notes
Bottom of
GMForm
13
ON SITE MANAGEMENT
537
1
A
Was this Waste Stream Managed On-Site
(Yes = 'Y', No = 'N')
GM-2
GM320,
GM330,
GM335
14
OFFSITESHIPMENT
538
1
A
Was this Waste Stream Shipped Off-Site
(Yes = 'Y\ No = 'N')
GM-3-A
GM340,
GM350,
GM355
Total Record Length:
538
November 2003
B-17
File Specification Guide
-------
FLAT FILE ID#-GM2
Source Form: GM Description: EPA Hazardous Waste Codes for each GM page
This file captures the information contained in Section 1, Block B of the GM form. The relationship of these data records to the reported waste is n : 1. that is, there can be
multiple EPA waste codes for each unique reported waste.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG); EPA Hazardous Waste Code (EPAWASTECODE). Each record in the GM2 file must contain
a unique combination of the Handler ID Number, Page Number, and EPA Hazardous Waste Code.
Note: For each waste stream, either EPA Hazardous Waste Code information (GM2) is REQUIRED or State Hazardous Waste Code information (GM3) is REQUIRED.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID Block
GM060,
GM100
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
3
EPAWASTECODE
18
4
A
EPA Hazardous Waste Code
GM-l-B
GM090
Total Record Length:
21
November 2003
B-18
File Specification Guide
-------
FLAT FILE ID#-GM3
Source Form: GM Description:
State Hazardous Waste Codes for each GM page
This file captures the information contained in Section 1, Block C of the GM form. The relationship of these data records to the reported waste is n : l. that is, there can be
multiple State waste codes for each unique reported waste.
Key Fields: Handler ID Number (HANDLER ID); Page Number (HZ PG); State Hazardous Waste Code (WASTE CODE). Each record in the GM3 file must contain a
unique combination of the Handler ID Number, Page Number, and State Hazardous Waste Code.
Note: For each waste stream, either EPA Hazardous Waste Code information (GM2) is REQUIRED or State Hazardous Waste Code information (GM3) is REQUIRED.
Field
Starting
Field
Location
Edit
No.
Field Name
Column
Length
Data Type
Description
on Form
Number
Site ID
1
HANDLERID
1
12
A
EPA ID Number
Block
GM280
Assigned by
2
HZPG
13
5
I
Page Number
respondent
3
WASTECODE
18
6
A
State Hazardous Waste Code
GM-l-C
GM300
Total Record Length:
23
November 2003
B-19
File Specification Guide
-------
FLAT FILE ID#-GM4
Source Form: GM Description:
Off-Site Management Information for the Reported Waste on Each GM Page
This file captures off-site treatment information for the reported waste as represented in GM Section 3, Blocks B through D. The relationship of these data records to the
reported waste is n: 1, that is, there can be multiple off-site information for each unique reported waste.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG); Off-site Sequence Number (IOPGNUMSEQ). Each record in the GM4 file must contain a
unique combination of the Handler ID Number, Page Number, and Off-site Sequence Number.
Note: The GM4 File is REQ UIRED for handlers that generated RCRA hazardous waste that, in 2003, was shipped off-site for management.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID
Block
GM110
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
3
IOPGNUMSEQ
18
5
I
Off-site Sequence Number
GM-3 Site#
Block
GM120
4
MANAGEMENTMETHOD
23
4
A
Off-site Management Method
GM-3-C
GM160
5
IOTDRID
27
12
A
EPA ID No. of Off-site Facility Shipped to
GM-3-B
GM140
6
IOTDRQTY
39
18
D11.6
Total Quantity Shipped to EPA ID in Field 5 in Current
Reporting Year
GM-3-D
GM150
Total Record Length:
56
November 2003
B-20
File Specification Guide
-------
FLAT FILE ID#-GM5
Source Form: GM Description: On-site Management Information for the Reported Waste on Each GM Page.
This file captures on-site treatment information as contained in Section 2 of the GM form. The relationship of the data element to the reported waste is rr.\. that is, there can be
multiple on-site information for each unique reported waste.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG); On-site Sequence Number (SYSPGNUMSEQ). Each record in the GM5 file must contain a
unique combination of the Handler ID Number, Page Number, and On-site Sequence Number.
Note: The GM5 File is REQUIRED for handlers that generated RCRA hazardous waste that, in 2003, was accumulated on-site or managed on-site in a treatment, storage, or
disposal unit.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID Block
GM170
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
3
S Y SPGNUMSEQ
18
5
I
On-site Sequence Number
GM-2
System#
Block
GM180
4
MANAGEMENT METHOD
23
4
A
On-site Management Method
GM-2
GM210
5
SYSTDRQTY
27
18
D11.6
Quantity Treated, Disposed, or Recycled On-site in
Current Reporting Year
GM-2
GM190
Total Record Length:
44
November 2003
B-21
File Specification Guide
-------
FLAT FILE ID# -WR1
Source Form: WR Description: Received Waste Description and Measurement Information
This file captures the information contained in Block A and Blocks D through H of the WR form. The relationship of these data records to the reported site is n: 1. that is, there
can be multiple received waste for each site.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG); Waste Number (SUBPGNUM). Each record in the WR1 file must contain a unique combination
of Handler ID Number, Page Number, and Waste Number.
Note: The WR1 is REQUIRED for handlers who, during 2003, received RCRA hazardous waste from off-site.
Field
No.
Field Name
Starting
Column
Field
Length
Data Tvpe
Description
Loeation
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID
Block
WR000
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
WR010
3
SUBPGNUM
18
1
I
Waste Number
Printed on
Form
WR020
4
FORMCODE
19
4
A
Form Code
WR-G
WR180
5
UNIT OF MEASURE
23
1
A
Unit of Measure
(Pounds = '1', Short Tons = '2', Kilograms = '3', Metric
Tonnes = '4', Gallons = '5', Liters = '6', Cubic Yards = '7')
WR-F
WR030
6
WSTDENSITY
24
6
D3.2
Density
WR-F
WR040,
WR050
7
DEN SIT Y_UNIT_OF_MEA SURE
30
1
A
Density Unit of Measure
(lbs/gal = T, sg = '2')
WR-F
WR040
***OBSOLETE FIELD***
31
1
A
Obsolete Field - must leave blank (formerly RCRA-
Radioactive Mix)
8
MANAGEMENTMETHOD
32
4
A
Management Method
WR-H
WR060
9
IOTDRID
36
12
A
Off-site Source EPA ID Number
WR-D
WR070
November 2003
B-22
File Specification Guide
-------
FLAT FILE ID# -WR1
Source Form: WR Description:
Received Waste Description and Measurement Information
This file captures the information contained in Block A and Blocks D through H of the WR form. The relationship of these data records to the reported site is «: 1. that is, there
can be multiple received waste for each site.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZ PG); Waste Number (SUBPGNUM). Each record in the WR1 file must contain a unique combination
of Handler ID Number, Page Number, and Waste Number.
Note: The WR1 is REQUIRED for handlers who, during 2003, received RCRA hazardous waste from off-site.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
10
IOTDRQTY
48
18
D11.6
Quantity Received in Current Reporting Year
WR-E
WR080
11
INCLUDE_IN_NATIONAL_REPORT
66
1
A
Include Information in the National Hazardous Waste Report
(Yes = 'Y', No = 'N')
WR230
12
DESCRIPTION
67
240
A
Waste Stream Description
WR-A
13
NOTES
307
240
A
Comments/Notes
Bottom of
WR Form
Total Record Length:
546
November 2003
B-23
File Specification Guide
-------
FLAT FILE ID# -WR2
Source Form: WR Description: EPA Hazardous Waste Codes for Each Reported Waste Received
This file contains the EPA hazardous waste codes for each WR form page as described in Form WR, Block B. The relationship of these data records to the reported waste is n: 1,
that is, there can be multiple EPA waste codes for each unique reported waste.
Key Fields: Handler ID Number (H ANDLERID); Page Number (HZPG); Waste Number (SUB_PG_NUM); EPA Hazardous Waste Code (EPAWASTECODE). Each
record in the WR2 file must contain a unique combination of the Handler ID Number, Page Number, Waste Number, and EPA Hazardous Waste Code.
Note: For each waste stream, either EPA Hazardous Waste Code information (WR2) is REQUIRED or State Hazardous Waste Code information (WR3) is REQUIRED.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID
Block
WR090,
WR130
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
3
SUBPGNUM
18
1
I
Waste Number
Printed on
Form
WR020
4
EPAWASTECODE
19
4
A
EPA Hazardous Waste Code
WR-B
WR110
Total Record Length:
22
November 2003
B-24
File Specification Guide
-------
FLAT FILE ID#- WR3
Source Form: WR Description:
State Hazardous Waste Codes for Each Reported Waste Received
This file contains the State hazardous waste codes for each WR form page as described in Form WR, Block C. The relationship of these data records to the reported waste is n: 1,
that is, there can be multiple State waste codes for each unique reported waste.
Key Fields: Handler ID Number (HANDLERID); Page Number (HZPG); Waste Number (SUB PG NUM); State Hazardous Waste Code (WASTECODE). Each
record in the WR3 file must contain a unique combination of the Handler ID Number, Page Number, Waste Number, and State Hazardous Waste Code.
Note: For each waste stream, either EPA Hazardous Waste Code information (GM2)
is REQUIRED or State Hazardous Waste Code information (GM3) is REQUIRED.
Field
No.
Field Name
Starting
Column
Field
Length
Data Type
Description
Location
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID
Block
WR200
2
HZPG
13
5
I
Page Number
Assigned by
Respondent
3
SUBPGNUM
18
1
I
Waste Number
Printed on
Form
WR020
4
WASTECODE
19
6
A
State Hazardous Waste Code
WR-C
WR220
Total Record Length:
24
November 2003
B-25
File Specification Guide
-------
FLAT FILE ID#-Oil
Source Form: 01 Description: Identification of All Handlers to Whom or From Whom Waste was Shipped, and Transporters
This file captures information from the 01 form. This flat file should never be included in submissions to RCRAInfo.
Key Fields: Handler ID Number (HANDLERID); Page Number (OSITEPGNUM). Each record in the Oil file must contain a unique combination of EPA ID Number and
Page Number.
Field
No.
Field Name
Starting
Column
Field
Length
Data
Type
Description
Loeation
on Form
Edit
Number
1
HANDLERID
1
12
A
EPA ID Number
Site ID Block
2
OSITEPGNUM
13
5
I
Page Number
Assigned by
Respondent
3
OFFID
18
12
A
Off-site Installation or Transporter EPA ID Number
OI-A
4
W STGENFLG
30
1
A
Handler Type = Generator
(Checked = 'Y',
Unchecked and not implementer required = TJ', Unchecked
and implementer required = 'N')
OI-C
5
W STTRN SFLG
31
1
A
Handler Type= Transporter
(Checked = 'Y',
Unchecked and not implementer required = TJ', Unchecked
and implementer required = 'N')
OI-C
6
WSTTSDRFLG
32
1
A
Handler Type = TSDR
(Checked = 'Y',
Unchecked and not implementer required = TJ', Unchecked
and implementer required = 'N')
OI-C
7
ONAME
33
40
A
Name of Off-site Installation or Transporter
OI-B
8
01 STREET
73
30
A
1st Street Address Line of Installation or Transporter
OI-D
9
02 STREET
103
30
A
2nd Street Address Line of Installation or Transporter
OI-D
10
OCITY
133
25
A
City
OI-D
November 2003
B-26
File Specification Guide
-------
FLAT FILE ID#-Oil
Source Form: 01 Description:
Identification of All Handlers to Whom or From Whom Waste was Shipped, and Transporters
This file captures information from the 01 form. This flat file should never be included in submissions to RCRAInfo.
Key Fields: Handler ID Number (HANDLERID); Page Number (OSITEPGNUM). Each record in the Oil file must contain a unique combination of EPA ID Number and
Page Number.
Field
No.
Field Name
Starting
Column
Field
Length
Data
Type
Description
Location
on Form
Edit
Number
11
OSTATE
158
2
A
State
OI-D
12
OZIP
160
9
A
Zip Code
OI-D
13
NOTES
169
240
A
Comments/Notes
Bottom of 01
Form
Total Record Length:
408
November 2003
B-27
File Specification Guide
-------
APPENDIX C
Data Assessment Edits
-------
APPENDIX C - Data Assessment Edits
All data submitted must meet the appropriate data assessment edits. The data assessment edits for non-required data elements apply only if
the data is provided. For child table records, data assessment edits apply only if the record is being submitted.
C.l Generic Data Edits
Edit
Number
Form Location
Edit Description
Select Lojjic
GN000
All
A non-valid character was found in a character field.
CHARACTER = allowed value as specified in Section 4.3.1
GN010
All
Alphabetic character found in numeric field.
NUMERIC DIGIT = allowed value as specified in Section 4.3.2 or
Section 4.3.3
GN020
All
Duplicate records found in file submission.
Combination of key fields for specific file must be unique
November 2003
C-1
File Specification Guide
-------
C.2 Control File Edits
Edit
Number
Form Location
Edit Description
Select Lojjic
CL000
Control File
The first two characters of the file name must be a valid state
postal code (see Appendix F).
SUBSTR(FILE_NAME,1,2) = valid state postal code (see
Appendix F).
CL010
Control File
Flat files specified must be for the state for which data is being
submitted.
SUBSTR(FILE_NAME,1,2) = state postal code of submission
CL020
Control File
Characters 3-5 of the file name must be a valid flat file identifier
(SI1, SI2, SI3, SI4, SI5, SI6, SI7, SI8, SI9, GM1, GM2, GM3,
GM4, GM5, WR1, WR2, WR3).
SUBSTR(FILE NAME,3,3) = SI1 or SI2 or SI3 or SI4 or SI5 or
SI6 or SI7 or SI8 or SI9 or GM1 or GM2 or GM3 or GM4 or GM5
or WR1 or WR2 or WR3
CL030
Control File
Characters 6-8 must be greater than zero and less than or equal to
366.
SUBSTR(FILE_NAME,6,3) > 0 AND <= 366
CL040
Control File
The date created must be a valid date greater than 19000101
(January 1, 1900).
DATE CREATED = valid date
CL050
Control File
The record count must be greater than zero and less than or equal
to 99,999,999.
RECORDCOUNT > 0 AND <= 99999999
CL060
Control File
The report cycle must be '2003'.
REPORTCYCLE = '2003'
November 2003
C-2
File Specification Guide
-------
C.3 Site Identification Form Edits
Edit
Number
Form Location
Edit Description
Select Logic
SI000
SI-2
The first two characters of the EPA ID must match the state code
for which data is being submitted.
SUBSTR(HANDLER_ID,1,2) = state postal code of submission
SI005
SI-1 / SI-2
If the reason for submittal is for the Hazardous Waste Report, the
EPA ID must already exist in RCRAInfo.
IF SUBMITTAL REASON = 'R' THEN HANDLER ID in
HBASIC
SI015
SI-1
The reason for submittal must be 'R' or 'B'.
SUBMITTAL REASON = 'R' or 'B'
SI020
SI-3
Handler name must be provided.
HANDLER NAME <>''
SI040
SI-4
Location street must be provided.
LOCATION STREET l <>''
SI050
SI-4
Location city, town, or village must be provided.
LOCATION CITY <>''
SI060
SI-4
Location county name must be a valid value.
COUNTY NAME = county name provided in LU COUNTY
SI070
SI-4
Location state must be a valid postal state (see Appendix F)
LOCATIONSTATE = value specified in Appendix F.
SI080
SI-4
Location zip code must be provided.
LOCATIONZIP <>''
SI085
SI-7
Location zip code must contain only the characters 0, 1, 2, 3, 4, 5,
6, 7, 8, 9, or blank.
LOCATIONZIP characters = '0', '1', '2', '3', '4', '5', '6', 7', '8', '9',''
SI090
SI-4
The state indicated in the site location address must be the same
as the first two characters of the site's EPA ID.
LOCATIONSTATE = SUB STR(HANDLER_ID, 1,2)
SHOO
SI-7
Mailing street must be provided.
MAIL STREET1 <> ''
SI110
SI-7
Mailing city, town, or village must be provided.
MAIL CITY <>''
SI120
SI-7
If the mailing address is in the United States then the mailing
state must be a valid postal state (see Appendix F).
If MAILCOUNTRY = " OR MAILCOUNTRY = 'UNITED
STATES' Then MAIL STATE = value specified in Appendix F.
SI130
SI-7
Mailing zip code must be provided.
MAILZIP <>''
SI135
SI-7
Mailing zip code must contain only the characters 0, 1, 2, 3, 4, 5,
6, 7, 8, 9, or blank.
MAILZIP characters = '0', '1', '2', '3', '4', '5', '6', 7', '8', '9',''
November 2003
C-3
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
SI140
SI-7
Mailing country name must be a valid value. If the mailing
country is blank, a value of UNITED STATES will be assumed.
MAILCOUNTRY = country name provided in LUCOUNTRY
SI150
SI-8
Contact last name must be provided.
CONTACT LAST NAME <>''
SI160
SI-8
Contact first name must be provided.
CONTACT FIRST NAME <> ''
SI170
SI-9
Contact phone number must be provided.
CONTACT PHONE <>''
SI175
SI-10-A-1
State generator status must be registered with the RCRAInfo
database.
STATE GENERATOR STATUS = implementer defined value in
LUGENERATORSTATU S2
SI 180
SI-10-A-1
Generator of hazardous waste indicator must equal '1', '2', '3', or
'N'.
GENERATOR ACTIVITY = '1' or '2' or '3' or 'N'
SI 190
SI-10-A-3
Treater, Storer, or Disposer indicator must equal 'Y' or 'N'.
TSD ACTIVITY = Y' or 'N'
SI200
SI-2
SI6 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERID in SI1 file
SI210
SI- Assigned by
respondent
NAICS sequence number must be greater than zero.
NAICSSEQ > 0
SI220
SI-6
North American industry classification system code must be a
valid value.
NAICS CODE = NAICS code provided in LU_NAICS
SI230
SI-6
NAICS data must be provided.
HANDLER ID in SI1 file and in SI6 file
SI235
SI-6
One SI6 record with sequence number = 1 must be provided.
Record in SI6 where NAICS SEQ = 1
SI240
SI-2
SI7 record is present, but corresponding record does not exist in
the SI1 file.
HANDLER ID in Sllfile
SI250
SI- Assigned by
respondent
Certification sequence number must be greater than zero.
CERT SEQ > 0
SI260
SI-13
Certification last name must be provided.
CERT LAST NAME <> ''
SI265
SI-13
Certification first name must be provided.
CERT FIRST NAME <>''
November 2003
C-4
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
SI270
SI-13
Certification title must be provided.
CERT_TITLE o ' '
SI280
SI-13
Date certification was signed must be a valid date greater than
20030101 (January 1, 2003) and less than today.
CERT_SIGNED_DATE >= '20030101' AND
CERT_SIGNED_DATE < TODAY
SI290
SI-13
Certification data must be provided.
HANDLERJD in SI1 file and in SI7 file
SI310
SI-5
Site land type must equal 'P', 'C', 'D', 'F', 'I', 'M', 'S', or 'O'.
LAND_TYPE = 'P' or 'C' or 'D' or 'F' or T or 'M' or 'S' or 'O'
SI420
SI-9-A, SI-9-B
Owner / operator date must be a valid date greater than 1700101
(January 1, 1700).
OWNER_OPERAT OR_DATE = valid date
SI430
SI-9-A, SI-9-B
Owner / operator type must equal 'P', 'C', 'D', 'F', 'I', 'M', 'S', or
'O'.
OWNER_OPERATOR_T YPE = 'P' or 'C' or 'D' or 'F' or T or 'M'
or'S'or'O'
SI440
SI-9-A, SI-9-B
Owner / operator name must be provided.
OWNER_OPERATOR_NAME <> ".
SI460
SI-10-A-1
Importer of hazardous waste indicator must equal' Y' or 'N'.
IMPORTER_ACTIVITY = 'Y' or 'N'
SI470
SI-10-A-1
Mixed waste generator indicator must equal' Y' or 'N'.
MIXED_WASTE_GENERATOR = 'Y' or 'N'
SI480
SI-10-A-2
Transporter indicator must equal' Y or 'N'.
TRANSPORTER_ACTIVITY = 'Y' or 'N'
SI490
SI-10-A-4
Recycler indicator must equal'Y or 'N'.
RECYCLER_ACTIVITY = 'Y' or 'N'
SI500
SI-10-A-5
Small quantity on-site burner exemption indicator must equal' Y
or 'N'.
HWFUEL_ONSITE_BURNER_EXEMPT = 'Y' or 'N'
SIS 10
SI-10-A-5
Smelting, melting, refining furnace exemption indicator must
equal 'Y or 'N'.
HWFUEL_FURNACE_EXEMP T = 'Y' or 'N'
SI520
SI-10-A-6
Underground injection control indicator must equal' Y or 'N'.
UNDERGROUND_INJECTION_ACTIVITY = 'Y' or 'N'
SI530
SI-2
SI2 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERJD not in SI1 file
SI540
SI-10-B-1-A
Large quantity generator of batteries indicator must equal' Y or
'N'.
GEN_BATTERIES = 'Y' or 'N'
SI 550
SI-10-B-1-A
Large quantity accumulator of batteries indicator must equal' Y
or 'N'.
ACC_BATTERIES = 'Y' or 'N'
November 2003
C-5
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
SI560
SI-10-B-1-B
Large quantity generator of pesticides indicator must equal 'Y' or
'N'.
GENPESTICIES = 'Y' or 'N'
SI570
SI-10-B-1-B
Large quantity accumulator of pesticides indicator must equal 'Y'
or 'N'.
ACCPESTICIDES = 'Y' or 'N'
SI580
SI-10-B-1-C
Large quantity generator of thermostats indicator must equal 'Y'
or 'N'.
GENTHERMOSTATS = 'Y' or 'N'
SI590
SI-10-B-1-C
Large quantity accumulator of thermostats indicator must equal
Y' or 'N'.
ACC THERMOSTATS = 'Y' or 'N'
SI600
SI-10-B-1-D
Large quantity generator of lamps indicator must equal Y' or 'N'.
GEN LAMPS = 'Y' or 'N'
SI610
SI-10-B-1-D
Large quantity accumulator of lamps indicator must equal Y' or
'N'.
ACC LAMPS = 'Y' or 'N'
SI620
SI-10-B-2
Destination facility for universal waste indicator must equal 'Y' or
'N'.
UNIVERSALWASTEDESTFACILITY = Y' or 'N'
SI630
SI-10-C-1-A
Used oil transporter indicator must equal Y' or 'N'.
USEDOILTR ANSPORTER = 'Y' or 'N'
SI640
SI-10-C-1-B
Used oil transfer facility indicator must equal Y' or 'N'.
USEDOILTR ANSFER FACILITY = 'Y' or 'N'
SI650
SI-10-C-2-A
Used oil processor indicator must equal Y' or 'N'.
USED OIL PROCES SOR = 'Y' or 'N'
SI660
SI-10-C-2-B
Used oil re-refiner indicator must equal 'Y' or 'N'.
USED OIL REFINER = 'Y' or 'N'
SI670
SI-10-C-3
Off-specification used oil burner indicator must equal Y' or 'N'.
USED OIL BURNER = Y' or 'N'
SI680
SI-10-C-4-A
Used oil fuel marketer who directs shipment of off-specification
used oil to off-specification used oil burner indicator must equal
Y' or 'N'.
USED OIL MARKET BURNER = Y' or 'N'
SI690
SI-10-C-4-B
Used oil fuel marketer who first claims the used oil meets the
specification indicator must equal Y' or 'N'.
USED OIL SPEC MARKETER = Y' or 'N'
SI700
SI-2
SI3 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERID in SI1 file
November 2003
C-6
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
SI720
SI-10-B-1-E
Other universal waste activities must be an implementer defined
value other than 'B', 'P', 'T', or 'L'.
UNIVERSAL WASTE = implementer defined value in
LUUNI VERS AL_ W AS TE.
SI730
SI-10-B-1-E
Generated other universal waste activities indicator must equal 'Y'
or 'N'.
GENERATED = Y' or 'N'
SI740
SI-10-B-1-E
Accumulated other universal waste activities indicator must equal
'Y' or 'N'.
ACCUMULATED = Y' or 'N'
SI750
SI-10-B-1-E
Other universal waste activities must indicate whether the activity
was generated or accumulated.
If GENERATED = 'N' Then ACCUMULATED = 'Y'
If ACCUMULATED = 'N' Then GENERATED = 'Y'
SI760
SI-2
SI4 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERID in SI1 file
SI780
SI-ll-A
Waste code for federally regulated hazardous wastes must be a
federal waste code value specified in the 2003 Hazardous Waste
Report, Instructions and Forms.
EPA WASTE CODE = value specified in the 2003 Hazardous
Waste Report, Instructions and Forms
SI790
SI-2
SI5 record is present, but corresponding record does not exist in
the SI1 file.
HANDLER ID in SI1 file
SI810
SI-ll-B
Waste code must be registered with the RCRAInfo database.
STATE WASTE CODE = implementer defined value in
LUWASTECODE
SI820
SI8 record is present, but corresponding record does not exist in
the SI1 file.
HANDLER ID in SI1 file
SI830
State activity type must be registered with the RCRAInfo
database.
STATE ACTIVITY TYPE = implementer defined value in
LUST ATEACTIVITY
SI840
SI9 record is present, but corresponding record does not exist in
the SI1 file.
HANDLER ID in SI1 file
SI850
Owner/operator state must be a value specified in Appendix F or
blank.
OWNER OPERATOR STATE = value specified in Appendix F
or"
SI870
Owner/operator zip code must contain only the characters 0, 1,2,
3, 4, 5, 6, 7, 8, 9, or blank.
OWNER OPERATOR ZIP characters = '0', '1', '2', '3', '4', '5', '6',
7' ig' '9' ''
November 2003
C-7
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
SI890
Owner/operator country must be a valid value. If the
owner/operator country is blank, a value of UNITED STATES
will be assumed.
OWNER OPERATOR COUNTRY = country name provided in
LUCOUNTRY
SI910
Owner / operator indicator must equal 'CO' or 'CP'.
OWNEROPERATORINDICATOR = 'CO' or 'CP'
SI920
At least one SI9 record with owner/operator indicator = 'CO' and
at least one SI9 record with owner/operator indicator = 'CP' must
be provided.
There must be at least one record in SI9 where
OWNER OPERATOR INDICATOR = 'CO' and
there must be a least one record in SI9 where
OWNEROPERATORINDICATOR = 'CP'
SI999
Include in national report flag must equal 'Y' or 'N'.
INCLUDE IN NATIONAL REPORT = 'Y' or 'N'
November 2003
C-8
File Specification Guide
-------
C.4 Form GM Edits
Edit
Number
Form Location
Edit Description
Select Logic
GM000
GM
GM1 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERID in Sllfile
GM010
GM
Page number must be greater than zero.
HZPG > 0
GM020
GM-l-H
Generated quantity unit of measure must equal '1', '2', '3', '4', '5',
'6', or '7'.
UNIT OF MEASURE = '1' or '2' or '3' or '4' or '5' or '6' or '7'
GM030
GM-l-H
If the generated quantity unit of measure is '5', '6' or '7' then
density must be greater than zero and density unit of measure
must be 1 or 2.
If UNIT OF MEASURE = '5', '6', or '7' Then
WST DENSITY > 0 AND
DEN SITYUNITOFME ASURE = 1 or 2
GM040
GM-l-H
Waste density must be greater than or equal to 0.01 and less than
or equal to 999.99, or equal to 0.
WST DENSITY >= 0.01 and <= 999.99 or
WSTDENSITY = 0
GM050
GM-l-G
Quantity generated in the reporting year must be greater than or
equal to 0.000001 and less than or equal to
99,999,999,998.999999, or equal to zero.
GEN QTY >= 0.000001 and <= 99999999998.999999 or
GENQTY = 0
GM060
GM
GM2 record is present, but corresponding record does not exist in
the GM1 file.
HANDLER ID and HZ PG in GM1 file
GM090
GM-l-B
EPA hazardous waste code must be an EPA waste code value
specified in the 2003 Hazardous Waste Report, Instructions and
Forms.
EPA WASTE CODE = value specified in the 2003 Hazardous
Waste Report, Instructions and Forms
GM100
GM-l-B
EPA or State hazardous waste data must be provided.
HANDLER ID and HZ PG in GM1 file and in GM2 or GM3 file
GM110
GM
GM4 record is present, but corresponding record does not exist in
the GM1 file.
HANDLER ID and HZ PG in GM1 file
GM120
GM - Assigned by
respondent
Off-site code sequence number must be greater than zero.
IO PG NUM SEQ > 0
GM140
GM-3-B
The off-site shipment handler EPA ID number must begin with a
valid state postal code.
SUBSTR(IO TDR ID, 1,2) = valid state postal code (see Appendix
F)
November 2003
C-9
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
GM150
GM-3-D
Total quantity shipped off-site in the reporting year must be
greater than or equal to 0.000001 and less than or equal to
99,999,999,998.999999.
IOTDRQTY >= 0.000001 and <= 99999999998.999999
GM160
GM-3-C
The off-site management method must be a management method
specified in the 2003 Hazardous Waste Report, Instructions and
Forms or blank.
MANAGEMENTMETHOD = management method specified in
the 2003 Hazardous Waste Report, Instructions and Forms or
blank.
GM170
GM
GM5 record is present, but corresponding record does not exist in
the GM1 file.
HANDLERID and HZPG in GM1 file
GM180
GM - Assigned by
respondent
On-site sequence number must be greater than zero.
S Y SPGNUMSEQ > 0
GM190
GM-2
Total quantity treated, disposed, or recycled on-site in the
reporting year must be greater than or equal to 0.000001 and less
than or equal to 99,999,999,998.999999.
SYSTDRQTY >= 0.000001 and <= 99999999998.999999
GM210
GM-2
The on-site management method must contain a management
method specified in the 2003 Hazardous Waste Report,
Instructions and Forms.
MANAGEMENT METHOD = value specified in the 2003
Hazardous Waste Report, Instructions and Forms
GM220
GM-l-E
The form code must be a form code value specified in the 2003
Hazardous Waste Report, Instructions and Forms or blank.
FORM CODE = value specified in the 2003 Hazardous Waste
Report, Instructions and Forms or ''
GM230
GM-l-D
If source code equals G25 then the management method code
must be a management method specified in the 2003 Hazardous
Waste Report, Instructions and Forms. If source code is not
equal to G25 then the management method code must be blank.
If SOURCE TYPE = 'G25' Then
ORIGINMANAGEMENTMETHOD = value specified in the
2003 Hazardous Waste Report, Instructions and Forms
Else ORIGIN MANAGEMENT METHOD = ''
GM270
GM-l-D
The source code must be a source code value specified in the
2003 Hazardous Waste Report, Instructions and Forms.
SOURCE CODE = value specified in the 2003 Hazardous Waste
Report, Instructions and Forms
GM280
GM
GM3 record is present, but corresponding record does not exist in
the GM1 file.
HANDLER ID and HZ PG in GM1 file
GM300
GM-l-C
Waste code must be registered with the RCRAInfo database.
WASTE CODE = implementer defined state waste code in
LUWASTECODE
November 2003
C-10
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
GM310
If Include in National Report in the SI1 file equals 'N' then
Include in National Report must be a 'N'. If Include in National
Report in the SI1 file equals 'Y' then Include in National Report
must be a 'Y' or 'N'.
If INCLUDE IN NATIONAL REPORT = 'N' in the SI1 file Then
INCLUDE IN NATIONAL REPORT = 'N'
Else INCLUDE IN NATIONAL REPORT = Y' or 'N'
GM320
GM-2
On-site management indicator must equal 'Y' or 'N'
ON SITE MANAGEMENT = 'Y' or 'N'
GM330
GM-2
If On-site management indicator equals 'Y' then at least one
corresponding record must exist in GM5 file.
If ON SITE MANAGEMENT = 'Y' Then
HANDLER ID and HZ PG in GM5 file
GM335
GM-2
If On-site management indicator equals 'N' then no
corresponding record may exist in GM5 file.
If ON SITE MANAGEMENT = 'N' Then no record in GM5 file
for HANDLER ID and HZ PG
GM340
GM-3-A
Off-site management indicator must equal 'Y' or 'N'
OFF SITE SHIPMENT = 'Y' or 'N'
GM350
GM-3-A
If Off-site shipment indicator equals 'Y' then at least one
corresponding record must exist in GM4 file.
If OFF SITE SHIPMENT ='Y'Then
HANDLER ID and HZ PG in GM4 file
GM355
GM-3-A
If Off-site shipment indicator equals 'N' then no corresponding
record may exist in GM4 file.
If OFF SITE SHIPMENT = 'N' Then no record in GM4 for
HANDLER ID and HZ PG
November 2003
C-11
File Specification Guide
-------
C.5 Form WR Edits
Edit
Number
Form Location
Edit Description
Select Logic
WR000
WR
WR1 record is present, but corresponding record does not exist in
the SI1 file.
HANDLERID in Sllfile
WR010
WR
Page number must be greater than zero.
HZPG > 0
WR020
WR
Sub-page number must equal '1', '2', or '3'.
SUB PG NUM = '1' or '2' or '3'
WR030
WR-F
Generated quantity unit of measure must equal '1', '2', '3', '4', '5',
'6', or '7'.
UNIT OF MEASURE = '1' or '2' or '3' or '4' or '5' or '6' or '7'
WR040
WR-F
If the generated quantity unit of measure is '5', '6' or '7' then
density must be greater than zero and density unit of measure
must be 1 or 2.
If UNIT OF MEASURE = '5', '6', or '7' Then
WST DENSITY > 0 AND
DEN SITYUNITOFME ASURE = 1 or 2
WR050
WR-F
Waste density must be greater than or equal to 0.01 and less than
or equal to 999.99, or equal to 0.
WST DENSITY >= 0.01 and <= 999.99 or
WSTDENSITY = 0
WR060
WR-H
Management method code must be a management method
specified in the 2003 Hazardous Waste Report, Instructions and
Forms.
MANAGEMENT METHOD = value specified in the 2003
Hazardous Waste Report, Instructions and Forms
WR070
WR-D
The first two characters of the off-site handler EPA ID number
must be a valid postal code (see Appendix F) or 'FC' (foreign
country).
SUBSTR(IO TDR ID,1,2) = valid postal code (see Appendix F)
or 'FC'
WR080
WR-E
Total quantity received in the reporting year must be greater than
or equal to 0.000001 and less than or equal to
99,999,999,998.999999.
IOTDRQTY >= 0.000001 and <= 99999999998.999999
WR090
WR
WR2 record is present, but corresponding record does not exist in
the WR1 file.
HANDLER ID, HZ PG, and SUB_PG_NUM in WR1 file
WR110
WR-B
EPA hazardous waste code must be an EPA waste code specified
in the 2003 Hazardous Waste Report, Instructions and Forms.
EPA WASTE CODE = value specified in the 2003 Hazardous
Waste Report, Instructions and Forms
WR130
WR-B
EPA or State hazardous waste data must be provided.
HANDLER ID, HZ PG, and SUB PG NUM in WR1 file and in
WR2 or WR3 file
November 2003
C-12
File Specification Guide
-------
Edit
Number
Form Location
Edit Description
Select Logic
WR180
WR-G
The form code must be a form code specified in the 2003
Hazardous Waste Report, Instructions and Forms or blank.
FORM CODE = value specified in the 2003 Hazardous Waste
Report, Instructions and Forms or ''
WR200
WR
WR3 record is present, but corresponding record does not exist in
the WR1 file.
HANDLERID, HZ PG, and SUB_PG_NUM in WR1 file
WR220
WR-B
Waste code must be registered with the RCRAInfo database.
WASTE CODE = implementer defined value in
LUWASTECODE
WR230
If Include in National Report in the SI1 file equals 'N' then
Include in National Report must be 'N'. If Include in National
Report in the SI1 file equals 'Y' then Include in National Report
must be 'Y' or 'N'.
If INCLUDE IN NATIONAL REPORT = 'N' in the SI1 file Then
INCLUDE IN NATIONAL REPORT = 'N'
Else INCLUDE IN NATIONAL REPORT = 'Y' or 'N'
November 2003
C-13
File Specification Guide
-------
APPENDIX D
Hazardous Waste Report Annotated Forms
-------
APPENDIX D - Hazardous Waste Report Annotated Forms
SEND THE
COMPLETED FORM
TO:
The Appropriate State or
EPA Regional Office.
United States Environmental Protection Agency
RCRA SUBTITLE C SITE IDENTIFICATION FORM
1. Reason for
Submittal
(See instructions
on page 23)
MARK ALL BOX(ES)
THAT APPLY
Reason for Submittal: SI1-2
~ To provide Initial Notification of Regulated Waste Activity (to obtain an EPA ID Number for hazardous waste,
universal waste, or used oil activities).
~ To provide Subsequent Notification of Regulated Waste Activity (to update site identification information).
~ As a component of a First RCRA Hazardous Waste Part A Permit Application.
~ As a component of a Revised RCRA Hazardous Waste Part A Permit Application (Amendment
# L
X As a component of the Hazardous Waste Report.
2. Site EPA ID
Number
(See page xx)
EPA ID Number:
! i >
SI1-1
i i i
i i
3. Site Name
(See page xx)
Name:
SI1-3
4. Site Location
Information
(See page xx)
Street Address:
SI-4, SI-5, SI1-6
City, Town, or Village:
SI1-7
State:
SI1-9
County Name:
811-8
Zip Code:
SI1-10
5. Site Land Type
(See page xx)
Site Land Type: ~ Private
SI1-18
~ County ~ District
~ Federal
~ Indian ~ Municipal ~ State ~ Other
6. North American
Industry
Classification
System (NAICS)
Code(s) for the Site
(See page xx)
A. SI6-3
B.
C.
D.
7. Site Mailing
Address
(See page xx)
Street or P. 0. Box:
SI1-11, SI1-12, SI1-13
City, Town, or Village:
SI1-14
State:
SI1-15
Country:
SI1-16
Zip Code:
SI1-17
8. Site Contact
Person
(See page xx)
First Name: SI1-19
Ml:
SI1-20
Last Name:
Sli-21
Phone Number: SI1-22
Extension: SI1-23
Email address:
SI1-36
November 2003
D-1
File Specification Guide
-------
9. Operator and
Legal Owner
A. Name of Site's Operator: SI9-4
Date Became Operator (mm/dd/yyyy): SI9-5
of the Site
(See pages xx
to xx)
Operator Type: ~ Private ~ County ~ District ~ Federal
SI9-6
~ Indian ~ Municipal ~ State ~ Other
B. Name of Site's Legal Owner: SI9-4
Date Became Owner (mm/dd/yyyy): SI9-5
Owner Type: ~ Private ~ County ~ District ~ Federal ~ Indian ~ Municipal ~ State ~ Other
SI9-6
Street or P. O. Box: SI9-7, SI9-8, SI9-9
City: SI9-10
State: SI9-11
Country: SI9-13
Zip Code: SI9-12
10. Type of Regu lated Waste Activity
Mark Yes or No for all activities; complete any additional boxes as instructed. (See instructions on pages xx to xx.)
A. Hazardous Waste Activities
Complete all parts for 1 through 6.
Y ~ N ~ 1. Generator of Hazardous Waste
If Yes, choose only one of the following - a, b, or c.
S11-25
~ a. LQG: Greater than 1,000 kg/mo (2,200 Ibs./mo.)
of non-acute hazardous waste; or
~ b. SQG: 100 to 1,000 kg/mo (220 - 2,200 Ibs./mo.)
of non-acute hazardous waste; or
~ c. CESQG: Less than 100 kg/mo (220 Ibs./mo.)
of non-acute hazardous waste
In addition, indicate other generator activities.
Y ~ N ~ d. United States Importer of Hazardous Waste
SI1-26
Y ~ N ~ e. Mixed Waste (hazardous and radioactive) Generator
SI1-27
YGNQ2. Transporter of Hazardous Waste
SI1-28
YUNG 3. Treater, Store r, or Disposer of Hazardous
Waste (at your site) Note: A hazardous
waste permit is required for this activity.
SI1-29
Y ~ N ~ 4. Recycler of Hazardous Waste (at your
site)
SI1-30
Y ~ N ~ 5. Exempt Boiler and/or Industrial Furnace
If Yes, mark each that applies.
~ a. Small Quantity On-site Burner
Exemption SI1-31
~ b. Smelting, Melting, and Refining Furnace
Exemption SI1-32
Y ~ N ~ 6. Underground Injection Control
SI1-33
November 2003
D-2
File Specification Guide
-------
B. Universal Waste Activities
Yd N ~ 1.
Large Quantity Handler of Universal Waste (accumulate
5,000 kg or more) [refer to your State regulations to
determine what Is regulated}. Indicate types of universal
mark all boxes that apply:
Generate Accumulate
a.
Batteries
~ SI2-2 ~ SI2-3
b.
Pesticides
~ SI2-4 ~ SI2-5
c.
Thermostats
~ SI2-6 ~ SI2-7
d.
Lamps
~ SI2-8 ~ SI2-9
e.
Other (specify) SI3-2
~ SI3-3 ~ SI3-4
f.
Other (specify)
~ a
g-
Other (specify)
~ ~
Y ~ N ~ 2.
Destination Facility for Universal Waste
Note: A hazardous waste permit may be required for this
activity.
SI2-10
C. Used Oil Activities
Mark all boxes that apply.
Y ~ N ~ 1. Used Oil Transporter
If Yes, mark each that applies.
~ a. Transporter S12-11
~ b. Transfer Facility SI2-12
Y ~ N ~ 2. Used Oil Processor and/or Re-reflner
If Yes, mark each that applies.
~ a. Processor SI2-13
~ b. Re-refiner SI2-14
Y ~ N ~ 3. Off-Specification Used Oil Burner SI2-15
Y ~ N ~ 4. Used Oil Fuel Marketer
If Yes, mark each that applies.
~ a. Marketer Who Directs Shipment of
Off-Specification Used Oil to
Off-Specification Used Oil Burner SI2-16
~ b. Marketer Who First Claims the Used
Oil Meets the Specifications SI2-17
11. Description of Hazardous Wastes (See instructions on page xx)
A, Waste Codes for Federally Regulated Hazardous Wastes. Please list the waste codes of the Federal hazardous wastes handled
at your site. List them in the order they are presented in the regulations (e.g., D001, D003, F007, U112). Use an additional page if
more spaces are needed.
SI4-2
B. Waste Codes for State-Regulated (i.e., non-Federal) Hazardous Wastes. Please list the waste codes of the State-regulated
hazardous wastes handled at your site. List them in the order they are presented in the regulations. Use an additional page if more
spaces are needed for waste codes.
SI5-2
12. Comments (See instructions on page xx)
SI1-35
November 2003
D-3
File Specification Guide
-------
13. Certification. I certify under penalty of law that this document and all attachments were prepared under my direction or supervision in
accordance with a system designed to assure that qualified personnel properly gather and evaluate the information submitted. Based on my
inquiry of the person or persons who manage the system, or those persons directly responsible for gathering the information, the
information submitted is, to the best of my knowledge and belief, true, accurate, and complete. I am aware that there are significant
penalties for submitting false information, including the possibility of fine and imprisonment for knowing violations.
(See instructions on page xx)
Signature of owner, operator, or an
authorized representative
Name and Official Title (type or print)
Date Signed
(mm/dd/yyyy)
SI7-3, SI7-4, Si7-5, SI7-6
SI7-7
November 2003
D-4
File Specification Guide
-------
OMB#: 2050-0024 Expires 10/31/2005
FORM
GM
BEFORE COPYING FORM, ATTACH SITE IDENTIFICATION LABEL
OR ENTER:
SITE NAME:
EPA ID NO:
GM(x)-1
U.S. ENVIRONMENTAL
PROTECTION AGENCY
2003 Hazardous Waste Report
WASTE GENERATION
AND MANAGEMENT
Instructions: Please see the detailed instructions beginning on page 19 of the instructions and forms booklet before completing this form.
Sec. 1 A. Waste description GM1-11
B. EPA hazardous waste code
I I I I ''''I GM2-3
I I I I I I I I I I I I I I I
C. State hazardous waste code
I I I I I I I I I I L
GM3-3
J
D. Source code E. Form code
LGJ—I—I GM1-8
Management Method code for Source code G25
LHJ—|—|—| GM1.7
LWJ !_l I
GM1-3
F. Quantity generated in 2003
I I I I l I i I I I,
GM1-9
G. UOM | |
GM1-4
Density
I l l.l l l
GM1-5
~ lbs/gal ~ sg GM1-6
Sec. 2 Was any of this waste managed on site? (pages
o 1 Yes (CONTINUE TO ON-SITE PROCESS SYSTEM 1) GM1-13
n 2 No (SKIP TO SEC. 3)
ON-SITE PROCESS SYSTEM 1
On-site Management Quantity treated, disposed, or
Method code recycled on site in 2003
LhJ—I—I—I GM5-4 I I I I I I—I GM5-5
ON-SITE PROCESS SYSTEM 2
On-site Management
Method code
lhj i I I
Quantity treated, disposed, or
recycled on site in 2003
I I I l I I l I I l I I
Sec. 3 A. Was any of this waste shipped off site in 2003 for treatment, disposal, or recycling? (pages 25 and 26)
~ 1 Yes (CONTINUE TO BOX B) ~ 2 No (FORM IS COMPLETE) GM1-14
Site 1 B. EPA ID No. of facility to which waste was C. Off-site Management Method code D. Total quantity shipped in 2003
shipped Shipped to
I I I I I I I I I I l I I I I I LHJ—I—I—I
GM4-5 GM4-4
I I !_l I I I I I I.
GM4-6
Comments: GM1-12
November 2003
D-5
File Specification Guide
-------
OMB#: 2050-0024 Expires 10/31/2005
BEFORE COPYING FORM, ATTACH SITE IDENTIFICATION LABEL
OR ENTER:
SITE NAME:
FORM
WR
U.S. ENVIRONMENTAL
PROTECTION AGENCY
2003 Hazardous Waste Report
WASTE RECEIVED
FROM OFF SITE
instructions: Please see the detailed instructions beginning on page 27 of the instructions and forms booklet before completing this form.
A Description of hazardous waste
Waste WR1"12
1
B. EPA hazardous waste code
l_l I I I I I I I I WR2-4
I I I I l I l I l I
C. State hazardous waste code
1—1—1—1—1—1—1 WR3-4
I I I I I I I
D. Off-site handler EPA ID number
I I I I I I I I I I I I 1_J L
WR1-9
E. Quantity received in 2003
I I I I I I I I
F. UOM Density
WR1-10
I I I
WR1-6
WR1-5
~ 1 lbs/gal o 2 sg WR1-7
G. Form code
LWJ—I—I—I VVR1-4
H. Management Method code
LHJ—I—I—I WR1-8
Comments: WR1-13
November 2003
D-6
File Specification Guide
-------
FORM
SITE NAME:
EPA ID NO:
011-1
BEFORE COPYING FORM, ATTACH SITE IDENTIFICATION LABEL OR
ENTER:
U.S. ENVIRONMENTAL
PROTECTION AGENCY
2003 Hazardous Waste Report
OFF-SITE
IDENTIFICATION
Instructions: Please read the detailed instructions on the reverse side before completing this form.
A. EPA ID No. of off-site installation or transporter
Site! I I I I I I I I I I I I I I I I OI1-3
B. Name of off-site installation or transporter
011-7
C. Handler type (CHECK ALL THAT APPLY)
~ Generator OI1-4
~ Transporter 011-5
~ TSDR facility 011-6
D. Address of off-site installation
Street OI1-8, OI1-9
City OI1-10 State I I I
Zip I—I—I—I—I—I "I—I—I—I—I OI1-12 011-11
A. EPA ID No. of off-site installation or transporter
-i( - I I m i i i
B. Name of off-site installation or transporter
C. Handler type (CHECK ALL THAT APPLY)
~ Generator
~ Transporter
~ TSDR facility
D. Address of off-site installation
Street
City State I I I
7ip 1 I I I I i -1 I I 1 I
A. EPA ID No. of off-site installation or transporter
3 I I 1 1 1 I 1 I 1 1
B. Name of off-site installation or transporter
C. Handler type (CHECK ALL THAT APPLY)
~ Generator
~ Transporter
~ TSDR facility
D. Address of off-site installation
Street
Citv Stptf3 1 I I
Zip 1 1 1 1 1 1" 1 1 1 1 1
Comments:
011-13
November 2003
D-7
File Specification Guide
-------
APPENDIX E
Flat File Hierarchy
-------
APPENDIX E - Flat File Hierarchy
GM1
WR1
SI2
SI3
SI4
SI1
SI5
SI6
SI7
SI8
SI9
Oil
WR2
WR3
GM2
GM4
GM5
GM3
* These flat files contain required data elements.
NOTE: The Oil flat file should never be included in the submission to RCRAInfo.
November 2003
E-1
File Specification Guide
-------
APPENDIX F
State Postal Codes
-------
APPENDIX F - State Postal Codes
State Name
Postal
Code
State Name
Postal
Code
State Name
Postal
Code
Alabama
AL
Kentucky
KY
Ohio
OH
Alaska
AK
Louisiana
LA
Oklahoma
OK
American Samoa
AS
Maine
ME
Oregon
OR
Arizona
AZ
Maryland
MD
Pennsylvania
PA
Arkansas
AR
Massachusetts
MA
Puerto Rico
PR
California
CA
Michigan
MI
Rhode Island
RI
Colorado
CO
Minnesota
MN
South Carolina
SC
Connecticut
CT
Mississippi
MS
South Dakota
SD
Delaware
DE
Missouri
MO
Tennessee
TN
District of Columbia
DC
Montana
MT
Texas
TX
Florida
FL
Navajo Nation
NN
Trust Territories
TT
Georgia
GA
Nebraska
NE
Utah
UT
Guam
GU
Nevada
NV
Vermont
VT
Hawaii
HI
New Hampshire
NH
Virgin Islands
VI
Idaho
ID
New Jersey
NJ
Virginia
VA
Illinois
IL
New Mexico
NM
Washington
WA
Indiana
IN
New York
NY
West Virginia
WV
Iowa
IA
North Carolina
NC
Wisconsin
WI
Kansas
KS
North Dakota
ND
Wyoming
WY
November 2003
F-1
File Specification Guide
-------
End of document.
------- |