• 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