Stores encoded industry exposure data for calendar year 2019.
Touchstone Re 2022 Database Reference
TblIndustry2019 Table
Stores encoded industry exposure data for calendar year 2019.
| Creation Date | 9/27/2019 11:57 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 155402 |
| Data Space Used | 59,184.00 KB |
| Index Space Used | 16,192.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 | |