Skip to main content
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    Circ statistics by patron type (z305_bor_type) rather than patron status

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Desired Outcome Goal:
    Create report with:

    Patron type Number of loans Number of renewals

    for specific time period.

    Substitute "Patron Type" (z35_bor_type) for "Patron Status" (z35_bor_status) in running the cir-30 (General Circulation Statistics):

    > am
    > cd sql_stat
    > cp -p cir_stat_07_stat_bor_param.sql

    vi cir_stat_07_stat_bor_param.sql and change the two occurrences of the string "Z35_BOR_STATUS" to "Z35_BOR_TYPE".

    Then do the same for cir_stat_13_stat_loan_param.sql:

    > cp -p cir_stat_13_stat_loan_param.sql

    vi cir_stat_13_stat_loan_param.sql and change the two occurrences of the string "Z35_BOR_STATUS" to "Z35_BOR_TYPE".

    Then submit cir-30 choosing "Patron Status" as the "Group Results By" parameter. Since the above change has been made, it will look for and use the z35_bor_type (instead of z35_bor_status).

    Additional Information

    Note: EL Commons Code Contributions from Natalie Sturr at contain custom-01 and custom-02 reports for borrower type:

    Circ statistics by sublibrary/borrower type/item status
    Circ statistics by sublibrary/borrower type/borrower status/item status

    Multiple pieces (in ./aleph/proc, ./alephm/source/butil, ./pc_b_lng, ./alephm/sql_tab) are required for implementing this, so it is more complicated than the changes shown above. These reports are part of a "suite" of custom jobs.

    Category: Circulation (500)

    Subject: Services

    • Article last edited: 10/8/2013