Touchstone Re 2022 Database Reference
tAggregateLossAnalysisOption Table
AIRProject Database : tAggregateLossAnalysisOption Table
Description
Stores information about the options specified for each loss analysis.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows4
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key Unique system-generated sequential identifier for the analysis record.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  
 

Reserved for future use.

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 (include)
  • 0 = No (do not include)
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  
 

Code that indicates whether the analysis included user-specified EP adjustments to program losses.

For a complete list of codes, see tAggregateAnalysisPLAFlag Table.

You must license program loss adjustments to use the program loss adjustments feature.
varchar10  
 

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

For a complete list of records, see tEventBasedAdjFactorSet Table.

You must license event-based adjustment factors to use the event-based adjustment factors feature.
int4  
 

Indicates whether the analysis included additional events in the event catalog to account for increased seismicity beyond the historical average.

  • 1 = Yes (include)
  • 0 = No (do not include)

Increased seismicity is supported only for New Zealand.

bit1  
 

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.

tinyint1
((0))
 
 Indicates whether the user selected the option to include custom LOBs, exclude custom LOBs, or include program-specific custom LOBs.bit1
((0))
 
  varchar8000  
Objects that depend on tAggregateLossAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tAggregateAnalysisTerrorismOption tabletAggregateAnalysisTerrorismOptionTableStores information about the terrorism option specified for each loss analysis.1
Objects that tAggregateLossAnalysisOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each analysis.1
tExposureSet tabletExposureSetTableStores exposure set information from each exposure database on the server.3
See Also

Related Objects

AIRProject Database