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

    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