CSV FILE SPECIFICATIONS - BIENNIAL REPORT MODULE

***WARNING***   The data (primarily notes / comments) may contain line feeds, carriage returns, and/or end of transmission blocks.  These need to be ignored when uploading your data.  ***WARNING***

 

The CSV file specifications associated with the tables in the Biennial Report Module are documented, by table, below.  

 

 

BR_REPORTING

English Name

Excel Column

Field Length

Data Type

EPA Handler ID A

12

Alphanumeric

Activity Location

B

2

Alphanumeric

Source Type

C

1

Alphanumeric

Handler Sequence Number

D

6

Integer

Hazardous Waste Stream Page Number E

5

Integer

Sub-page Sequence Number F

5

Integer

BR Form

G

2

Alphanumeric

Management Location

H

7

Alphanumeric

Reporting Cycle Year I

4

Integer

State J

2

Alphanumeric

State Name K

30

Alphanumeric

Region L

2

Alphanumeric

Handler Name M

80

Alphanumeric

Location Street Number N

12

Alphanumeric

Location Street 1 O

50

Alphanumeric

Location Street 2 P

50

Alphanumeric

Location City Q

25

Alphanumeric

Location State R

2

Alphanumeric

Location Zip Code S

14

Alphanumeric

County Code T

5

Alphanumeric

County Name U

27

Alphanumeric

State District V

10

Alphanumeric

Generator ID Included in NBR W

1

Alphanumeric

Generated Waste Included in NBR X

1

Alphanumeric

Management Facility ID Included in NBR Y

1

Alphanumeric

Managed Waste Included in NBR Z

1

Alphanumeric

Shipper ID Included in NBR AA

1

Alphanumeric

Shipped Waste Included in NBR AB

1

Alphanumeric

Receiver ID Included in NBR AC

1

Alphanumeric

Received Waste Included in NBR AD

1

Alphanumeric

Waste Description AE

240

Alphanumeric

Primary NAICS Code AF

6

Alphanumeric

Waste Source Code AG

3

Alphanumeric

Waste Form Code AH

4

Alphanumeric

Management Method Code AI

4

Alphanumeric

Federal Waste Indicator AJ

1

Alphanumeric

Wastewater Characteristic Flag AK

1

Alphanumeric

Quantity Generated (in tons) AL

19

Number

Quantity Treated, Disposed, or Recycled On-site (in tons) AM

19

Number

Quantity Shipped Off-site (in tons) AN

19

Number

Quantity Received (in tons) AO

19

Number

EPA ID Number of Facility to Which Waste was Shipped AP

12

Alphanumeric

Waste Received - State Code AQ

2

Alphanumeric

Waste Received - State Name AR

30

Alphanumeric

Waste Received - EPA Region AS

2

Alphanumeric

EPA ID Number of Handler Which Shipped the Waste AT

12

Alphanumeric

Waste Shipped - State Code AU

2

Alphanumeric

Waste Shipped - State Name AV

30

Alphanumeric

Waste Shipped - EPA Region AW

2

Alphanumeric

Waste Minimization Code AX

1

Alphanumeric

Waste Code Group AY

9

Alphanumeric

Generator Status (Calculated) AZ

1

Alphanumeric

Acute / Non-Acute Status BA

1

Alphanumeric

Waste Generation Activity BB

1

Alphanumeric

Priority Chemical BC

1

Alphanumeric

Management Category BD

35

Alphanumeric

Waste Property BE

1

Alphanumeric

Last Change BF

8

Date

Federal Waste Codes BG

4000

Alphanumeric

Country Code (beginning with the 2019 BR Cycle) BH

2

Alphanumeric

Mixed Waste (beginning with the 2019 BR Cycle) BI

1

Alphanumeric

BR_GM_WASTE_CODE

English Name

Excel Column

Field Length

Data Type

EPA Handler ID A

12

Alphanumeric

Activity Location

B

2

Alphanumeric

Source Type

C

1

Alphanumeric

Handler Sequence Number

D

6

Integer

Hazardous Waste Stream GM Form Page Number E

5

Integer

Hazardous Waste Code Owner F

2

Alphanumeric

Hazardous Waste Code

G

6

Alphanumeric

BR_WR_WASTE_CODE

English Name

Excel Column

Field Length

Data Type

EPA Handler ID A

12

Alphanumeric

Activity Location

B

2

Alphanumeric

Source Type

C

1

Alphanumeric

Handler Sequence Number

D

6

Integer

Hazardous Waste Stream WR Form Page Number

E

5

Integer

WR Form Waste Sub-page Number

F

1

Integer

Hazardous Waste Code Owner

G

2

Alphanumeric

Hazardous Waste Code

H

6

Alphanumeric

BR_LU_FORM_CODE

English Name

Excel Column

Field Length

Data Type

Form Code Owner A

2

Alphanumeric

Form Code B

4

Alphanumeric

Form Code Name C

20

Alphanumeric

Form Code Description D

150

Alphanumeric

Active Status E

1

Alphanumeric

BR_LU_MANAGEMENT_METHOD

English Name

Excel Column

Field Length

Data Type

Management Method Owner A

2

Alphanumeric

Management Method B

4

Alphanumeric

Management Method Description C

50

Alphanumeric

Active Status D

1

Alphanumeric

BR_LU_SOURCE_CODE

English Name

Excel Column

Field Length

Data Type

Source Code Owner A

2

Alphanumeric

Source Code B

3

Alphanumeric

Source Code Name C

20

Alphanumeric

Source Code Description D

100

Alphanumeric

Active Status E

1

Alphanumeric

BR_LU_WASTE_MINIMIZATION

English Name

Excel Column

Field Length

Data Type

Waste Minimization Owner A

2

Alphanumeric

Waste Minimization B

1

Alphanumeric

Waste Minimization Description C

50

Alphanumeric

Active Status D

1

Alphanumeric