Question

We are having issues with the results from the General Circulation Statistics (cir-30) - XXX50 report. There is always a large difference in the loan and returns figures. Any idea why this would be the case?

Any idea why this would be the case?

Answer

The General Circulation Statistics (cir-30) are retrieved from Oracle table Z35 (Event table). We see from the SIP2 server log files that you have relatively high number of loan transactions cancelled by the selfcheck machine.

Unfortunately cancelled loans are not logged in Z35.

But you can retrieve the number of loans cancelled via selfcheck via Oracle table Z309 (Circulation logger) and subtract this number from the number of loan events you retrieve via cir-30.

In Z309 cancelled loans are logged with Z309_ACTION = '27'.
Z309_DATE_X is the timestamp and Z309_REC_KEY_3 has the key of the item (from Oracle table Z30).
You would need to retrieve the sub-library from Z30_SUB_LIBRARY.

For example to count the number of cancelled loans that has happened in 2012 for items belonging to sub-library 'ABC' you may use this SQL statement:


xxx50@ALEPH> select count (*) from z30, z309
2 where Z309_ACTION = '27'
3 and Z309_DATE_X > '201201010000'
4 and Z309_DATE_X < '201301010000'
5 and Z309_REC_KEY_3=Z30_REC_KEY
6 and Z30_SUB_LIBRARY='ABC';

You can change the SQL and update the conditions for Z309_DATE_X and Z30_SUB_LIBRARY to count the number of cancelled loans for other periods or other sub libraries.

Category: Circulation (500)

• Article last edited: 10/8/2013