Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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