Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Does Aleph have a limit on the number of loans that show on the item record?

    Does Aleph have a limit on the number of loans that show on the item record?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    • Article Type: Q&A
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Question

    Does Aleph have a limit on the number of loans that show on the item record?

    Answer

    Yes, z30_no_loans is a 3-byte field and the system resets the value to 1 when it passes 999.

     

    (Note:  with v23 rep_change 2030, there has been a change and the maximum value of z30_no_loans is 998. If there are more than 998 loans, the item's number of loans remains 998.)

    Additional Information

    You can use the following SQL to get the actual count of loans for a particular item with more than 999 loans for any years for which the ADM z35 (Circulation Events) table is available:

    SQL> select count(*) from z35 where z35_rec_key = '000123456' and z35_item_sequence = '10' and z35_event_type like '5%';

    [Note: The item sequence is stored in the z35 without the leading zeroes: "000010" is stored as "10".]

    Or the following to get the number of loans for a group of items (such as a group of laptops) with the same ADM.

    SQL> select count(*) from z35 where z35_rec_key = '000123456' and z35_event_type like '5%';

    Or the following to limit the count in the preceding case to a particular school year:

    SQL> select count(*) from z35 where z35_rec_key = '000123456' and z35_event_type like '5%' and z35_event_date > '20130731' and z35_event_date < '20140801';

    Category: Circulation/ALEPH

    Subject: ALEPH - 500


    • Article last edited: 9/26/2014
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Does Aleph 20 work with Red Hat 6?
      • Does Aleph keep track of WHEN an item was marked claim return?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. ALEPH - 500
      3. Circulation/ALEPH
      4. contype:kba
      5. Prod:Aleph
      6. Type:Q&A
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved