Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Difference in output of p_ cir_30 and p_cir_37

    • Product: Aleph
    • Product Version: Aleph 22
    • Relevant for Installation Type: select the relevant: Dedicated-Direct,Direct,Local,Total Care

    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(*) 
    ---------------------------------------- 

    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

     

    • Was this article helpful?
    //doorbell.io feedback widged