Touchstone Re 2022 Database Reference
tEventBasedAdjFactorFile Table
AIRUserSetting Database : tEventBasedAdjFactorFile Table
Description

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.

Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Unique system-generated sequential identifier for the set of event-based adjustment factors associated with the file.

For a complete list of records, see tEventBasedAdjFactorSet Table.

int4   
Primary Key 

Unique system-generated sequential identifier for the event catalog associated file.

For a complete list of records, see tReinsuranceCatalog Table.

int4   
Primary Key 

Code that represents the type of the file.

For a complete list of codes, see tFileType Table.

varchar10   
 

System-provided status for the file record.

For a complete list of code, see tStatus Table.

varchar10   
 Name of the file.varchar255  
 Date and time that the file was created.datetime24 
(sysdatetime())
 
 Date and time that the file was last updated.datetime24 
(sysdatetime())
 
Objects that depend on tEventBasedAdjFactorFile
 Database ObjectObject TypeDescriptionDep Level
tEventBasedAdjFactorSet tabletEventBasedAdjFactorSetTable

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
Objects that tEventBasedAdjFactorFile depends on
 Database ObjectObject TypeDescriptionDep Level
tEventBasedAdjFactorSet tabletEventBasedAdjFactorSetTable

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
tReinsuranceCatalog tabletReinsuranceCatalogTable

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
See Also

Related Objects

AIRUserSetting Database