Stores the industry line of business data by country used by Touchstone to generate company loss files (CLFs).
Industry LOB data appears in a CLF in the following order: country, peril, and INF version.
Stores the industry line of business data by country used by Touchstone to generate company loss files (CLFs).
Industry LOB data appears in a CLF in the following order: country, peril, and INF version.
| Creation Date | 3/5/2014 4:29 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object | ![]() |
| Published for Replication | ![]() |
| Rows | 3498 |
| Data Space Used | 104.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
| CountryCode | ISO 2-character code for the country. For a complete list of codes, see tCountry Table. | varchar | 15 | |||
| CTPerilSetCode | CATRADER code for the peril set. | int | 4 | |||
| INFVersion | Version of the INF file. | tinyint | 1 | |||
| IndustryLineOfBusinessCode | Code that represent the industry line of business. For a complete list of codes, see tIndustryLineOfBusiness Table. | tinyint | 1 | |||
| IndustryLOBOrder | Column order for the industry line of business CLF file. | tinyint | 1 | ||||
| IsPreviousVersionModel | Indicates whether the industry line of business corresponds to the current or previous version of the AIR models.
| bit | 1 | ((0)) |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
![]() | tCountry | Table | Stores the supported country codes and indicates whether each country is modeled and an offshore location. | 1 |
![]() | tIndustryLineOfBusiness | Table | Stores the possible the industry Line of Business types. | 1 |