Touchstone 4.0 Database Documentation
tLossAnalysisOption Table
Description
Stores the loss analysis options used to generate the results. This table contains one row for each Loss analysis.
Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ResultSID

Unique system-generated sequential identifier for the results record.

For a complete list of records, see tAnalysisResult 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   
 EventSetName of the set of events simulated by the AIR model.VarChar255   
 EventFilterXML string that defines the filters to be used in selecting events to be analyzed.Xml16  
 ProgramSID

Unique system-generated sequential identifier for the program record.

For a complete list of records, see tProgram Table.

Integer4  
 ProgramIDIdentifier for the reinsurance program, if one was applied in this analysis.VarChar100  
 ProgramDescriptionUser-provided description of the analyzed reinsurance program, if one is to be applied in this analysisVarChar4000  
 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 perspective loss on which CatExcess of loss treaties are applied.

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

Code that 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 was used on aggregate location data.

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

Indicates whether location terms were applied in residential contracts.

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

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

  • 1 = Yes (mapped to defaults)
  • 0 = No (ignored)
Boolean1 
((1))
 
 EnableCorrelationIndicates whether correlation was enabled.
  • 1 = Yes
  • 0 = No
Boolean1 
((0))
 
 DemandSurgeOptionCode

Indicates whether correlation was used.

  • 1 = Yes
  • 0 = No
VarChar10   
 MoveMarineCraftGeocodesToCoast

Indicates whether marine craft geocodes were moved to the coast.

  • 1 = Yes (moved)
  • 0 = No (not moved)
Boolean1 
((1))
 
 SaveGroundUpIndicates whether Ground-Up loss results were saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveRetained

Indicates whether Retained loss results were saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SavePreLayerGrossIndicates whether Pre-Layer Gross loss results were saved.
  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 SaveGross

Indicates whether Gross loss results were 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 were saved.

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

Indicates whether coverage data for a given financial perspective was 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 were saved.

  • 1 = Yes (saved)
  • 0 = No (not saved)
Boolean1 
((0))
 
 EP1Value used to calculate the exceedance probably and summary.Double9   
 EP2Value used to calculate the exceedance probably and summary.Double9   
 EP3Value used to calculate the exceedance probably and summary.Double9   
 EP4Value used to calculate the exceedance probably and summary.Double9   
 EP5Value used to calculate the exceedance probably and summary.Double9   
 EP6Value used to calculate the exceedance probably and summary.Double9   
 EP7Value used to calculate the exceedance probably and summary.Double9  
 EP8Value used to calculate the exceedance probably and summary.Double9  
 EP9Value used to calculate the exceedance probably and summary.Double9  
 EP10Value used to calculate the exceedance probably and summary.Double9  
 UncPercentile1Boundaries used to create the uncertainty curve.Single4   
 UncPercentile2Boundaries used to create the uncertainty curve.Single4   
 UncIntraPolicyCorrelationFactorFactor used for intra-policy correlation.Single4   
 UncInterPolicyCorrelationFactorFactor used for inter-policy correlation.Single4   
 OilPriceOil price used in an analysis ran using the AIR U.S. Hurricane Model for Offshore Assets.Double9   
 OilPriceUnitCode

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

For a complete list of codes, see tUnit Table.

VarChar10   
 GasPriceGas price used in an analysis ran using the AIR U.S. Hurricane Model for Offshore Assets.Double9   
 GasPriceUnitCode

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

For a complete list of codes, see tUnit Table.

VarChar10   
 SaveMAOL

Indicates whether Maximum Any One Life terms were 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  
 BaseAnalysisSID

Unique system-generated sequential identifier for the base analysis record.

For a compete list of records, see tAnalysis Table.

Integer4  
 EP11Value used to calculate the exceedance probably and summary.Double9  
 EP12Value used to calculate the exceedance probably and summary.Double9  
 EP13Value used to calculate the exceedance probably and summary.Double9  
 EP14Value used to calculate the exceedance probably and summary.Double9  
 EP15Value used to calculate the exceedance probably and summary.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   
 StatusCode

System-provided status code for the record in the table. 

For a complete list of codes, see dbo.tStatus Table.

VarChar10 
('AX')
 
 EventSetStandardNameName of the event set used in the analysis.VarChar1000 
('EventSTD')
 
 EventSetProductVersion

Product version associated with the event set.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

Note that for old model results, event description are not accessible because catalog files no longer exist in the Touchstone system.

VarChar10 
('3.0.X')
 
 AnalysisProductVersion

Version of the product used to perform the analysis.

This enables users to view results generated from previous version of Touchstone,  even when the models are updated.

VarChar10 
('3.0.X')
 
 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_SAVEGROSS_TLOSSANA 
([SaveGross]>=(0) AND [SaveGross]<=(1))
CKC_SAVEGROUNDUP_TLOSSANA 
([SaveGroundUp]>=(0) AND [SaveGroundUp]<=(1))
CKC_SAVEMAOL_TLOSSANA 
([SaveMAOL]>=(0) AND [SaveMAOL]<=(1))
CKC_SAVENETOFPRECAT_TLOSSANA 
([SaveNetOfPreCAT]>=(0) AND [SaveNetOfPreCAT]<=(1))
CKC_SAVEPOSTCATNET_TLOSSANA 
([SavePostCATNet]>=(0) AND [SavePostCATNet]<=(1))
CKC_SAVEPRELAYERGROSS_TLOSSANA 
([SavePreLayerGross]>=(0) AND [SavePreLayerGross]<=(1))
CKC_SAVERETAINED_TLOSSANA 
([SaveRetained]>=(0) AND [SaveRetained]<=(1))
See Also

Related Objects

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