Stores information about each terrorism event that generated loss during a loss analysis.
Touchstone creates the dimension table for each analysis that included event as an output option.
| Creation Date | 4/11/2022 6:15 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | EventID | Unique system-provided identifier of the event that produced the loss. | int | 4 | |||
| EventName | Name of the event. | varchar | 1000 | ||||
| Address | Address for where the event occurred. | varchar | 255 |  | |||
| City | City where the event occurred. | varchar | 255 | | |||
| CountryCode | ISO 2-character code for the country in which the location resides. For a complete list of codes, see tCountry Table. | varchar | 15 | ||||
| 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. | varchar | 15 | ||||
| AreaCode | Area code for where the event occurred. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| SubAreaCode | Subarea code for where the event occurred. For a complete list of codes, see tGeography Table. | varchar | 15 | ||||
| PostalCode | Postal code for where the event occurred. | varchar | 15 | | |||
| Latitude | Latitude coordinate for where the event occurred. Values will be positive for locations north of the equator and negative south of the equator. | numeric | 9 (9,6) | ||||
| Longitude | Longitude 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. | numeric | 9 (9,6) | ||||
| TerrorismWeaponTypeCode | Code that represents the weapon type used in a terrorism event. For a complete list of codes, see tEventFilterTerrorismWeaponType Table. | varchar | 10 | | |||
| TerrorismWeaponType | Name of the weapon type. | varchar | 40 | | |||
| Stories | Total number of stories in the building. | smallint | 2 | | |||
| LandmarkSID | Unique system-generated sequential identifier for the landmark record. For a complete list of records, see TblProminentLandmarks Table. | int | 4 | | |||
| Landmark | Name of the landmark. | varchar | 255 | |