Touchstone 4.0 Database Documentation
tRRRR_LOSS_DimEvent Table
Description
Stores information about a terrorism event  that experiences loss during a loss analysis. This dimension table is created when losses are saved by "Event".
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key EventIDUnique system-provided identifier of the event that produced the loss.Integer4   
 EventNameName of the event.VarChar1000   
 AddressAddress for where the event occurred.VarChar255  
 CityCity where the event occurred.VarChar255  
 CountryCode

ISO 2-character code for the country in which the location resides. 

For a complete list of codes, see tCountry Table.

VarChar15   
 CRESTACode

CRESTA code for the location, when applicable. If CRESTA is not applicable for this country,use the AreaCode column.

For a complete list of codes, see tGeography Table.

VarChar15   
 AreaCode

Area code for where the event occurred.

For a complete list of codes, see tGeography Table.

VarChar15   
 SubAreaCode

Subarea code for where the event occurred.

For a complete list of codes, see tGeography Table.

VarChar15   
 PostalCodePostal code for where the event occurred.VarChar15  
 LatitudeLatitude coordinate for where the event occurred.  Values will be positive for locations north of the equator and negative south of the equator.Numeric9 (9,6)   
 LongitudeLongitude coordinate for where the event occurred.  Values will be negative for locations west of the prime meridian up to the international date line. They will be positive for locations east of the prime meridian.Numeric9 (9,6)   
 TerrorismWeaponTypeCode

Code that represents the weapon type used in a terrorism event.

For a complete list of codes, see tEventFilterTerrorismWeaponType Table.

VarChar10  
 TerrorismWeaponTypeName of the weapon type.VarChar40  
 StoriesTotal number of stories in the building.SmallInt2  
 LandmarkSID

Unique system-generated sequential identifier for the landmark record.

For a complete list of records, see TblProminentLandmarks Table.

Integer4  
 LandmarkName of the landmark.VarChar255  
See Also

Related Objects

AIRExposureSummary 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.