Touchstone 4.0 Database Documentation
tDQValueClass Table
Description

Stores information used to identify augmentation location fields.

Properties
Creation Date2/16/2011 6:00 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows54
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key DQValueClassCode

Code that represents the Data Quality class value.

  • 1 = Latitude
  • 2 = Longitude
  • 3 = Geo Match Level
  • 4 = Construction
  • 5 = Occupancy
  • 6 = Year Built
  • 7 = Building Height
  • 8 = Gross Area
  • 9 = Employee Count
  • 10 = Foundation Type
  • 11 = Siding
  • 12 = Roof Cover
  • 13 = Roof Geometry
  • 14 = ReplacementValue A
  • 15 = ReplacementValue B
  • 16 = ReplacementValue C
  • 17 = ReplacementValue D
  • 18 = Location Limit A
  • 19 = Location Limit B
  • 20 = Location Limit C
  • 2 =1 Location Limit D
  • 22 = ISOBIN
  • 23 = Building Shape
  • 24 = Torsion Loads
  • 25 = Soft Story
  • 26 = Roof Cover Attachment
  • 27 = Roof Deck
  • 28 = Roof Deck Attachment
  • 29 = External Wall Type
  • 30 = Glass Type
  • 31 = Glass Percent
  • 32 = Window Protection
  • 33 = External Door
  • 35 = Foundation Connection
  • 36 = Appurtenant Structures
  • 37 = StreetAddress
  • 38 = StreetNumber
  • 39 = City
  • 40 = PostalCode
  • 41 = DeductibleA
  • 42 = DeductibleC
  • 43 = RoofAnchorage
  • 44 = CountryCode
  • 45 = Area Code
  • 46 = Subarea Code
  • 47 = Postal Code
  • 48 = Scheme Path
  • 49 = Area External
  • 50 = Area Name
  • 51 = Country Name
  • 52 = Geography SID
  • 53 = Validator Match
  • 54 = Enhanced Geo Match Level
  • 55 = Geocoder
Integer4   
 DQValueClass

Name of the class value.

Corresponds to the code in DQValueClassCode.

VarChar200  
 SourceColumn

Source column from the AIRExposure Database table.

VarChar200  
 IDDataType

SQL data type for the class value.

VarChar200  
 TargetKeyColumn

Primary key for the corresponding source column from the AIRExposure Database table.

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