
244 CHAPTER X I Complex Data Rule Analysis
database. For example, an employee Social Security number on a 401K record
can be correlated against the employee Social Security number in the HR
database. In this case, there are two columns involved, employee number (or
name) and Social Security number. If they do not correlate, the error may be
in either (or both) columns.
Correlations can get more complicated. For example, in name and address
error checking, you can use a database supplied by the U.S. Postal Service that
identifies all valid combinations of street name and number, city, state, and Zip
code. Name and address ...