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. Impact of cir-77 (cir-23) on loan and request statistics

    Impact of cir-77 (cir-23) on loan and request statistics

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

    Description:
    We are a multi-ADM site and are interested deleting expired Patrons using Cir-77. Before we start removing patrons we need to know exactly what else will be impacted by the removal of these records, especially in the area of loan and request statistics.

    Once these records are removed how can we get statistics on the number of requests for an item ? Loan statistics ? Loans and request per borrower type ?

    What data is removed along with that in the patron record? What Oracle tables are cleared ? Z309? z31? Z36H ? Z37H ? etc.

    Resolution:
    The p_cir_23 single-ADM and p_cir_77 multi-ADM jobs delete only the patron records (z303, z304, z305, and z308).

    They do not delete the loan history (z36h), request history (z37h), Z309, z31, or z35 (circulation event) tables. (The z35 is what the p_cir_32 circulation statistics job uses.)

    The p_cir_32 job can be used to scrub the patron ID from all of the above tables, but that job also does not actually delete any records.

    The p_cir_78 deletes old circ logger records.

    See also, these articles: 

    •    Purging z31 cash transactions (KB 4097)
    •    Deleting/purging patron and cash records **MASTER RECORD**  (KB 5820), and
    •    Purging Cash History and return of old Lost items  (KB 16384-2274)

    • Article last edited: 12-Dec-2016
    View article in the Exlibris Knowledge Center
    1. Back to top
      • imp_demo_libraries: "Export File usm01/files/exportSEQ.tar.gz Not Found ".
      • Impact of p_manage_07
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. cir-23
      2. cir-77
      3. circ statistics
      4. purging
    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