Stores relationships between company loss file (CLF) sets and companies.
You can associate a CLF set with a company in two ways:
| Creation Date | 4/11/2022 6:17 PM |
| File Group | PRIMARY |
| Text File Group | PRIMARY |
| 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 | |
|---|---|---|---|---|---|---|---|
 | CompanyLossAssociationSID | Unique system-generated sequential identifier for the CLF set, if the association was created in Touchstone Re. | int | 4 | |||
| CompanyLossSetSID | Unique system-generated sequential identifier for the CLF set, if the association was created in Touchstone. | int | 4 |  | |||
| SqlInstanceSID | Unique system-generated sequential identifier for the SQL instance that stores the CLF set. | int | 4 | | |||
| CompanySID | Unique system-generated sequential identifier for the company associated with the CLF set. For a complete list of records, see tCompany Table. | int | 4 | ||||
| CatalogTypeCode | Numerical code that represents the catalog type associated with the CLF set. For a complete list of codes see tCatalogType Table. | int | 4 | ||||
| ParentCompanyLossAssociationSID | Unique system-generated sequential identifier for the parent CLF set. Touchstone generates multiple CLF sets during an analysis if the analysis includes different catalog types, for example, stochastic and historical. The parent CLF set is the CLF set generated for the stochastic catalog. | int | 4 | | |||
| CompanyLossSetName | Name of the CLF set. | varchar | 255 | ||||
| SqlInstanceName | Name of the SQL instance that stores the CLF set. | varchar | 255 | | |||
| SourceBusinessUnitSID | Unique system-generated sequential identifier for the Touchstone business unit associated with the CLF set. | int | 4 | | |||
| SourceBusinessUnit | Name of the Touchstone business unit associated with the CLF set. | varchar | 255 | | |||
| LossTypeCode | Numerical code that indicates the type of loss in the CLF set. For a complete list of codes, see tLossType Table. | varchar | 10 | | |||
| IsLMSGenerated | Indicates whether Touchstone generated a loss market share.
| bit | 1 | | |||
| LMSComments | Comments about the loss market share. | varchar | 150 | | |||
| Description | User-specified description of the CLF set. | varchar | 16 | | |||
| Comments | User-specified comments about the CLF set. | varchar | 16 | | |||
| CreatedDate | Date and time the CLF set was created. | datetime | 4 | | (getutcdate()) | ||
| AssociatedDate | Date and time the CLF set was associated with a company. | datetime | 4 | | (getutcdate()) | ||
| Author | User that initiated the association. | varchar | 60 | | |||
| IsMultiYearExpanded | Indicates whether the CLF set is associated with an expanded multi-year catalog.
| bit | 1 | ||||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | ||||
| ProjectName | Name of the Touchstone project associated with the CLF set. | varchar | 255 | | |||
| AnalysisName | Name of the analysis that generated the CLF set. | varchar | 255 | | |||
| FinancialPerspectiveCode | Code that represents the financial perspective in the CLF set. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | | |||
| DataSourceName | Name of the Touchstone data source associated with the CLF set. | varchar | 255 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCLFCatalog | Table | Stores metadata about company loss files (CLF). The metadata includes information about the event catalogs associated with each CLF. | 1 |
| tCompanyLossMarketShare | Table | 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. | 1 |
| tReinsuranceProgramTargetXRef | Table | Stores the company loss file (CLF) set or CLF set and exposure set combination specified as the target of each reinsurance program. | 1 |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
| tCompany | Table | Stores information about companies. | 3 |