OCLC Collection Analysis report: individual transactions
- 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