Stores information about the event catalogs that are available in Touchstone Re, including event catalogs for custom (user-defined) models.
| Creation Date | 4/4/2022 3:02 AM |
| File Group | PRIMARY |
| Text File Group | |
| System Object |  |
| Published for Replication | |
| Rows | 336 |
| Data Space Used | 64.00 KB |
| Index Space Used | 16.00 KB |
| Column Name | Description | Datatype | Length | Allow Nulls | Default | Formula | |
|---|---|---|---|---|---|---|---|
 | CatalogSID | Unique system-generated sequential identifier for the catalog record. | int | 4 | |||
| BusinessUnitSID | Unique system-generated sequential identifier for the business unit associated with the catalog. | int | 4 | ||||
| CatalogTypeCode | Code that represents the type of the catalog.
| smallint | 2 |  | |||
| ReinsuranceCatalogName | Name of the catalog. | varchar | 100 | ||||
| Version | Version number of the catalog. | varchar | 20 | ||||
| ModelCode | Code that represents the model associated with the catalog. For a complete list of codes, see tModel Table. | smallint | 2 | ||||
| ModelVersion | Version number of the model. | varchar | 20 | ||||
| YearMax | Maximum number of years in the catalog. | 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 | Type of loss file associated with the catalog. | varchar | 10 | | |||
| CatalogSubTypeCode | Area resolution of the catalog. | int | 4 | | |||
| PerilSetCode | Numeric code for the peril or set of perils associated with the catalog. For a complete list of codes, see tPerilSet Table. | int | 4 | | |||
| Region | Region associated with the catalog. | varchar | 60 | | |||
| IsCustom | Indicates whether the catalog is a custom catalog.
| bit | 1 | ||||
| DamageFactorFile | Name of the damage factor file associated with the catalog. | varchar | 255 | | |||
| Description | Description of the catalog. | varchar | 255 | | |||
| CurrencyCode | ISO 3-character code for the currency associated with the catalog. For a complete list of codes, see tCurrency Table. | varchar | 3 | | |||
| ISArchived | Indicates whether the catalog is archived.
| bit | 1 | | ((0)) | ||
| CatalogID | Indicates the user-specified catalog identifier associated with custom models. | int | 4 | |
| Database Object | Object Type | Description | Dep Level | |
|---|---|---|---|---|
 | tEventBasedAdjFactorFile | Table | Stores information about the comma-separated values (CSV) files used to specify event-based adjustment factors in the Administration Console. An event-based adjustment factor enables you to adjust ground up modeled loss estimates. You can specify event-based adjustment factors for each event or each combination of event, area, and line of business associated with a given model. You must license event-based adjustment factors to use the event-based adjustment factors feature. | 1 |
| tEventBasedAdjFactorSet | Table | Stores the details of each set of event-based adjustment factors defined in the Administration Console. An event-based adjustment factor enables you to adjust ground up modeled loss estimates. You can specify event-based adjustment factors for each event or each combination of event, area, and line of business associated with a given model. You must license event-based adjustment factors to use the event-based adjustment factors feature. | 3 |
| tReinsuranceEventSetCatalogXRef | Table | System reference table that stores the event catalogs associated with each event set in Touchstone Re, including event sets associated with custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
| 1 |