Spill Database Structure Field Name Type Width Decimal --------------------------------------------------- 1 SPILL_ID Character 8 2 SITE_ID Character 6 3 SPILL_NAME Character 30 4 ADDRESS Character 30 5 TOWN Character 20 6 HALF_TOWN Character 12 7 COUNTY Character 10 8 REGION Character 1 9 ZIP Character 10 10 STAFF_LEAD Character 25 11 FIRST_DATE Date 8 12 LAST_DATE Date 8 13 TOP_DATE Date 8 14 SPILL_DATE Date 8 15 RPORT_DATE Date 8 16 SPILL_TIME Character 7 17 RPORT_TIME Character 7 18 FISC_YEAR Character 2 19 CASE_CLOSE Character 3 20 PET_HAZARD Character 10 21 VIRG_WASTE Character 6 22 SOIL_CNTAM Character 3 23 ENV_IMPACT Character 15 24 O_ENV_IMPT Character 15 25 MATERIAL Character 25 26 CAS_NO Character 10 27 O_MATERIAL Character 25 28 PCB_LEVEL Character 10 29 QUAN_RPTD Character 11 30 QUAN_ACTL Character 11 31 UNITS_RPTD Character 10 32 UNITS_ACTL Character 10 33 SOURCE Character 15 34 O_SOURCE Character 15 35 INCIDENT Character 15 36 O_INCIDENT Character 15 37 TYPE_CLEAN Character 13 38 CONTRACTOR Character 20 39 SA_REFERAL Character 3 40 NOTIFIER Character 40 41 NOTIF_PHON Character 14 42 LUST Character 3 43 PREP_REP Character 20 44 LUST_ED Character 3 45 CATEGORY Character 5 46 DYS_TO_CLS Numeric 15 0 Description of Spill Fields Field Name Type Length Key Options Description ------------------------------------------------------------------ ADDRESS C 30 0 Spill address. CASE_CLOSE C 3 0 YES/NO Is case open or closed? CAS_NO C 10 0 CAS # for hazardous waste. CATEGORY C 5 0 Region Specific code. CONTRACTOR C 20 0 List State clean-up contractor, if used. COUNTY C 10 0 List Spill county. DYS_TO_CLS N 15 0 Number of days it takes for a case to close. ENV_IMPACT C 15 0 List Environmental Impact of the spill. FIRST_DATE D 8 0 First date spill information was entered. FISC_YEAR C 2 0 Not Used HALF_TOWN C 12 0 List Village (not legal town) e.g. Roxbury. INCIDENT C 15 0 List How material spilled. LAST_DATE C 8 0 Last date spill information was entered. LUST C 3 0 YES/NO Is a spill Federal LUST eligible? LUST_ED C 3 0 YES/NO Not Used. MATERIAL C 25 0 List Spilled material. NOTIF_PHON C 14 0 Phone number of notifier. NOTIFIER C 25 0 Person that first notified DEP. O_ENV_IMPT C 15 0 An environmental impact other than one on the list. O_INCIDENT C 15 0 An incident other than one on the list. O_MATERIAL C 25 0 A material other than one on the list. O_SOURCE C 15 0 A source other than one on the list. PCB_LEVEL C 10 0 List List of PCB ranges by PPM PET_HAZARD C 10 0 List Was material spilled either petroleum or hazardous waste PREP_REP C 20 0 Person who prepared report. QUAN_ACTL C 11 0 List Range of actual quantity spilled. QUAN_RPTD C 11 0 List Range of reported quantity spilled. REGION C 1 0 Not Used. RPORT_DATE D 8 0 Date spill first reported. RPORT_TIME C 7 0 Time spill first reported. SA_REFERAL C 3 0 List Referral divisions. SITE_ID C 6 0 Site ID number, if applicable. SOIL_CNTAM C 3 0 YES/NO Contaminated soil. SOURCE C 15 0 List Possible sources of spill. SPILL_DATE D 8 0 Date spill occurred. SPILL_ID C 8 1 Spill ID number. SPILL_NAME C 30 2 Spill name. SPILL_TIME C 7 0 Time spill occurred. STAFF_LEAD C 25 0 List First staff lead for spill. TOP_DATE D 8 0 Date of first IR form for spill (first response). TOWN C 20 0 List Official Town TYPE_CLEAN C 13 0 Not Used. UNITS_ACTL C 10 0 List Actual Units Spilled. UNITS_RPTD C 10 0 List Reported Units Spilled. VIRG_WASTE C 6 0 List Was material spilled virgin or waste? ZIP C 10 0 Zip Code. 8-Jan-98