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

Description:
We are interested in generating a report for the OCLC Collection Analysis service: http://www.oclc.org/support/documentation/collectionanalysis/circ/circ_intro.htm

They need a file with individual circulation transactions. By policy I am pretty certain we do not keep this data. Can you confirm?I n What Oracle tables would individual circulation transactions be stored?

Resolution:
Though you may be running p_cir_32 to eliminate the patron ID from the completed circulation transactions, you are certainly keeping the z35 circulation event records (-- which are used to produce circulation statistics). The loan events are z35_event_type's 51, 52, 53, 54, and 55; in-house-use events are 80 and 82.

These z35 records have the item location (z35_sub_library) and the check out date (z35_event_date).

The z30 record has the barcode.

Thus, the following SQL would give you info for each loan event:

SQL> select z35_sub_library, z30_barcode, z35_event_date from z35, z30 where z35_event_date > '20090630' and z35_event_date < '20100701' and z35_event_type in ('51', '52', '53', '54', '55', '80', '82') and z35_rec_key || lpad (Z35_ITEM_SEQUENCE,6,'0') = z30_rec_key;

The oclc number would need to be obtained from the bib library z13u (if you have that as a z13u field) or the z00r (if you are generating that optional record type).

• Article last edited: 10/8/2013