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

    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