Stores mapping between lines of business (LOBs) supported in Touchstone Re and LOBs supported in AIR's Industry Exposure Database.
Touchstone Re 2022 Database Reference
tReinsuranceExposureToIndustryLOBMap Table
| Creation Date | 1/2/2018 10:52 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 13630 |
| Data Space Used | 1,232.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | LobMapSID | Unique system-generated sequential identifier for the mapping record. | int | 4 | |||
| CountryID | Identifier for the country associated with the LOB. For a complete list of codes, refer to the UNICEDE/2 documentation. | int | 4 | ||||
| PerilID | Identifier for the peril associated with the LOB. For a complete list of codes, see tPeril Table. | int | 4 | ||||
| ExposureTypeID | Identifier for the type of exposure associated with the LOB. | int | 4 | ||||
| ExposureLOBCode | Code that represents the LOB in Touchstone Re. | int | 4 | ||||
| IndustryLOBCode | Code that represents the LOB in AIR's Industry Exposure Database. For a complete list of codes, see tIndustryLineOfBusiness Table. | int | 4 | ||||
| IndustryLOBIndex | Index of the LOB in AIR's Industry Exposure Database. | int | 4 | ||||
| LOBSpecID | Internal identifier for the LOB. | int | 4 | ||||
| Version | Version of the LOB mapping. | int | 4 | ||||
| IEDToDBExport | Indicates whether the user selected to export industry exposure data (IED) to database (DB).
| bit | 1 |  | ((1)) |