Touchstone 4.0 Database Documentation
tLossAnalysisOption Table
Description
Stores information regarding the options selected for a Loss analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows4
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.

Integer4   
 PerilSetCode

Numeric code for the single peril or set of perils.

For a complete list of codes, see tPerilSet Table.

Integer4   
 EventSetSID

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

For a complete list of records, see tEventSet Table.

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

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

For a complete list of records, see tProgram Table.

Integer4  
 FacultativeOptionCode

Code that represents how the facultative option is applied.

For a complete list of codes, see tFacultativeOption Table.

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.

For a complete list of codes, see tOutputType Table.

VarChar10   
 OutputDetailedAALCode

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

For a complete list of codes, see tOutputDetailedAAL Table.

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.

For a complete list of codes, see tOutputGroupBy Table.

VarChar10  
 AveragePropertyOptionCode

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

For a complete list of codes, see tAveragePropertyOption Table.

VarChar10  
 ApplyDisaggregation

Indicates whether disaggregation is used on aggregate location data.

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

Indicates whether location terms are applied in residential contracts.

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

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

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

Indicates whether correlation is enabled.

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

Indicates whether demand surge is used.

  • 1 = Yes
  • 0 = No
VarChar10   
 MoveMarineCraftGeocodesToCoast

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

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

Indicates whether Ground-Up loss results are saved.

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

Indicates whether Retained loss results are saved.

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

Indicates whether Pre-Layer Gross loss results are saved.

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

Indicates whether Gross loss results are saved.

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

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

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

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

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((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)
Boolean1 
((0))
 
 SaveInjuryReserved for future use.Boolean1 
((0))
 
 SaveClaims

Indicates whether claims count is saved.

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

Indicates whether Maximum Any One Life terms are saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 MAOLMinorMedical Minor (Limit 1) term applied during the analysis when SaveMAOL is saved.Double9  
 MAOLModerateMedical Moderate (Limit 2) term applied during the analysis when SaveMAOL is saved.Double9  
 MAOLMajorMedical Major (Limit 3) term applied during the analysis when SaveMAOL is saved.Double9  
 MAOLFatalMedical Fatal (Limit 4) term applied during the analysis when SaveMAOL is saved.Double9  
 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  
 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   
 OilPriceDefault oil price, as extracted from tDefaultLossAnalysisOption Table.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 oil price, as extracted from tDefaultLossAnalysisOption Table.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   
 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  
 LossModOption

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

Xml16  
 LossModTemplateSID

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

For a complete list of records, see  tLossModTemplate Table.

Integer4  
 LossModTemplateHashReserved for future use.Numeric9 (38,0)  
 RowVersionUsed for version stamping.Binary8   
 BaseAnalysisSID

Unique system-generated sequential identifier for the analysis record.

For a complete list of records, see tAnalysis Table.

Integer4  
 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)
Boolean1 
((0))
 
 SaveSummaryByModel

Indicates whether a summary of losses by model were saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_SGROSS_TLRES 
([SaveGross]>=(0) AND [SaveGross]<=(1))
CKC_SGROUNDUP_TLRES 
([SaveGroundUp]>=(0) AND [SaveGroundUp]<=(1))
CKC_SNETOFPRECAT_TLRES 
([SaveNetOfPreCAT]>=(0) AND [SaveNetOfPreCAT]<=(1))
CKC_SPOSTCATNET_TLRES 
([SavePostCATNet]>=(0) AND [SavePostCATNet]<=(1))
CKC_SPRELAYERGROSS_TLRES 
([SavePreLayerGross]>=(0) AND [SavePreLayerGross]<=(1))
CKC_SRETAINED_TLRES 
([SaveRetained]>=(0) AND [SaveRetained]<=(1))
Objects that depend on tLossAnalysisOption
 Database ObjectObject TypeDescriptionDep Level
tLossAnalysisDemandSurgeOption tabletLossAnalysisDemandSurgeOptionTableStores information regarding the demand surge, by area, used during a Loss analysis.3
tLossAnalysisFloodOption tabletLossAnalysisFloodOptionTableStores information regarding the custom flood zones used during a Loss analysis.3
tLossAnalysisPerilSetULOBOption tabletLossAnalysisPerilSetULOBOptionTableStores information regarding the perils and Lines of Business analyzed during the Loss analysis. In addition, it also identifies the percentage of the loss from storm surge or precipitation flood, when applicable.3
tLossAnalysisSTStormOption tabletLossAnalysisSTStormOptionTableStores information regarding the severe storm options using during a Loss analysis.3
tLossAnalysisTerrorismOption tabletLossAnalysisTerrorismOptionTableStores information regarding the terrorism options used during a Loss analysis.3
Objects that tLossAnalysisOption depends on
 Database ObjectObject TypeDescriptionDep Level
tAnalysis tabletAnalysisTableStores information about each sub-section of the activity output. Each activity task creates and writes to this table as the task is performed.1
tDataServer tabletDataServerTableStores information about each data server used in the project, including its sequential identifier (SID), name, description, connection information, and default MDF and LDF paths.3
tDataSource tabletDataSourceTableStores information about the data source used for the Touchstone project. A data source is a database that is registered with the Touchstone application.2
tProject tabletProjectTableStores information regarding the project, such as project name and status code.1
See Also

Related Objects

AIRProject 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.