Booking transactions (event-type 91) missing from p_cir_30 circ statistics
- Article Type: General
- Product: Aleph
- Product Version: 18.01
Description:
The p_cir_30 Circulation Statistics report is not counting booking transactions that turned into loans.
Resolution:
The z35_event_type for a booking loan is "91":
90 = Booking
91 = Booking turning to loan
Type 91 is not included in the /alephm/sql_stat/cir_stat_nn..._param.sql. (Only types 50-59 are included.) We need to change this so that 91 is also included.
Example. In cir_stat_07_stat_bor_param.sql, change:
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)) LOANS,
to:
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,
- Article last edited: 10/8/2013