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. What Oracle tables are used to produce circulation statistics?

    What Oracle tables are used to produce circulation statistics?

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1.  
    • Article Type: General
    • Product: Aleph
    • Product Version: 20, 21, 22, 23

    Description:
    What Oracle tables are used to produce circulation statistics? (We want to make sure that we don't delete any information necessary for statistics.)

    Resolution:
    The p_cir_30 ("General Circulation Statistics") and pc_cir_31 ("Circulation Statistics by Activity Type") both use the z35 table to produce their statistics.

    Though the p_cir_32 ("Remove Patron IDs") job and the total_patron_delete program (used in the GUI and in the cir-23 and file-20 Services) change the z35_id to "SCRyyyymmdd", this does not affect the statistics since the z35_id is not used in the statistics and the other z35 fields -- including the z35_bor_status -- are unaffected by p_cir_32.

    The count of the number of times a particular item has circulated (which appears in the "Loans" column in the GUI Circ Items list) comes from the z30_no_loans field.

    The z36h (loan history) and z37h (request history) tables play no role in Aleph circulation statistics. p_cir_21, using the z309 (circulation log) records, can produce statistics on certain events not covered by the p_cir_30 statistics; see KB's 8192-2759 and 16384-23473.

     


    • Article last edited: 1/28/2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • What Oracle tables are *really* needed
      • What Oracle Tables does the Acquisitions Module Use?
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. contype:kba
      2. Prod:Aleph
      3. SCRyyyymmdd
      4. Type:General
    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