Touchstone Re 2022 Database Reference
tAggregateLossAnalysisOption Table
AIRResultRe Database : tAggregateLossAnalysisOption Table
Description
Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tLossAnalysisOption Table.
Properties
Creation Date4/11/2022 6:17 PM
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 analysis.

For a complete list of records, see tAnalysis Table.

int4   
 

Unique system-generated sequential identifier for the company associated with the analysis.

For a complete list of records, see tCompany Table.

int4  
 

Code that represents the type of reinsurance treaty associated with the analysis.

For a complete list of codes, see tReinsuranceType Table.

varchar10  
 

Indicates whether the analysis included a multi-year catalog.

Iterations in multi-year catalogs span six years.

  • 1 = Yes (multi-year catalog)
  • 0 = No (standard catalog)
bit1
((0))
 
 

Indicates whether the analysis included historical events.

  • 1 = Yes (historical events included)
  • 0 = No (historical events not included)
bit1
((0))
 
 Year in the exposure set used during the analysis.int4 
((0))
 
 

Indicates whether a user specified a start date as an event filter for the loss analysis.

  • 1 = Yes (start date)
  • 0 = No (no start date)
bit1 
((0))
 
 

Indicates whether a user specified an end date as an event filter for the loss analysis.

  • 1 = Yes (end date)
  • 0 = No (no end date)
bit1 
((0))
 
 User-specified start date to apply as an event filter.date8  
 User-specified end date to apply as an event filter.date8  
 Start date in a multi-year catalog.date8  
 

Indicates whether events that do not meet the event filter criteria but are within the in-force window for the reinsurance program are included in the analysis.

  • 1 = Yes (included)
  • 0 = No (do not included)
bit1  
 

Unique system-generated sequential identifier for the parent loss analysis options.

For a complete list of records, see tLossAnalysisOption Table.

int4  
 

Code that indicates whether the analysis included losses for custom lines of business.

For a complete list of codes, tCustomLOBOption Table.

You must license Custom Models and LOBs to use the custom LOB feature.
varchar10
('PGM')
 
 

Indicates whether the analysis included a global adjustment factor.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1
((0))
 
 

Indicates whether industry losses were computed.

  • 1 = Yes (computed)
  • 0 = No (not computed)
bit1
((0))
 
 

Indicates whether the analysis included all historical events regardless of the event filters.

  • 1 = Yes (all included)
  • 0 = No (filtered)
bit1
((0))
 
 

User-specified adjustment factor for all companies included in the analysis.

float9 
((1))
 
 

Name of the event set included in the analysis.

For a complete list of records, see tReinsuranceEventSet Table.

varchar255  
 Number of years in the catalog used during the analysis.int4  
 

Indicates whether the user selected the option to save the analysis results by reinsurance program.

  • 1 = Yes (saved by program)
  • 0 = No (not saved by program)
bit1  
 

Indicates whether the user selected the option to use the latest Industry Exposure Database (IED).

  • 1 = Yes (uses latest IED)
  • 0 = No (did not use latest IED)
bit1  
 

Numeric code for the single peril or set of perils associated with the analysis.

For a complete list of codes, see tPerilSet Table.

int4  
 

Indicates whether the user selected the option to include previously saved treaty loss results.

After you run a loss analysis, you can optionally upload the results of the analysis to the Analyze Re application, and then use the results to speed up future analyses.

bit1  
 

Unique system-generated sequential identifier for the event-based adjustment factor set included in the analysis.

For a complete list of records, see tEventBasedAdjFactorSet Table.

int4  
 

Indicates whether the analysis included losses for custom lines of business.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1
((0))
 
See Also

Related Objects

AIRResultRe Database