Stores loss market share information for company loss file (CLF) sets exported from Touchstone to Touchstone Re.
A loss market share represents a given company’s share of industry-wide losses.
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 0 |
| Data Space Used | 0.00 KB |
| Index Space Used | 0.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CompanyLossMarketShareSID | Unique system-generated sequential identifier for the loss market share. | int | 4 | |||
| CompanyLossAssociationSID | Unique system-generated sequential identifier for the company loss file (CLF) set associated with the loss market share. For a complete list of records, see tCompanyLossAssociation Table. | int | 4 | ||||
| PerilSetCode | Numeric code for the single peril or set of perils associated with the CLF. For a complete list of codes, see tPerilSet Table. | int | 4 | ||||
| YearID | Identifier for the year associated with the loss market share. | smallint | 2 | ||||
| ModelVersion | Version of the AIR model associated with the loss market share. | varchar | 50 | ||||
| ModelCode | Code that represents the model in Touchstone associated with the loss market share. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| GeographySID | Unique system-generated sequential identifier for the geographic record associated with the loss market share. For a complete list of records, see tGeography Table. | int | 4 |  | |||
| CurrencyCode | ISO 3-character code for the currency associated with the loss market share. For a complete list of codes, see tCurrency Table. | char | 3 | | |||
| LOBCode | Numeric code for the line of business associated with the loss market share. For a complete list of codes, see tReinsuranceLOB Table. | int | 4 | | |||
| IsDemandSurgeAdjFactor | Indicates whether the application computed the loss market share using a user-specified demand surge adjustment factor.
| bit | 1 | | |||
| LossMarketShare | Loss market share value. | float | 9 | | |||
| CountrySID | Unique system-generated sequential identifier for the country associated with the loss market share. For a complete list of records, see tGeography Table. | int | 4 | | |||
| CountryCode | ISO 2-character code for the country associated with the loss market share. | varchar | 15 | | |||
| CountryName | Name of the country associated with the loss market share. | varchar | 255 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompany | Table | Stores information about companies. | 3 |
| tCompanyLossAssociation | Table | Stores relationships between company loss file (CLF) sets and companies. You can associate a CLF set with a company in two ways:
| 1 |