Stores metadata about company loss files (CLF).
The metadata includes information about the event catalogs associated with each CLF.
Touchstone Re 2022 Database Reference
tCLFCatalog Table
Stores metadata about company loss files (CLF).
The metadata includes information about the event catalogs associated with each CLF.
| 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 | |
|---|---|---|---|---|---|---|---|
 | CLFCatalogSID | Unique system-generated sequential identifier for the company loss file (CLF) metadata record. | int | 4 | |||
| CompanyLossAssociationSID | Unique system-generated sequential identifier for the CLF set associated with the CLF. For a complete list of records, see tCompanyLossAssociation Table. | int | 4 | ||||
| CLFTypeCode | Code that represents the type of the CLF:
| smallint | 2 | ||||
| CLFVersion | Version number of the CLF. | varchar | 30 | ||||
| ModelVersion | Version number of the model associated with the CLF. | varchar | 30 | ||||
| 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 | ||||
| BaseName | Formatted name of the catalog. | varchar | 255 | ||||
| LossFileExt | Loss file extension. | varchar | 10 | ||||
| CLFSubTypeCode | Code that represents the subtype of the CLF. For a complete list of codes, see tCLFSubType Table. | smallint | 2 | ||||
| AreaDetail | Code that represents the geographic resolution that generated the losses in the CLF.
| smallint | 2 | ||||
| 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 | Code that indicates whether demand surge was applied in the CLF.
If the value is 0, review the IsDemandSurgeOn column in tReinsuranceProgram Table. | smallint | 2 | ||||
| GlobalAdjFacts | Global adjustment factor in the CLF. | smallint | 2 | ||||
| OilPrice | Oil price in the CLF. | float | 9 | ||||
| CurrencyCode | ISO 3-character code for the currency in the CLF. For a complete list of codes, see tCurrency Table. | varchar | 3 |  |
| 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 |