Traditionally, the process of integrating multiple databases into a unified whole is limited by logical conflicts between the database structures. We are well aware that users have no desire to redesign their existing systems to facilitate data sharing. CNAV solves this problem by using advanced heuristics to create pointers that allow records from various sources to be linked without the provision of a standard primary key. This means that, when CNAV encounters Jane Doe within the transcript database and the employee database, it's smart enough to recognize that this is the same person and link the records accordingly even if Jane's social security number or employee ID is not present in both sources. CNAV can even handle degrees of fuzzy logic, recognizing that Robert Jones and Bob Jones are in fact the same person.
In cases where identity cannot be confirmed beyond a doubt, CNAV flags potential duplicates to the appropriate college personnel for verification. That is, CNAV leaves those accounts as Pending and waits for a campus official to decide whether or not the records actually match.
Clicking Campus Tools, Account Mgmt, View Pending Accounts allows you to view a list of all accounts that have been left pending for this reason. For each pending account, this screen displays the following information:
Modify: This column provides two icons. The Edit icon allows you to edit the account status to inform CNAV of whether or not the records actually match. The Mail to icon allows you to email the person who requested the account to inform her of the account status.
Requestor: This column lists the name of each person who requested an account that is currently pending verification.
Status: This column reports the current account status. Usually, that status is On Hold.
Requested Date: This column lists the date and time at which each pending account was requested.
From this screen, you can perform the following tasks:
Download the list to a spreadsheet-readable file. To download this information, click the Download icon.
Process a pending account. To process an account by informing CNAV whether the records are in fact for the same person, click the Edit icon. CNAV will display the Requests Pending edit screen.