• 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