Audit Objective pr-29

Compare vendor addresses/phone numbers and employee addresses/phone numbers to identify conflict-of-interest (e.g. postcodes, phone numbers)

Step 1

Employee Vendor

Using the main form, select the 'Employee Vendor' function. The process compares each employee's address with that of each vendor, and flags the record using a "fuzzy" match technique. This is done using the "Levenshtein distance". There are six steps in the process:

1. Select the table (or worksheet) containing the employee address information.
2. Select the name of the column containing the employee address
3. Select the table (or worksheet) containing the vendor address information.
4. Select the name of the column containing the vendor address
5. Select the name of the column containing the vendor number or other identification
6. Specify the Levenshtein distance. 0 is an exact match, 10 is a similar, but less close value. (default is 4)
7. Click the "process" button

Output from the process will be available in two formats:

1. As an extract in a file
2. As a report (in the 'report tab')

The report file may be loaded into Excel for for further analysis or sorting.





Home



Application Area