Touchstone 4.0 Database Documentation
tOccLimitType Table
Description

Stores the possible limit types that can be applied to the layer and sublimit.

Properties
Creation Date11/3/2011 11:44 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows9
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key OccLimitTypeCode

Code that represents the limit and sublimit types.

Limit Types:

  • B = Blanket Limit
  • CSL100 = Combined Single Limit 100% participation
  • CSLAI = Combined Single Limit Assured Interest
  • E = Excess Limit
  • N = No limit

Sublimit Types:

  • B = Blanket Limit
  • C = Limit by Coverage
  • C100 = Limit by Coverage 100% Participation
  • CAI = Limit by Coverage with Assured Interest
  • CB = Combined, Including Time Separately
  • E = Excess Limit
  • N = No limit
VarChar10   
 OccLimitType

Name of the limit type.

Corresponds to the code in OccLimitTypeCode.

VarChar40   
 Description

Description of the limit type.

VarChar1024  
 OccLimit1Label

Identifies how the Limit 1 value is applied by the analysis engine. For example, when the limit type is Limit By Coverage, the value for Limit 1 is the limit for Coverage A.

Note that Limit 1 is referred to as Limit A on the user interface.

VarChar40  
 OccLimit2Label

Identifies how the Limit 2 value is applied by the analysis engine. For example, when the limit type is Limit By Coverage, the value for Limit 2 is the limit for Coverage B.

Note that Limit 2 is referred to as Limit B on the user interface.

VarChar40  
 OccLimit3Label

Identifies how the Limit 3 value is applied by the analysis engine. For example, when the limit type is Limit By Coverage, the value for Limit 3 is the limit for Coverage C.

Note that Limit 3 is referred to as Limit C on the user interface.

VarChar40  
 OccLimit4Label

Identifies how the Limit 4 value is applied by the analysis engine. For example, when the limit type is Limit By Coverage, the value for Limit 4 is the limit for Coverage D.

Note that Limit 4 is referred to as Limit D on the user interface.

VarChar40  
 ValidForLayer

Indicates whether the limit is a layer limit.

  • 1 = Yes
  • 0 = No
Boolean1 dbo.D_0 
 ValidForSublimit

Indicates whether the limit is available for use by the sublimit.

  • 1 = Yes (available)
  • 0 = No (not available)
Boolean1 dbo.D_0 
Check Constraints
NameDescriptionExpression
CKC_VALIDFORLAYER_TOCCLIMI 
([ValidForLayer]>=(0) AND [ValidForLayer]<=(1))
CKC_VALIDFORSUBLIMIT_TOCCLIMI 
([ValidForSublimit]>=(0) AND [ValidForSublimit]<=(1))
See Also

Related Objects

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