Locating patron with type 02 id which is the SSN

• Article Type: General
• Product: Aleph
• Product Version: 17.01

Description:
We recently implemented Banner. Our current patrons (about 30,000 of the total 110,000) are converted from SSN in the type 02 field to the Banner ID in the type 02 field. We wish to create our own SQL report which will find the remaining SSNs that were not converted. The Banner IDs are all 10 characters beginning with "R" and SSNs are 10 digits.

What table do I need to read in order to find them? Since this value in the table will be encrypted, what logic do I use to read it?

Resolution:
The various patron ID's are stored in the z308 table. Though the z308_verification can be encrypted, the ID itself -- stored in the z308_rec_key -- is not encrypted. The z308 table is in the $usr_library which, I believe, is ABC50 at your site.

The following SQL can be used to locate z308 type 02 records which do not begin with "R":

SQL-ABC50> select z308_rec_key, z308_id from z308 where z308_rec_key like '02%' and z308_rec_key not like '02R%';

• Article last edited: 10/8/2013