Touchstone 4.0 Database Documentation
tDefaultNonCatAnalysisOption Table
Description

Stores the default non-catastrophe Loss analysis options. 

Properties
Creation Date5/31/2016 9:46 AM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows2
Data Space Used8.00 KB
Index Space Used72.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DefaultNonCATAnalysisOptionSIDUnique system-generated sequential identifier for the non-catastrophe analysis option record.Integer4   
 BusinessUnitSID

Unique system-generated sequential identifier for the business unit record.

Integer4   
 UnknownConstructionCode
Code that represents the default value for an unknown construction code.
SmallInt2   
 UnknownOccupancyCode
Code that represents the default value for an unknown occupancy code.
SmallInt2   
 IsTenantRuleEnabled

Indicates whether the location is covered under a tenant policy.

  • 1 = Yes (covered)
  • 0 = No (not covered)
Boolean1   
 IsCondoRuleEnabled

Indicates whether the condo rule is enabled.

  • 1 = Yes (enabled)
  • 0 = No (disabled)
Boolean1   
 PPCCode

Code that represents the Public Protection Classification (PPC).

Class 1 generally represents superior property fire protection, and Class 10 indicates that the area's fire-suppression program doesn't meet ISO’s minimum criteria.

For additional information, see the ISO Public Protection Classification Program.

VarChar10   
 IsSprinkersAvailable

Indicates whether the location has installed sprinklers.

  • 1 = Yes (covered)
  • 0 = No (not covered)
Boolean1   
 UnknownDeductibleValue
Code that represents the value for an unknown deductible code.
Double9   
 CondoReplacementValueRatioReplacement values for Coverages A and C.Single4   
 MultiFamilyUnitAssumed number of units within a multi-family occupancy.Integer4   
 GeneralResidentialOccupancyCode
Code that represents the occupancy code for a "typical" residence.
SmallInt2   
 DefaultBGILossCostTemplateSIDUnique system-generated sequential identifier for the default Basic Group 1 (BGI) Loss Cost Template record.Integer4  
 DefaultSCLLossCostTemplateSIDUnique system-generated sequential identifier for the default Special Causes of Loss (SCL) Loss Cost Template record.Integer4  
See Also

Related Objects

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