HOUSENO Routine - trillium_discovery - trillium_quality - 17.1

Trillium Control Center

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Discovery
Trillium > Trillium Quality
Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Trillium Control Center
Topic type
Overview
Administration
Configuration
Installation
Reference
How Do I
First publish date
2008

The HOUSENO routine compares two (2) house numbers, assuming fields are right-justified. If the two (2) fields do not match exactly, the routine calculates two (2) field lengths and starting positions by excluding leading blanks.

Table 1. Scoring for HOUSENO

Score

Description

100

Exact match (excluding blank versus blank and all zeros versus all zeros).

99

Blank field value versus non-blank – OR – All zeros field value versus all non-zeros field value.

98

Blank field value versus blank field value – OR – All zeros field versus all zeros.

If fields do not match according to the preceding criteria, these actions are performed:

98

Check if either number is in the form N-N. If both numbers are of the form N-N, then no exact match exists; however, If one of the numbers is N-N, then check if the other number is in the range N-N. If it is, then return a score of 98. (For example, 103 is in the range of 101-105.)

Note: The parity of the single numeric field must match the parity of the first value of numeric range field. For example, the values '15' and '12-19' do not match in parity. In this case the routine reduces the data to '1219' and compares it to '15,' which results in the returned score of 60.

100

Remove all leading blanks and characters that are not digits or letters from both strings and left-justify them. Return 100 if there is an exact match.

Deduct from 100

Reason for deduction

– 5

For character errors (transposition, insertion, mismatch, extra characters at the end of either field after considering insertions).

– 10

If the number of character errors is more than 25% of the length of longer field.

– 25

If the number of character errors is more than 50% of the length of longer field.