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

Stores the potential levels of loss, which are portrayed as a percentage range.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows10
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key LossLevelRiskCode

Code that represents the loss level.

  • 0 = 0 - 5 %
  • 1 = 5 - 10 %
  • 2 = 10 - 15 %
  • 3 = 15 - 20 %
  • 4 = 20 - 25 %
  • 5 = 25 - 30 %
  • 6 = 30 - 35 %
  • 7 = 35 - 40 %
  • 8 = 40 - 45 %
  • 9 = 45 - 100 %
smallint2   
 LossLevelRisk

Range of loss risk.

varchar40  
 MinValue

Minimum value in the range.

Corresponds to the first number in the LossLevelRiskCode range. 

int4  
 MaxValue

Maximum value in the range.

Corresponds to the second number in the LossLevelRiskCode range. 

int4  
 Description

Description of the code.

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