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