Difference in output of p_ cir_30 and p_cir_37

Question

Why does the result from “General Circulation Statistics (cir-30)” and “Circulation Summary Per Patron (cir-37)” differ so much? In cir-30 the figures are almost 50% higher than in cir-37 for the same patron status and time period. 

Answer

The Service cir-37 is representing the following SQL query: 

xxx50@ALEPH22> select count(*) from z35 
2 where z35_event_type in ('50','51','52','53','54') and 
3 z35_bor_status in ('06','07','08','09','10') 
4 and Z35_TIME_STAMP > '20140901' and Z35_TIME_STAMP < '20150830'; 

COUNT(*) 
---------------------------------------- 
1912 

This means, that the following event types are calculated: 

50 Simple Loan 
51 Reading Room Loan 
52 Offline Loan 
53 Advance Booking Loan 
54 Routing List Loan 
55 ILL Loan 

While service p_cir_30 is calculating all event types starting with '5x' which also includes the following types: 

56 Transfer Loan 
57 Remote Storage Loan 

except 
58 Delete loan 

****************** 
This could be represented as the following SQL queries: 

xxx50@ALEPH22> select count(*) from z35 
2 where z35_bor_status in ('06','07','08','09','10') 
3 and z35_event_type like '5%' 
4 and Z35_TIME_STAMP > '20140901' and Z35_TIME_STAMP < '20150830'; 

COUNT(*) 
---------------------------------------- 
2974 

minus 

xxx50@ALEPH22> select count(*) from z35 
2 where z35_bor_status in ('06','07','08','09','10') 
3 and z35_event_type ='58' 
4 and Z35_TIME_STAMP > '20140901' and Z35_TIME_STAMP < '20150830'; 

COUNT(*) 
---------------------------------------- 
4 

Additional Information

Attachment

If there is an attachment add link to the attachment according to steps below, if there is no content please delete the header for this section