Touchstone 4.0 Database Documentation
tEventFilterTerrorismWeaponType Table
Description

Stores information regarding weapon types for the terrorism peril.

Properties
Creation Date1/18/2013 2:22 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows24
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key TerrorismWeaponTypeCode

Code that represents the weapon type.

  • 11 = Portable: 0.25-ton TNT (Conventional)
  • 12 = Car: 0.75-ton TNT (Conventional)
  • 13 = Van: 2.5-ton TNT (Conventional)
  • 14 = Delivery Truck: 6-ton TNT (Conventional)
  • 15 = Large Truck: 25-ton TNT (Conventional)
  • 17 = Small Plane Crash (Conventional)
  • 18 = Large Plane Crash (Conventional)
  • 21 = Sarin Large (Chemical)
  • 22 = Sarin Medium (Chemical)
  • 23 = VX Large (Chemical)
  • 24 = VX Medium (Chemical)
  • 25 = Sarin Small (Chemical)
  • 26 = VX Small (Chemical)
  • 31 = Anthrax Large (Biological)
  • 32 = Anthrax Medium (Biological)
  • 33 = Smallpox Large (Biological)
  • 34 = Smallpox Medium (Biological)
  • 35 = Anthrax Small(Biological)
  • 36 = Smallpox Small (Biological)
  • 41 = Cesium (Radiological)
  • 42 = Cobalt (Radiological
  • 51 = Nuclear Small: 1 kiloton (Nuclear)
  • 52 = Nuclear Medium: 20 kiloton (Nuclear)
  • 53 = Nuclear Large: 50 kiloton (Nuclear)
VarChar10   
 TerrorismWeaponType

Name of the weapon type.

Corresponds to the code in TerrorismWeaponTypeCode.

VarChar40  
 TerrorismWeaponCategory

Category for the weapon type.

Corresponds to the code in TerrorismWeaponTypeCode.

VarChar255  
 DescriptionDescription of the weapon.VarChar1024  
See Also

Related Objects

AIRReference Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.