Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Difference in output of p_ cir_30 and p_cir_37

    Difference in output of p_ cir_30 and p_cir_37

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Question
    2. Answer
    3. Additional Information
    4. Attachment
    • 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(*) 
    ---------------------------------------- 
    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

     

    View article in the Exlibris Knowledge Center
    1. Back to top
      • Difference in length of utf_files version of table vs. $data_tab
      • Differences in p_cir_50, 51, and 52
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved