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.
Procedure:
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 cir_stat_07_stat_bor_param.sql.save
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 cir_stat_13_stat_loan_param.sql.save
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 http://www.exlibrisgroup.org/display/Aleph/Aleph+Custom+Services+-+46+Services+from+SUNY 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