Stores encoded industry exposure data for calendar year 2017.
Touchstone Re 2022 Database Reference
TblIndustry2017 Table
| Creation Date | 1/28/2019 2:14 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 155354 |
| Data Space Used | 29,824.00 KB |
| Index Space Used | 13,944.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | guidIndustry | Globally unique identifier (GUID) for the industry. | binary | 16 | |||
| binKey | Encoded key. | binary | 18 | ||||
| binData | Encoded data. | varbinary | 288 | ||||
| IntPeril | Internal identifier for the peril. | int | 4 |  | |||
| IntType | Internal identifier for the type. | int | 4 | | |||
| IntYear | Internal identifier for the year. | int | 4 | | |||
| IntAreaLevel1 | Internal Identifier for the country. | int | 4 | | |||
| IntAreaLevel2 | Internal identifier for the area (for example, the state). | int | 4 | | |||
| IntAreaLevel3 | Internal identifier for the subarea (for example, the county). | int | 4 | | |||
| IntAreaLevel4 | Internal identifier for area level 4. | int | 4 | | |||
| IntAreaScheme | Internal area scheme. | int | 4 | | |||
| StrCurrency | Code for the currency. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| IntUnits | Order of magnitude of loss amounts. For a complete list of codes, see tCurrencyUnit Table. | smallint | 2 | | |||
| IntLOB | Identifier for the line of business. | smallint | 2 | |