Touchstone 2022 Database Reference
tOutputTableType Table
AIRReference Database : tOutputTableType Table
Description

Stores the possible output table types to which the output is written.

Properties
Creation Date8/15/2011 6:08 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows14
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OutputTableTypeCode

Code that represents the type of output table.

  • D = Dimension
  • M = Main
  • MP = Model AnnualEP
  • P = Post process
  • PP = Peril AnnualEP
  • PS = Peril Model Summary
  • R = Reinsurance
  • RC = CATXOL Reinsurance
  • RD = Reinsurance dimension
  • S = Summary
  • SP = Spatial Detail
  • WC = MAOL
varchar10   
 OutputTableType

Name of the output table type.

Corresponds to the code in OutputTableTypeCode.

varchar40   
 Description

Description of the output table type.

varchar1024  
Objects that depend on tOutputTableType
 Database ObjectObject TypeDescriptionDep Level
tOutputTable tabletOutputTableTable

Stores the database tables where the output is stored.

1
tOutputTypeTableXref tabletOutputTypeTableXrefTableSystem reference table used to associate the output type tables during a loss analysis.2
tOutputTypPerspectiveXref_NGM tabletOutputTypPerspectiveXref_NGMTableSystem reference table that stores the financial perspective codes that correspond to each output table type.2
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.