- Article Type: General
- Product: Aleph
- Product Version: 20, 21, 22, 23
How can we collect in-house use statistics (a circulation "browse") for reference material, etc.?
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:
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 .
- Article last edited: 10/8/2013