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

    p_serial_09 report inaccurate (when Cataloger is included)

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

    Description:
    The serial-09 report does not seem to be accurate. One of our schools reports that the numbers for the last several months do not match at all with their manual statistics. I see that $aleph_proc/p_serial_09 invokes ./alephm/sql_stat/util_s_05_04.sql . It is my understanding that the z30_cataloger is populated for each arrival with the name of the person who originally created the record (that is the understanding of the cataloging/serials staff here).

    We added the cataloger name to util_s_05_04.sql and find that the totals per cataloger don't match.

    Resolution:
    The z30h_h_date is the date that the z30h record was created, but the z30h_cataloger is the person who created the item and *not* necessarily the person who performed the arrival; that is the z30h_h_cataloger ("User name of the librarian that triggered the change").

    You need to re-do the analysis specifying z30h_h_cataloger rather than z30h_cataloger.

    > Why does the z30h_h_date not match the arrival date?

    <<js The z30h_h_date is the date the history record was written. If the most recent change is the change to the arrival date, then, the *z30*_arrival_date and the z30h_h_date will be the same. But if the most recent change is to some other field (or deletion of the item), then the z30h_h_date will be later than the z30_arrival_date.

    The following is from the z30/z30h pdf file:

    Currently the changes that trigger the creation of a history record are the following:

    ITEM-LOCATION
    ITEM-LOCATION-2
    ITEM-COLLECTION
    ITEM-SUB-LIBRARY
    ITEM-PROCESS-STATUS
    ITEM-BARCODE
    BIND
    DELETE
    ITEM-STATUS
    ALL-FIELDS

    Change to the z30_arrival_date field is not one of the specific ones, so this update falls under "ALL-FIELDS" ("Other").

    You want to show how many arrivals each cataloger did in a certain time period. There are complications to this....

    1. The z78 arrival record doesn't include the cataloger

    2. The z30h record includes the z30h_h_cataloger who triggered the change, but it doesn't indicate if the change was the z30_arrival_date. Thus, cataloger xx may change the z30_arrival_date on June 15 and change the z30_item_process_status on July 10. There will be a z30h record for July 10 with a z30h_arrival_date of June 15, but this will have the z30h_h_cataloger of the process status change.

    Looking for z30h_arrival_date = z30h_h_date will not work. You need to look for Z30H_H_REASON = 'Process Status' and z30h_item_process_status = 'NA' instead. These will be cases where the item processing status is being changed from "NA" to blank, that is, they will be arrivals.

    bec50@ALEPH20> select z30h_h_date, z30h_h_cataloger from z30h, z30
    2 where z30_arrival_date between '20111121' and '20111130'
    3 and z30_arrival_date = z30h_h_date and z30h_sub_library = 'BECCO'
    4 and substr (z30h_rec_key,1,15) = z30_rec_key
    5 and Z30H_H_REASON = 'Process Status' and z30h_item_process_status = 'NA'
    6 order by z30_arrival_date;


    • Article last edited: 10/8/2013
    • Was this article helpful?