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. Circulation Transaction Log

    Circulation Transaction Log

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Is there a way to look at all circulation transactions that took place on July 13
    between 12:30 pm and 12:45 pm? I am trying to determine the exact sequence of
    events that resulted in an item being checked out to the wrong patron.

    Resolution:
    You can do this with an SQL query on the Z35 table:
    This table contains information regarding the various transactions of the GUI/Web Circulation (loans, returns, holds, photocopy requests) and the GUI Search/Web OPAC (searching).
    The Z35_REC_KEY contains the system number of the administrative record associated with the circulation event.
    The Z35-EVENT-DAY contains the Date the transaction took place, in the format YYYYMMDD
    The Z35-EVENT-HOUR contains the Hour the transaction took place, in the format HHMM
    A query using these three elements should give you the information you need.

    Additional Information

    faq


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Circulation Summary Per Patron (cir-37) is missing in the Services menu
      • Circulation" button says: "BIB document has ITM link, Create ADM anyway?"
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 16.02
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    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