Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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