The information presented in the "File Naming and Storage Conventions" section of this README.TXT file discusses how to de-archive BRS data files. To effectively use this data you will need to understand how the data is structured and how the structures map to the data collection forms. The document "Instruction Manual For The Biennial Reporting System (BRS) Flat Files" presents the necessary structure and mapping information. This README.TXT file and the "Instruction Manual For The Biennial Reporting System (BRS) Flat Files" are included in the USOCY95.EXE archive. The file named FFMANUAL.EXE is a self-extracting PKZIP archive containing the file FFMANUAL.PDF. FFMANUAL.PDF is an electronic version of the data manual in Adobe Acrobat format, and you must view it using the Adobe Acrobat reader. Adobe Acrobat readers are available through Adobe's Web site at - http://www.adobe.com/prodindex/acrobat/readstep.html About The Data ====================================================== Legislative Authority: Resource Conservation and Recovery Act of 1976 (RCRA) Sections 3002 and 3004. Hazardous and Solid Waste Amendments of 1984 (HSWA) Regulatory Authority: ===================== Code of Federal Regulations (CFR) Title 40 How Collected: ============== The data contained in these files are the Biennial Report (BR) data for reporting year 1995. Biennial Report data are collected by states from RCRA Treatment, Storage and Disposal (TSD) Facilities and RCRA Large Quantity Generators (LQGs). Collection, validation and verification of the BR data is the responsibility of RCRA authorized states. EPA does not modify the data reported by the states. Any questions regarding the information reported for a RCRA handler should be directed to the state agency responsible for the BR data collection. Reporting Universe ================== RCRA TSD and/or LQG information ONLY. EPA deletes from a state's BR data submission any handler that is not either a RCRA TSD or a RCRA LQG. This determination is made by examining the data values reported on form IC. Generator Status is reported on form IC, Section VI, Block A. Reporters having a generator status value of 1 are considered LQGs. RCRA TSD status is reported on form IC, Section VII, Block A (RCRA storage) and Block B (RCRA treatment). Reporters having either a RCRA storage status of 2, 3, 4, or 5, or a RCRA treatment status of 3 are considered TSDs. The RCRA generator status is found in field #11 in the S2 data file at column position 162. The RCRA storage status is found in field #17 in the S2 data file at column position 222. The RCRA treatment status is found in field #18 in the S2 data file at column position 223. Data Files and Structure ================================================================ One Adobe Acrobat PDF formated file is provided. This file is the "Instruction Manual For The Biennial Reporting System (BRS) Flat Files" and presents the structure and mapping information necessary to read the data correctly. This file is named FFMANUAL.PDF and is contained in the archive FFMANUAL.EXE) Thirty (30) ASCII data files are provided. Two of the data files contain information used to verify the integrity of the other twenty-eight files. The first is the CONTROL (CL) file consisting of one record for each of the 28 data files. The control file provides record counts for each of the files containing reported data. The second is the FILE STATISTICS (FS) file which is a text file containing three reports with record frequencies by File-ID, by File-ID and State, and by State and File-ID. The file USOHT95.BRS handler total (HT) file provides National Biennial Hazardous Waste Report quantity totals for each handler in the data files: RCRA Waste Generated, Received, Imported from other States, Managed on site, Received and Managed, Wastewater Managed, Non-Wastewater Managed, Shipped off site, and Waste Exported to other States. This file is provided with the USOSY95.EXE archive. The twenty seven (27) remaining files contain the reported data. The reported data is organized in non-delimited ASCII files. These files are a relational representation of the data in third normal form. Each ASCII data file consists of fixed length records. The fields within each record are defined by their starting and ending column positions. The file layouts for these files are contained in the user manual described above. The BR ASCII data files are organized in groups based on the Forms used by the National Hazardous Waste Report as follows: Control File = File CL File Statistics = File FS Nat. Rpt. Quantity Totals = File HT Form IC = Files S1, S2, S3 and S5 Form GM = Files G1, G2, G3, G5, G6, G7, G8 and G9 Form WR = Files R1, R2, R3, R4 and R5 Form PS = Files T1, T2, T3 and T4 Form WM = Files M1, M2, M3, M5, M6, and M7 NOTE: The S4, G4, and M4 files are no longer used because the data is not reported after 1991. The files have not been re-numbered in order to remain consistent with the standards and conventions used for 1989 and 1991 structures. File Naming and Storage Conventions ================================================================= File Groups Archived in a Single Compressed File =================================================== All files in each file set are stored in a single archive file using PKZIP. This will be a self extracting (.EXE) file. Mass Storage Device Archives ============================ BRS flat files archives stored on mass storage devices will be self-extracting PKZIP (.EXE) archives. These archives are opened by typing the archive name, without the (.EXE) extension. The file names for the PKZIP self-extracting (.EXE) archives use the following naming conventions: USOxY95.EXE where x = The first character of the File-ID (C, S, G, R, T, M) Self Extracting Compressed Flat Files Within Each File Set Archive ================================================================= The individual flat files within a set are each stored in a PKZIP self-extracting archive. The file names for the PKZIP self-extracting (.EXE) archives use the following naming conventions: USOxxY95.EXE Where xx = The File ID (UM, CL, FS, HT, S1-S5, G1-G9, R1-R5, T1-T4, M1-M7) Uncompressed Flat Files ======================= The Uncompressed flat file names use the following naming conventions: USOxxY95.BRS Where xx = The File ID (CL, FS, HT, S1-S5, G1-G9, R1-R5, T1-T4, M1-M7) yy = The last two digits of the data year (e.g., 91) FFMANUAL.PDF is the "Instruction Manual For The Biennial Reporting System (BRS) NTIS Flat Files" and presents the necessary file structure and mapping information.