Environment, Safety and Health

Annual Fire Protection Database Data Fields

Table: Site

Column Name	Type	Description
Site_Name	Text	Site Name
Abbrev	Text	Site Abbreviation Character Code
SiteCode	Num	Unique 7 Digit Number assigned to the site
Cso_Name	Text	Secretarial Office
Ops_Name	Text	Operation Office
yrStart	Num	Year the Site start reporting
yrEnd	Num	Year the Site stop reporting
POC	Text	Point Of Contact
POCphone	Text
e-mail	Text
Address1	Text
Address2	Text
PoBoxNo	Text
City	Text
State	Text
ZipCode	Text

Table: DataEvent

SiteCode	Num	Site
LCode	Num	Loss Code
Year	Num	Report Year
ActMechanism	Text	Automatic, Manual, etc
RootCause	Text	Cause of the Fire
Location	Text	Location
Description	Memo	Description of the event
Amount	Num	Dollar Loss Amount
Quantity	Num	Quantity
SysType	Text	System Type, such as Halon 1301, Dry Pipe, etc
LossType	Text	Fire Loss Type, such as Fire/smoke, Leaks, Spills, etc

Table: FireDept

SiteCode	Num	Site
Year	Num	Year
fdStaffCst	Num	Annual Staffing cost
fdEqptCst	Num	Annual Equipment cost
fdMntCst	Num	Annual Maintenance cost
fdMedRespCst	Num	Annual Medical cost
fdTrainCst	Num	Annual Training cost
osSvcsCst	Num	Annual Outside Service cost
fpeCst	Num	Annual Engineering cost
numFireCalls	Num	Number of Fire Calls
numHazMatCalls	Num	Number of HazMat Calls
numOthEmCalls	Num	Number of Other Emergency Calls
numNonEmCalls	Num	Number of Non Emergency Calls
numMedCalls	Memo	Number of Medical Calls
RCNotes	Memo	Notes
SysNotes	Memo	System Notes

Table: Halon

SiteCode	Num	Site
Year	Num	Year
numActive	Num	Number of Systems
amtActive	Num	Active Quantity
amtOffsite	Num
hhamtActive	Num
hhamtInventory	Num
hhamtOffsite	Num

2