Touchstone 4.0 Database Documentation
tSpatialAnalysisField Table
Description

System reference table that stores information regarding the attributes that are available for browsing or required for Geospatial analytics. 

Properties
Creation Date2/7/2012 12:20 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows149
Data Space Used24.00 KB
Index Space Used16.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key SpatialAnalysisFieldType

Categorization for the Geospatial analysis field type.

VarChar40   
Primary Key SpatialAnalysisField

Name of the Geospatial analysis field type.

VarChar255   
 Description

Description of the Geospatial analysis field type.

VarChar1024   
 IsActive

Indicates whether the Geospatial analysis field type is available for use.

  • 1 = Yes (available)
  • 0 = No (unavailable)
Boolean1 dbo.D_1 
 ColumnOrderOrder in which the table columns are organized.Single4   
 ColumnRankRanking for the table columns.Integer4   
 IsVisible

Indicates whether the Geospatial analysis field type is visible on the user interface.

  • 1 = Yes (visible)
  • 0 = No (not visible)
Boolean1 dbo.D_1 
 IsIncludedInCube

Indicates whether the Geospatial analysis field type is included in the cube building process, but is not be visible on the user interface.

  • 1 = Yes (included)
  • 0 = No (not included)
Boolean1 dbo.D_1 
 IsWorkersComp

Indicates whether the Geospatial analysis field type is available for Workers' compensation risks.

  • 1 = Yes (available)
  • 0 = No (unavailable)
Boolean1 
((0))
 
 IsProperty

Indicates whether the Geospatial analysis field type is available for Property risks.

  • 1 = Yes (available)
  • 0 = No (unavailable)
Boolean1 
((0))
 
Check Constraints
NameDescriptionExpression
CKC_ISACTIVE_TSPATIAL 
([IsActive]>=(0) AND [IsActive]<=(1))
CKC_ISVISIBLE_TSPATIAL 
([IsVisible]>=(0) AND [IsVisible]<=(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.