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 |
|
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 |
|
|
|
|
File Type | application/msword |
File Title | Annual Fire Protection Database Data Fields |
Author | eXCITE |
Last Modified By | Vinh Le |
File Modified | 2008-10-03 |
File Created | 2008-10-03 |