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

    How to gather In-house use statistics

    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    How can we collect in-house use statistics (a circulation "browse") for reference material, etc.?

    Resolution:
    Two z35_event_types exist for this purpose:

    "80": generated by a special in-house-use utility. (See below.)

    "82": generated every time an item which is not on loan is returned using the standard return functionality.

    Both events, in-house use and returning an item that is not on loan, create z35 transactions that include the following data: material type, item status, item sublibrary, date, hour, ip address, operator.

    In order to use the "In-house use" utility, click on "Circulation" at the top of the screen and then select "In-house Use" from the dropdown which displays. An "Enter item barcode" screen pops up. Entering an item barcode here creates the z35_event_type "80" which can be used for statistics.

    Note: Though event types 80 and 82 have been added, as of this writing (April, 2011), the standard circ statistics reports (p_cir_30 and p_cir_31) for versions 16 - 20 are not doing anything with these.

    In addition to writing the z35 records, z309 (circ logger) records are written. The "In-house use" utility writes a z309 action '30' record and the item-not-on-loan return, an action '29' record. These records can be reported on by running the p_cir_21 Circulation Logger report specifying "In-house use" as the Action (for the '30's) and/or the "Not On Loan Return" (for the '29's).

    You could, of course, write your own scripts or ARC reports which would read these.

    The following SQL will give you a count of in-house "loans" by month:

    s+ xxx50
    SQL> select substr (z35_event_date,1,6), count(*) from z35 where (z35_event_type = '80' or z35_event_type = '82' ) group by substr (z35_event_date,1,6);

    And this by sublibrary for a particular year/month:

    SQL> select z35_sub_library, count(*) from z35 where (z35_event_type = '80' or z35_event_type = '82' ) and z35_event_date like 'yyyymm%' group by z35_sub_library order by z35_sub_library;

    The preceding information is included in the "Circulation In-House Use" Powerpoint, on the Doc Portal, under: Aleph > Support > How To from Support by subject > Circulation .

    Additional Information

    faq


    • Article last edited: 10/8/2013