• 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.