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