Touchstone Re 2022 Database Reference
tLossAnalysisOption Table
AIRProject Database : tLossAnalysisOption Table
Description

Stores some of the options used during aggregate loss analyses. Touchstone Re stores additional options in tAggregateLossAnalysisOption Table.

Columns that do not apply to Touchstone Re have values of null.

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

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.

int4   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

int4   
 EventSetSID

Unique system-generated sequential identifier for the event set record.

For a complete list of records, see tReinsuranceEventSet Table.

int4   
 EventFilterXML expression for the filter applied on an event during a Loss analysis. Used internally by Touchstone.xml0  
 ProgramSID

Unique system-generated sequential identifier for the reinsurance program record.

For a complete list of records, see tReinsuranceProgram Table.

int4  
 FacultativeOptionCode

Code that represents how the facultative option is applied.

varchar10  
 CATFinancialPerspectiveCode

Code that represents the financial perspectives.

For a complete list of codes, see tFinancialPerspective Table. 

varchar10  
 OutputTypeCode

Code that represents the type of output generated during the analysis.

varchar10   
 OutputDetailedAALCode

Code that represents the type of AAL summary that was output for the analysis.

varchar10  
 GeoLevelCode

Code that represents the geographic level.

For a complete list of codes, see tGeoLevel Table.

varchar10  
 OutputGroupByCode

Code that represents the group in which the output is organized.

varchar10  
 AveragePropertyOptionCode

Indicates whether the average properties option was enabled. When ‘On’, the data is analyzed at a coarser geographic resolution.

varchar10  
 ApplyDisaggregation

Indicates whether disaggregation is used on aggregate location data.

  • 1 = Yes (disaggregate)
  • 0 = No (no disaggregation)
bit1 
((0))
 
 ApplyDeductibleBeforeLimit

Indicates whether location terms are applied in residential contracts.

  • 1 = Yes (applied)
  • 0 = No (not applied)
bit1 
((0))
 
 RemapConstructionOccupancy

Indicates whether invalid construction/occupancy combination are ignored or mapped to the default combinations

  • 1 = Yes (mapped to defaults)
  • 0 = No (ignored)
bit1 
((1))
 
 EnableCorrelation

Indicates whether correlation is enabled.

  • 1 = Yes
  • 0 = No
bit1 
((0))
 
 DemandSurgeOptionCode

Code that represents how demand surge was applied.

varchar10   
 MoveMarineCraftGeocodesToCoast

Indicates whether the marine craft geocodes are moved to the coastline during a loss analysis. 

  • 1 = Yes (moved)
  • 0 = No (not moved)
bit1 
((1))
 
 SaveGroundUp

Indicates whether Ground-Up loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveRetained

Indicates whether Retained loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SavePreLayerGross

Indicates whether Pre-Layer Gross loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveGross

Indicates whether Gross loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveNetOfPreCAT

Indicates whether Net-of-Pre loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SavePostCATNet

Indicates whether Net-of-Post loss results are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveCoverage

Indicates whether coverage data for a given financial perspective is saved. For example, when Ground-Up is selected and coverage option is chosen, the resultant table would include Ground-Up loss for Coverage A, Coverage B , Coverage C, and Coverage D.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveInjuryReserved for future use.bit1 
((0))
 
 SaveClaims

Indicates whether claims count is saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveMAOL

