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

    Which item gets credit for circ when item is loaned from different sublib?

    1. Last updated
    2. Save as PDF
    • Article Type: General
    • Product: Aleph
    • Product Version: 16.02

    Description:
    Which library gets credit for the circulation count in circ. statistics:
    1.the library that owns the book (Z35_SUB_LIBRARY) or
    2.the library that checks it out to the patron or
    3.both?

    Z35_ID and Z35_CATALOGER_NAME can be different, to what lib. the loan is written?
    Items loaned to other libraries as pseudo-patrons (transfer loan 56).
    For ex. barcode 31699003066612, In item history/loan, GC-first loan, then JJ in transit-2nd loan.
    transfer loan Z35_EVENT_TYPE=56, JJ->GC: Z35_SUB_LIBRARY=JJ001, Z35_ID=GC001, and Z35_CATALOGER_NAME='JJBARRY' from JJ
    then transfer loan Z35_EVENT_TYPE=56, GC->JJ: Z35_SUB_LIBRARY=JJ001, Z35_ID=JJ001, and Z35_CATALOGER_NAME='GCSEDA' from GC.

    SQL> select Z35_ID, Z35_SUB_LIBRARY, Z35_STATUS, Z35_EVENT_DATE, Z35_EVENT_HOUR, Z35_BOR_STATUS, Z35_BOR_TYPE, Z35_CATALOGER_NAME,
    2 Z35_EVENT_TYPE, Z35_TYPE, Z35_IP_ADDRESS, Z35_TIME_STAMP from z35
    3 where Z35_REC_KEY='004668525' and Z35_ITEM_SEQUENCE='000010' and (Z35_EVENT_DATE like '200709%' or Z35_EVENT_DATE like '200710%');

    GC001 JJ001 20070919 838 98 JJBARRY 56 P
    JJ1 2007091908383846460455
    JJ001 JJ001 20071001 933 98 GCSEDA 56 P
    GC1 2007100109331688882627

    Resolution:
    The p_cir_30 job produces circulation statistics using the values in the z35 record. Any count of the sublibrary in the loans, returns, etc., is based on the z35_sub_library.

    The p_cir_30 statistics do not look at the Z35_ID or Z35_CATALOGER_NAME. You could, of course, write your own SQL queries which would do so.


    [Jerry Specht]
    [10/22/2007 6:25:11 PM Jerry Specht]

    • Article last edited: 10/8/2013