Touchstone 4.0 Database Documentation
tObjectType Table
Description
A generic table to hold objects like templates and widgets which are added through the object management screen in administration console.
Properties
Creation Date1/6/2014 1:33 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows18
Data Space Used8.00 KB
Index Space Used40.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key ObjectTypeCode

Code that represents the object type.

  • HAZ_TMPLT =  Hazard Template
  • HAZ_WDGT = Hazard Widget
  • LOSS_TMPLT = Detailed Loss Template
  • LOSS_WDGT = Loss Widget
  • ADMINBOUND = Admin Boundary
  • LOSS_MOD_TMPLT = Detailed Loss Mod Template
  • CSTM = Non Cat Custom Calculator Template
  • ADJST = Non Cat Loss Cost Adjustment Factor Template
  • CLSH_TMPLT = Clash Template
  • DQ_TMPLT = Data Quality Template
  • AIR_SPTL_LYR = AIR Spatial Layer
  • CSTM_SPTL_LYR = Custom Spatial Layer
  • AIR_MapLegend = AIR MapLegend
  • CSTM_MapLegend = Custom MapLegend
  • AIR_SPTL_Group = AIR Spatial Group
  • CSTM_SPTL_Group = Custom Spatial Group
  • BURST_POLICY = Burst Policy
  • IMPACT_WDGT = Marginal Impact Widget
VarChar25   
 ObjectType

Name of the object type.

Corresponds to the code in ObjectTypeCode.

VarChar40  
 Description

Description of the object type.

VarChar1024  
 IsDefaultAvailable

Indicates whether the object type is the default.

  • 1 = Yes (default)
  • 0 = No (not default)
Boolean1dbo.D_0 
 ObjectBUDefinitionCode

Code that identifies the object associated with a business unit.

For a complete list of codes, see tObjectBUDefinition Table.

Integer4 
((1))
 
Check Constraints
NameDescriptionExpression
CKC_ISDEFAULTAVAILABL_TOBJECTT 
([IsDefaultAvailable] IS NULL OR [IsDefaultAvailable]>=(0) AND [IsDefaultAvailable]<=(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.