Stores encoded industry exposure data for the calendar year 2021.
Touchstone Re 2022 Database Reference
TblIndustry2021 Table
Stores encoded industry exposure data for the calendar year 2021.
| Creation Date | 6/20/2021 2:30 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 155323 |
| Data Space Used | 42,552.00 KB |
| Index Space Used | 12,624.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 sub-area (for example, the state) | int | 4 | | |||
| IntAreaLevel4 | Internal identifier for area level 4 | int | 4 | | |||
| IntAreaScheme | Internal area scheme | int | 4 | | |||
| StrCurrency | Currency code | char | 3 | | |||
| IntUnits | Order of magnitude of loss amounts | smallint | 2 | | |||
| IntLOB | Identifier for the line of business | smallint | 2 | |