Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Circulation Transaction Log

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

    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.

    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


    • Article last edited: 10/8/2013