2.3 Date Matching
This section date matching details.
The following steps occurs in Date Matching:
- Derive Year of Birth (v_yob) from date of births attributes.
- Find minimum (v_min_yob) and maximum (v_max_yob) values from v_yob.
- Replace null/empty for v_min_yob with 9999 and v_max_yob with 1111.
- Match customer records against watchlist records within +/- 5 years range.
- For SAN records score is boosted if a match is within range of (v_min_yob - 5) to (v_max_yob + 5) years.
- For PEP/EDD records matches are eliminated if it is outside the range of (v_min_yob - 5) to (v_max_yob + 5) years.
Table 2-2 Example of Processing of Watchlist Records
| V_DATE_OF_BIRTHS | V_YOB | V_MIN_YOB | V_MAX_YOB |
|---|---|---|---|
| 1953-02-16 | 1953 | 1953 | 1953 |
| 1973-07 | 1973 | 1973 | 1973 |
| 1975-01-30 | 1975 | 1975 | 1975 |
| (null) | (null) | 9999 | 1111 |
| 1958-01-01;1952-12-31;1956-10-28 | 1958;1952;1956 | 1952 | 1958 |
Table 2-3 Example of Date Matches
| Source DOB | Target DOB | Match |
|---|---|---|
| 1953-02-16 | 1953-01-01;1952-12-31;1956-10-28 | True |
| 1953-02-16 | 1958;1959 | True |
| 1953-02-16; 1954-02-16 | 1961-01-02 | False |
| 1953-02-16 | Null | True |
| Null | 1958-01-01 | True |
| Null | Null | True |