TE 10.1 Enviromanager Data Requirements for Annual Report (KEEP) (1).pdf

TE 10.1

Environmental Manager Data Requirements for Annual Report

The table below highlights the data requirements for anticipated submission of BOSS contractor data for incorporation into EnviroManager’ s HazMat Software Module for Year-end Tier II reports and general hazmat usage tracking.

Data Dictionary

Field Name Data Type Example

PRODUCT NAME NVARCHAR 150 9V ALKALINE BATTERY

NATIONAL STOCK NBR (If available) NVARCHAR 25 6135-01-511-8262

MANUFACTURER NAME NVARCHAR 150 EVEREADY

CONTAINER TYPE See Numbered List Below 11

PRIMARY LOCATION NVARCHAR 150 Paint Shop

SECONDARY LOCATION NVARCHAR 150 Maintenance TERTIARY LOCATON NVARCHAR 150 Various

PRESSURE INTEGER 45

TEMPERATURE INTEGER 72

AVERAGE AMOUNT ON SITE per location

INTEGER 15 (units)

MAXIMUM AMOUNT ON SITE INTEGER 25(units)

CHEMICAL NAME 1 NVARCHAR 150 NITROPHENAL

CASE NUMBER 1 INTEGER 100027

MAXIMUM % OF CHEMICAL 1 INTEGER 5

CHEMICAL NAME 2 NVARCHAR 150 LEAD

CASE NUMBER 2 INTEGER 7439921

MAXIMUM % OF CHEMICAL 2 INTEGER 60

CHEMICAL NAME 3 NVARCHAR 150 LEAD OXIDE

CASE NUMBER 3 INTEGER 1309600

MAXIMUM % OF CHEMICAL 3 INTEGER 6

For Container Type, add a number based on the following key:

1=Above ground Tank; 2=Below Ground Tank; 3=Tank inside building; 4= Steel drum;

5=Plastic drum; 6=Can; 7=Carboy; 8=Silo; 9=Fiber drum; 10=Bag; 11=Box; 12=Cylinder; 13= Glass bottles or jugs; 14=Plastic bottles or jugs; 15=Tote bin; 16=Tank wagon; 17=Rail car;

18=Other