Touchstone Re 2022 Database Reference
tAggregateLossAnalysisOutputOption Table
AIRProject Database : tAggregateLossAnalysisOutputOption Table
Description
Stores information about the output options specified for each loss analysis.
Properties
Creation Date4/4/2022 3:02 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows8
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisSIDUnique system-generated sequential identifier for the analysis record.int4   
Primary Key OutputTypeCode

Code that represents the output type for the analysis.

For a complete list of codes, see tOutputType Table.

varchar10   
 ResultDetailTypeCode

Code that represents the level of detail of the analysis results.

For a complete list of codes, see tAggregateAnalysisResultDetail Table.

varchar10  
 SaveByLOB

Indicates whether the user saved the analysis results by line of business (LOB).

  • 1 = Yes (saved by LOB)
  • 0 = No (not saved by LOB)
bit1  
 SaveByZoneSet

Indicates whether the user saved the analysis results by zone set.

  • 1 = Yes (saved by zone set)
  • 0 = No (not saved by zone set)
bit1  
Objects that tAggregateLossAnalysisOutputOption 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.