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

    Circulation Transaction Log

    • 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