Touchstone 2022 Database Reference
tDQValueClass Table
AIRReference Database : 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 

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
int4   
 

Name of the class value.

Corresponds to the code in DQValueClassCode.

varchar200  
 

Source column from the AIRExposure Database table.

varchar200  
 

SQL data type for the class value.

varchar200  
 

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

varchar200  
See Also

Related Objects

AIRReference Database