Touchstone 2022 Database Reference
tValidatorMatch Table
AIRReference Database : tValidatorMatch Table
Description

Stores the possible address validation match levels that can be attained via the geocoding process.

Properties
Creation Date11/3/2011 10:37 PM
File GroupPRIMARY
Text File Group
System Object
Published for Replication
Rows20
Data Space Used8.00 KB
Index Space Used8.00 KB
Columns
 Column NameDescriptionDatatypeLengthAllow NullsDefaultFormula
Primary Key 

Code that represents the address validation match level.

  • -1 = MatchNone
  • 0 = Match A
  • 1 = Match B
  • 2 = Match 1
  • 5 = Match 3
  • 6 = Match 4
  • 7 = Match 5
  • 8 = Match 6
  • 9 = Match 6A
  • 10 = Match 7
  • 11 = Match 7A
  • 12 = Match 7AA
  • 13 = Match 7AAA
  • 14 = Match 7AB
  • 15 = Match 8
  • 16 = Match 8A
  • 17 = Match 9
  • 18 = Match 10
  • 18.1 = Match 10A
  • 19 = Match 11
varchar10   
 

Name of the address validation match level.

Corresponds to the code in ValidatorMatchCode.

varchar40   
 

Description of the address validation match level.

varchar1024  
See Also

Related Objects

AIRReference Database