Touchstone Re 2022 Database Reference
tEventFilterTerrorismWeaponType Table
AIRReference Database : 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
Rows25
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

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 = Small Truck: 6-ton TNT (Conventional)
  • 15 = Large Truck: 25-ton TNT (Conventional)
  • 17 = Small Plane Crash (Conventional)
  • 18 = Large Plane Crash (Conventional)
  • 19 = Medium Truck: 10-ton TNT (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   
 

Name of the weapon type.

Corresponds to the code in TerrorismWeaponTypeCode.

varchar40  
 

Category for the weapon type.

Corresponds to the code in TerrorismWeaponTypeCode.

varchar255  
 Description of the weapon.varchar1024  
See Also

Related Objects

AIRReference Database