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.
| Creation Date | 4/4/2022 3:03 AM |
| 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 | |
|---|---|---|---|---|---|---|---|
 | CompanyLossCatalogSID | Unique system-generated sequential identifier for the company loss file (CLF) metadata record. | int | 4 | |||
| CompanyLossSetSID |
Unique system-generated sequential identifier for the CLF set associated with the CLF. For a complete list of records, see tCompanyLossSet Table. | int | 4 | ||||
| CompanyLossTypeCode | Code that represents the type of the CLF:
| smallint | 2 | ||||
| ModelVersion | Version number of the model associated with the CLF. | varchar | 50 | ||||
| ModelCode | Code that represents the model in Touchstone associated with the CLF. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| YearMax | Maximum number of simulated years in the catalog associated with the CLF. | int | 4 | ||||
| YearCount | Total number of simulated years in the catalog. | int | 4 | ||||
| EventMax | Maximum number of simulated events in the catalog. | int | 4 | ||||
| EventCount | Total number of simulated events in the catalog. | 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 | ||||
| DemandSurge | Indicates whether demand surge was enabled during the analysis that generated the CLF.
| smallint | 2 | ||||
| OilPrice | Default oil price used during the analysis from tDefaultLossAnalysisOption Table. | float | 9 | ||||
| CurrencyCode | ISO 3-character code for the currency. For a complete list of codes, see tCurrency Table. | varchar | 3 |  | |||
| IsModified | Indicates whether the CLF was modified.
| bit | 1 | | |||
| FinancialPerspectiveCode | Code that represents the financial perspective of the losses. For a complete list of codes, see tFinancialPerspective Table. | varchar | 10 | | |||
| TableName | Name of the table that stores the details of the CLF. For more information, see tCLEXPORT_NNNN_AAAA Table. | varchar | 50 | | |||
| AreaDetail | Code that represents the area associated with the company loss file. This can be at:
| smallint | 2 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tCompanyLossSet | Table | Stores relationships between company loss file (CLF) sets and companies for CLF sets exported from Touchstone to Touchstone Re. | 1 |