Updating Patron Expiry Dates for non-standard borrowers via SQL?
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
We have a number of special borrowers that aren't loaded during a standard patron load that we'd like to update expiry dates for. What we don't know is if there is a way to "mass update" these records, either through Aleph or through SQL, without generating a PLIF file to be loaded. We see that the z305_expiry_date stores this number, but aren't sure if this is stored in other locations in the database or not.
Resolution:
The patron expiration date is stored only in the z305_expiry_date. You can update this field via SQL as you see fit.
(You should, of course, back up the z305 table, using p_file_03, before doing any such update.)
- Article last edited: 10/8/2013