Stores the lines of business supported in Touchstone Re for each country, peril, and exposure type combination.
Touchstone Re 2022 Database Reference
tReinsuranceLOBSpec Table
| Creation Date | 4/7/2017 4:05 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 26712 |
| Data Space Used | 1,192.00 KB |
| Index Space Used | 1,808.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| CountryCode | 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 | | |||
| LOBSpecID | Internal identifier for the LOB. | int | 4 | | |||
| Version | Version of the LOB record. | int | 4 | | |||
| LOBIndexInLOBSpec | Index of the LOB in the internal specification. | int | 4 | | |||
| LOBCode | Code that represents to the LOB. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | | |||
 | SID | Unique system-generated sequential identifier for the LOB record. | int | 4 |