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

Description:
Our cataloger called to complain that the system is not tracking loans. She says she has seen items with a zero in the loans column but asterisked to show they are checked out. We are still investigating but it seems that for those records that were imported at conversion do not appear to record a loan until the second checkout. A freshly cataloged item shows a loan the first time it is checked out. Our small numbers might be explained if all the loans are second time or more. Have you ever heard of anything like this & how can we troubleshoot.

Resolution:
If you feel that the Loans column for a particular item is incorrect, then please do the following SQL for that item. Let's say you want to verify the number of loans for item 123456-10. You would do:

> s+ abc50

SQL> select count(*) from z35 where z35_event_type in ('50','51','52','53','54','55','56','57','59') and z35_rec_key = '000123456' and Z35_ITEM_SEQUENCE = '000010';


The following SQL will give you cases of items which have current loans but whose Loan count is zero:

SQL> select z30_rec_key from z30, z36 where z30_rec_key = z36_rec_key and z30_no_loans = 0;


The following SQL will give you cases of items which have returned loans but whose Loan count is zero:

SQL> select z30_rec_key from z30, z36h where z30_rec_key = z36h_rec_key and z30_no_loans = 0;

I suggest that you also run these for some items created post-conversion, to see if they have the same problem.

• Article last edited: 10/8/2013