Touchstone 4.0 Database Documentation
tNonCatTemplateRule Table
Description

Used for a Non-catastrophe analysis, this table stores information about the defined template rules (filter).

Properties
Creation Date10/2/2014 10:08 AM
File GroupPRIMARY
Text File GroupPRIMARY
System Object
Published for Replication
Rows24
Data Space Used40.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key RuleSIDUnique system-generated sequential identifier for the non-catastrophe template rule record.Integer4   
 IsCountryCode

Indicates whether the rule applies to the country.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 IsAreaCode

Indicates whether the rule applies to the area.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 IsSubAreaCode

Indicates whether the rule applies to the subarea.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 IsPostalCode

Indicates whether the rule applies to the postal.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 IsConstructionCode

Indicates whether the rule applies to the construction class.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 IsOccupancyCode

Indicates whether the rule applies to the occupancy class.

  • 1 = Yes (applies)
  • 0 = No (does not apply)
Boolean1   
 JoinAliasReserved for internal use.VarWChar10   
 JoinClauseReserved for internal use.LongVarWChar16   
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.