Touchstone Re 2022 Database Reference
tReinsuranceOutputOptionsTableList Table
AIRReference Database : tReinsuranceOutputOptionsTableList Table
Description
Stores the names of the tables that Touchstone Re creates for each set of analysis options.
Properties
Creation Date10/23/2017 4:37 PM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows332
Data Space Used304.00 KB
Index Space Used24.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key AnalysisTargetTypeCode

Code that represents the type of analysis target associated with the table.

For a complete list of codes, see tAnalysisTargetType Table.

varchar10   
Primary Key OutPutTypeCode

Code that represents the perspective of the losses in the table.

For a complete list of codes, see tOutputType Table.

varchar15   
Primary Key ResultDetailTypeCode

Code that represents the level of detail of the losses in the table.

  • AREA = Area
  • EVNT = Event Total
  • SUBA = Subarea

Users select the level of detail in the Geography drop-down list in the Output Options pane when they configure analyses.

varchar15   
Primary Key SaveByLOB

Indicates whether the Line of Business output option is associated with the table.

  • 1 = Yes (associated)
  • 0 = No (not associated)
bit1   
Primary Key SaveByZone

Indicates whether the table includes losses by zone.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1   
Primary Key IsByProgram

Indicates whether the table includes losses by program.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1   
Primary Key IsSourceInuring

Indicates whether the table includes losses for sourcing or inuring reinsurance programs.

  • 1 = Yes (included)
  • 0 = No (not included)
bit1   
Primary Key TableType

Type of the table during pre- and post-processing by the loss analysis engine.

varchar30   
Primary Key TableName

Name of the table associated with the set of analysis options.

For each analysis, the application prepends the analysis SID (sequential identifier) and the analysis type, for example, t126_LOSS_ByReAnnualEP.

varchar255   
 SliceOperationAction taken by the loss analysis engine to generate the table.varchar30  
 CreateTableStmtSQL statement used by the loss analysis engine to create the table.varchar16  
 SelectStmtSQL statement used by the loss analysis engine to create the table.varchar16  
 GroupBySQL statement used by the loss analysis engine to create the table.varchar16  
 CreateCCSI

Indicates whether the loss analysis engine creates clustered columnstore indices when creating the table.

  • 1 = Yes (creates)
  • 0 = No (does not create)
bit1  
 PartitionColumnColumn used by the loss analysis engine to partition slice tables.varchar255  
 SourceBaseTableNameName of the table that the loss analysis engine uses as a source of information.varchar255  
 FinalResultProcOrderOrder that the table is generated in.int4  
See Also

Related Objects

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