A new cleanup report option has been added to the Unlinked Record Clean Up Reports (priv-07) service. It will identify holding records that do not have items linked to them. Here is some more information about it:
If the radio button "Holdings without Items" is chosen, this process will provide a list of SYS01 Bib record system numbers and the associated SYS60 Holding record system numbers for instances where no item records are linked to the specified holding record. The columnar headings are in this order: Bib Key (SYS01 Bib Record System ID), Bib Status, HoldingKey (SYS60 Holding Record System ID), SubLibrary, Collection, Title, OCLC Number, and Call Number. The report is sorted by the Bib Key (Bib Record System ID). Note: Please keep in mind that these Bibliographic records could have other holdings records where there are items properly linked. Or, there may be items attached to the Bib record that are just not properly linked to the holding record.
Here are some things you should look for when reviewing each record, and how to handle them:
A duplicate holding record (same sublibrary, collection, and call number) with items linked, or a complete holding record with items linked (while the one on the report is only an incomplete holding record). That means the holding record with no items can be deleted.
Unlinked items that should be attached to the holding record with no items. Relink them via tab 6. HOL Links of the item record. Note: items for this scenario will also be identified by the “Unlinked Item Records to HOL records” option of the priv-07. So, when working with these two reports, you should run and work on one first. Then, run the second one and work on it. You may wish to run the “Unlinked Item Records to HOL records” report option of the priv-07 first. That will narrow down the scenarios you could encounter while working with the "Holdings without Items" report.
No items and/or other holding records. This could mean someone began logically deleting the record and did not finish. So, you should complete the logical deletion of all parts of the record-and note the OCLC number/title to make sure your holding with OCLC has been updated for that title. Or, just no items could also mean it was an electronic resource record that you did not create an item record for. Please keep in mind that the PALS office highly recommends that you have item records for all titles, even your electronic resource records.
If you have any questions about this new report option, please submit them via the PALS Support Center