FRSTNAME Routine  - trillium_discovery - trillium_quality - Latest

Inline Quality and Discovery

Product type
Software
Portfolio
Verify
Product family
Trillium
Product
Trillium > Trillium Quality
Trillium > Trillium Discovery
Version
Latest
Language
English
Product name
Trillium Quality and Discovery
Title
Inline Quality and Discovery
Copyright
2024
First publish date
2008
Last updated
2024-10-18
Published on
2024-10-18T15:10:12.949492

The FRSTNAME routine compares two first names, assuming fields are left-justified and blank-filled. If the two fields do not match exactly, the routine calculates two field lengths by excluding trailing blanks.

Table 1. Scoring for FRSTNAME

Score

Description

100

Exact match (excluding blank versus blank).

99

Blank field value versus blank field value.

98

Blank field value versus anything.

95

Shorter field value is one character in length and it equals the first character of the longer field: for example, J versus John.

90

If shorter field value is greater than one character in length and it is an exact starting substring of the longer field: for example, Jo versus Jo-Anne.

80

If there is a mismatch of the first characters of both fields.

The following logic is applied to further narrow the match. Based on this logic, the values are deducted from a ‘95’ score:

Deduct from 95

Reason for Deduction

– 2

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

– 10

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

– 25

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

No additional scoring deductions occur if:

  • There is only one error and one extra character difference between the two fields
  • There is only a one character difference in the lengths of the two fields
  • Only the first field is greater than 5 characters in length. Use the Symetric modifier if you want to prevent a scoring deduction when either or both fields are more than 5 characters.