Touchstone 4.0 Database Documentation
tComparativeLossAnalysisOption Table
Description
Stores the values used to generate the results in a Comparative Loss analysis.
Properties
Creation Date5/31/2016 9:45 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows0
Data Space Used0.00 KB
Index Space Used0.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 dbo.tPerilSet Table.

Integer4  
 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  
 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  
 HasCoverage

Indicates whether the results include loss by coverage.

  • 1 = Yes (included)  
  • 0 = No (not included)
Boolean1 
((0))
 
 HasClaims

Indicates whether the results include claims loss.

  • 1 = Yes (included)   
  • 0 = No (not included)
Boolean1 
((0))
 
 HasTreatyLoss

Indicates whether the results include treaty loss. 

  • 1 = Yes (included) 
  • 0 = No (not included)
Boolean1 
((0))
 
 HasInjury

Indicates whether the results include Workers' Compensation loss.  

  • 1 = Yes (included)
  • 0 = No (not included)
Boolean1 
((0))
 
 IsDeterministic

Indicates whether the results include deterministic terrorism loss.  

  • 1 = Yes (included)
  • 0 = No (not included)
Boolean1 
((0))
 
 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))
 
 SaveByULOBContract

Indicates whether contract loss results by user Line of Business were saved.

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

Indicates whether loss results by user Line of Business were saved.

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

Indicates whether loss results by geographic resolution were saved.

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

Code that represents the geographic levels.

For a complete list of codes see tGeoLevel Table.

VarChar10  
 EventSetSID

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

For a complete list of records, see dbo.tEventSet Table.

Integer4   
Objects that tComparativeLossAnalysisOption 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.