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

    Transferring checked-out items to different patron

     

    • Product: Aleph
    • Product Version: 20, 21, 22, 23
    • Relevant for Installation Type: Dedicated-Direct, Direct, Local

     

    Description

    We need to transfer 130 checked-out items from a retiring employee to his replacement.

    Resolution

    We're unaware of any Aleph Service which does this.  The patron ID of the patron who currently has an item on loan is found in the z36 (loan) record. The following SQL can  be used to change it: 

    > s+ xxx50 
    SQL> update z36 set z36_id = 'mmmmmmmmmmmm' where z36_id = 'nnnnnnnnnnnn'; 
    SQL> commit; 

    <where 'nnnnnnnnnnnn' is the patron who has the items on loan and 'mmmmmmmmmmmm' is the patron who it should be changed to>. 

    Be sure to back up the z36 table before doing the above (--and you may want to first try it on your Test server). 

    The z309 (circ logger) records and the z35 (circ event) records also contain the patron ID.  But, while the z36 has only items currently on loan, the z309 and z35 have previous loans. 

    SQL could be devised to change the z309's and z35's for only items which this patron currently has on loan, but that would be more complicated. 

     

     


    • Article last edited: 31-Oct-2017