Touchstone 4.0 Database Documentation
tDefaultLossAnalysisOption Table
Description

Stores the default Loss analysis options. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used56.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DefaultLossAnalysisOptionSIDUnique system-generated sequential identifier for the default loss analysis options record.Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 EP1Value for the first point on the exceedance probability curve.Double9  
 EP2Value for the second point on the exceedance probability curve.Double9  
 EP3Value for the third point on the exceedance probability curve.Double9  
 EP4Value for the fourth point on the exceedance probability curve.Double9  
 EP5Value for the fifth point on the exceedance probability curve.Double9  
 EP6Value for the sixth point on the exceedance probability curve.Double9  
 EP7Value for the seventh point on the exceedance probability curve.Double9  
 EP8Value for the eighth point on the exceedance probability curve.Double9  
 EP9Value for the ninth point on the exceedance probability curve.Double9  
 EP10Value for the tenth point on the exceedance probability curve.Double9  
 DisplayEPReturnPeriod

Indicates whether the results are to be displayed by return period. 

  • 1 = Yes
  • 0 = No
Boolean1 
((1))
 
 OilPriceDefault oil price, used for the offshore drilling industry.Double9   
 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   
 GasPriceDefault gas price, used for the offshore drilling industry.Double9   
 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   
 UncPercentile1Boundaries used to create the uncertainty curve, represents the upper range of the confidence level. The default is 5.00%.Single4   
 UncPercentile2Boundaries used to create the uncertainty curve, , represents the lower range of the confidence level. The default is 95.00%.Single4   
 UncIntraPolicyCorrelationFactorDefault percentage of correlation between locations within a contract.Single4   
 UncInterPolicyCorrelationFactorDefault percentage of correlation between contracts in a portfolio.Single4   
 MoveMarineCraftGeocodesToCoast

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

  • 1 = Yes (moved)
  • 0 = No (not moved)
Boolean1   
 EP11Value for the eleventh point on the exceedance probability curve.Double9  
 EP12Value for the twelfth point on the exceedance probability curve.Double9  
 EP13Value for the thirteenth point on the exceedance probability curve.Double9  
 EP14Value for the fourteenth point on the exceedance probability curve.Double9  
 EP15Value for the fifteenth point on the exceedance probability curve.Double9  
Objects that depend on tDefaultLossAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tForestryLandPrice tabletForestryLandPriceTable

Stores information about the per-hectare unit price for forestry land in Finland, Norway, and Sweden. 

1
See Also

Related Objects

AIRUserSetting Database

 

 


AIR Client Confidential

© 2016. AIR Worldwide is a registered trademark. Touchstone is a registered trademark of AIR Worldwide.

Please contact AIR Worldwide with questions or comments. For database questions. For documentation comments.