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.
| Creation Date | 4/4/2022 3:02 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 | |
|---|---|---|---|---|---|---|---|
 | EventBasedAdjFactorSetSID | Unique system-generated sequential identifier for the set of event-based adjustment factors. | int | 4 | |||
| Name | Name of the set of event-based adjustment factors. | nvarchar | 255 | ||||
| Description | Description of the set of event-based adjustment factors. | nvarchar | 4000 |  | |||
| FolderPath | Path to the location that includes the comma-separated values (CSV) files associated with the set of event-based adjustment factors. Each file includes factors for one model. | nvarchar | 16 | ||||
| EnteredDate | Date and time that the set of event-based adjustment factors was created. | datetime2 | 4 | (sysdatetime()) | |||
| EditedDate | Date and time that the set of set of event-based adjustment factors was last edited. | datetime2 | 4 | (sysdatetime()) | |||
| StatusCode | System-provided status for the event-based adjustment factor set record. For a complete list of code, see tStatus Table. | varchar | 10 | | ([dbo].[fCalcEbafSetStatusCode]([EventBasedAdjFactorSetSID])) |
| 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 |
| 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 |
| tReinsuranceCatalog | Table | Stores information about the event catalogs that are available in Touchstone Re, including event catalogs for custom (user-defined) models.
You must license Custom Models and LOBs to use the custom models feature.
| 1 |