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).