What types of loans does p_cir_30 include? Can I change these?
- Article Type: Q&A
- Product: Aleph
- Product Version: 20
Question
What types of loans does p_cir_30 (“General Circulation Statistics") include in its counts?
Can certain types be excluded?
Answer
1. The "Loans" counts include:
50 = Simple loan
51 = Reading Room loan
52 = Offline circulation
53 = Short Loan
54 = Routing List loan
55 = ILL loan
56 = Transfer loan
57 = Remote Storage Loan
59 = Maintenance Loan
91 = Booking turning to loan
They do *not* include:
80 = Circulation tab / In-house use or
82 = Return of item not in loan
See KB #8192-2759 [How to gather In-house use statistics] for details on this topic.
2. Certain types can be excluded.
Each of these /exlibris/aleph/a20_1/alephm/sql_stat/ statistics routines:
cir_stat_07_stat_bor_param.sql: [patron status]
cir_stat_08_stat_date_param.sql: [date range]
cir_stat_09_stat_itm_param.sql: [item status] and
cir_stat_10_stat_mat_param.sql: [material type]
includes the following lines:
count(decode (&&1..Z35.Z35_EVENT_TYPE,'50',1,
'51',1,
'52',1,
'53',1,
'54',1,
'55',1,
'56',1,
'57',1,
'59',1,
'91',1)) LOANS,
These can be changed to remove (or add) certain types. Please note that the routines are subject to change in future Service Packs or Versions.
Category: Circulation (500)
Subject: Services
- Article last edited: 10/8/2013