Overview of loans/holds/returns for particular item (using z35)

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

Description:
Some odd things have been happening recently with loans/holds/returns for item 001799297-000010. Can we get an overview of this activity?

Resolution:
The following SQL shows the various z35 events for this item in 2009:

abc50> select z35_event_date, Z35_EVENT_HOUR, z35_event_type, z35_id from z35 where z35_rec_key = '001799297' and Z35_ITEM_SEQUENCE = '000010' and z35_event_date like '2009%' order by Z35_EVENT_DATE, Z35_EVENT_HOUR;
**** Hit return to continue ****

Z35_EVENT_DATE Z35_EVENT_HOUR Z3 Z35_ID
-------------- -------------- -- ------------
20090205 1544 74 SCR20090205
20090217 1646 61 SCR20090217
20090217 1647 74 SCR20090217
20090218 1331 50 SCR20090218

Here are the z35_event_type's from the (z35.pdf document):

50 = Simple loan
51 = Reading Room loan
52 = Offline circulation
53 = Short Loan
54 = Routing List loan
55 = ILL loan
56 = Transfer loan
57 = Remote Storage Loan
58 = Delete loan
59 = Maintenance Loan
61 = Return transaction
62 = Loan renew transaction (Web renewal)
63 = Loan renew transaction (PC renewal)
64 = Loan renew transaction (automatic renewal performed by b_cir_08 and b_cir_10)
65 = Item declared lost (created by manual Lost function only; Lost transactions created by p_cir_51 do not generate type 65 records).
66 = Item claimed returned
71 = Hold request transaction (placed on available item – expansion)
72 = Hold request transaction (placed on available item – no expansion)
73 = Hold request transaction (placed on item not available – expansion)
74 = Hold request transaction (placed on item not available – no expansion)
75 = Short loan request transaction
80 = In-house use discharge
81 = Photocopy request transaction
82 = Return of item not in loan
90 = Booking
91 = Booking turning to loan
92 = Delete Booking
95 = Other Institute Fulfillment
96 = Item Is Received at Pickup Location

• Article last edited: 10/8/2013