Indicates whether Maximum Any One Life terms are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 MAOLMinorMedical Minor (Limit 1) term applied during the analysis when SaveMAOL is saved.float9  
 MAOLModerateMedical Moderate (Limit 2) term applied during the analysis when SaveMAOL is saved.float9  
 MAOLMajorMedical Major (Limit 3) term applied during the analysis when SaveMAOL is saved.float9  
 MAOLFatalMedical Fatal (Limit 4) term applied during the analysis when SaveMAOL is saved.float9  
 EP1Value for the first point on the exceedance probability curve.float9   
 EP2Value for the second point on the exceedance probability curve.float9   
 EP3Value for the third point on the exceedance probability curve.float9   
 EP4Value for the fourth point on the exceedance probability curve.float9   
 EP5Value for the fifth point on the exceedance probability curve.float9   
 EP6Value for the sixth point on the exceedance probability curve.float9   
 EP7Value for the seventh point on the exceedance probability curve.float9  
 EP8Value for the eighth point on the exceedance probability curve.float9  
 EP9Value for the ninth point on the exceedance probability curve.float9  
 EP10Value for the tenth point on the exceedance probability curve.float9  
 UncPercentile1Boundaries used to create the uncertainty curve, represents the upper range of the confidence level. The default is 5.00%.real4   
 UncPercentile2Boundaries used to create the uncertainty curve, , represents the lower range of the confidence level. The default is 95.00%.real4   
 UncIntraPolicyCorrelationFactorDefault percentage of correlation between locations within a contract.real4   
 UncInterPolicyCorrelationFactorDefault percentage of correlation between contracts in a portfolio.real4   
 OilPriceDefault oil price, as extracted from tDefaultLossAnalysisOption Table.float9   
 OilPriceUnitCode

Code for the unit of measure used to express the price of the oil.

For a complete list of codes, see tUnit Table.

varchar10   
 GasPriceGas price used during the analysis for the AIR Hurricane Model for Offshore Assets.float9   
 GasPriceUnitCode

Code for the unit of measure used to express the price of the gas.

For a complete list of codes, see tUnit Table.

varchar10   
 EP11Value for the eleventh point on the exceedance probability curve.float9  
 EP12Value for the twelfth point on the exceedance probability curve.float9  
 EP13Value for the thirteenth point on the exceedance probability curve.float9  
 EP14Value for the fourteenth point on the exceedance probability curve.float9  
 EP15Value for the fifteenth point on the exceedance probability curve.float9  
 LossModOption

XML string that defines the loss modification option.  Used internally by Touchstone.

xml0  
 LossModTemplateSID

Unique system-generated sequential identifier for the Touchstone loss modification template. 

int4  
 LossModTemplateHashReserved for future use.decimal9 (38,0)  
 RowVersionUsed for version stamping.timestamp8   
 BaseAnalysisSID

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.

int4  
 ComponentCode

Code that represents the component/model used during the analysis.

varchar10  
 SaveSummaryByPeril

Indicates whether a summary of losses by peril were saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveSummaryByModel

Indicates whether a summary of losses by model were saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveZone

Indicates whether losses were saved by zone.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 IsPreviousVersionModel

Not used by Touchstone Re.

bit1 
((0))
 
 IsSelectedVulnerabilitySet

Indicates whether the vulnerability set is selected for the loss analysis.

  • 1 = Yes (Vulnerability Set selected)
  • 0 = No ( Not selected)
bit1 
((0))
 
 MinMaxLogicCodeCode that represents the MinMaxLogicCode.varchar3  
 SaveSubPeril

Indicates whether losses were saved by sub peril.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveTreaty

Indicates whether losses were saved by treaty.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 SaveFacultative

Indicates whether losses were saved by facultative program.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 IsSelectedCustomFrequencySet

Indicates whether custom frquency set is selected for the loss analysis.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1 
((0))
 
 IsApplyAIRAnalysis

Indicates whether the AIR Analysis is selected for the loss analysis.

  • 1 = Yes (saved)
  • 0 = No (not saved)
bit1  
Objects that depend on tLossAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tLossAnalysisCustomFrequencySetXref tabletLossAnalysisCustomFrequencySetXrefTableStores the loss analysis information associated with the custom frequency set.3
Objects that tLossAnalysisOption 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

 

 

Verisk Analytics Client Confidential

© 2022. AIR Worldwide is now Extreme Event Solutions. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact Verisk Analytics with questions or comments.