Stores relationships between company loss file (CLF) sets and companies for CLF sets exported from Touchstone to Touchstone Re.
Touchstone Re 2022 Database Reference
tCompanyLossSet Table
Stores relationships between company loss file (CLF) sets and companies for CLF sets exported from Touchstone to Touchstone Re.
| Creation Date | 4/4/2022 3:03 AM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | CompanyLossSetSID | Unique system-generated sequential identifier for the CLF set. | int | 4 | |||
| CreateDate | Date and time the CLF set was created. | datetime | 4 |  | |||
| IsMultiYearExpanded | Indicates whether the CLF set is associated with an expanded multi-year catalog.
| bit | 1 | ||||
| Comments | User-specified comments about the CLF set. | varchar | 16 | | |||
| ParentCompanyLossSetSID | 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 | | |||
| AnalysisSID | Unique system-generated identifier for the analysis that generated the CLF. You can use the analysis SID and the activity SID to find more information about the CLF. For more information, see tCLEXPORT_NNNN_AAAA Table. | int | 4 | | |||
| ActivitySID | Unique system-generated identifier for the export job. You can use the analysis SID and the activity SID to find more information about the CLF. For more information, see tCLEXPORT_NNNN_AAAA Table. | int | 4 | | |||
| StatusCode | System-provided status code for the record in the table. For a complete list of codes, see tStatus Table. | varchar | 10 | | ('A') |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompanyLossCatalog | Table | Stores metadata about company loss files (CLF) that users exported from Touchstone to Touchstone Re. The metadata includes information about the event catalogs associated with each CLF. | 1 |