APTNO Routine - trillium_discovery - trillium_quality - 17.1

Inline Quality and Discovery

Version
17.1
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery

The APTNO routine compares two (2) apartment numbers. If the fields do not match, the routine uses special functions to adjust field lengths and starting positions by excluding leading blanks. The routine assumes that fields are right-justified.

Note: Blanks and zeros are considered the same value.
Table 1. Scoring for APTNO

Score

Description

100

Exact match (excluding blank versus blank).

99

Blank field value versus anything – OR – All zeroes field value versus anything.

98

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

If the fields do not match according to the preceding criteria, the following actions are performed to determine if there is a match:

100

Remove all leading blanks and characters that are not digits or letters from both strings and left-justify them. The resulting score would be 100.

The routine then uses the following logic to deduct from ‘100’, thus further adjusting the match:

Deduct from 100

Reason for Deduction

– 5

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

– 10

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

– 25

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

Routine with Modifier(s):

APTNO With Modifier (01)