Batch bib record suppression and unsuppression

Author: Mark Hemhauser
Posted in: Systems

Procedure

Each Thursday night create lists are run to identify:

  1. Bib records that are not already suppressed because they are withdrawn (i.e., bcode3 is not w) which have only bib locations of zw (ie, zw, zwz, zwg, zwt).
  2. Bib records which are already suppressed because they are withdrawn (i.e., bcode3 is w) which have orders
  3. Bib records which are already suppressed because they are withdrawn (i.e., bcode3 is w) which have an attached item with an internal note containing the text “withdrawn then found”

On Friday morning these lists are used in the following ways to suppress or unsuppress bib records:

  1. Bib records that are not suppressed but have no active holdings or items (based on a bib location with no “real” locations) are suppressed if:
    • There are no order records on the bib
    • Any orders are historic. If there is a current replacement order (placed in the past 18 months) the bib is NOT suppressed.
  2. Bib records that were already suppressed because they are withdrawn are unsuppressed if they have orders that are current. Historic orders do not trigger unsuppression.
  3. Bib records that were already suppressed because they are withdrawn are unsuppressed if a withdrawn item has been found and reinstated by circulation staff, based on the internal note.

Related documentation:

OCLC holdings: setting holdings in batch

Batch withdrawal

Refer for replacement

Reinstating withdrawn items

Bcode3 use

Query for #1:

BIBLIOGRAPHIC  Location  All Fields don’t have  “a”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “b”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “c”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “d”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “e”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “f”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “h”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “i”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “j”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “k”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “l”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “m”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “n”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “o”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “p”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “q”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “r”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “s”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “u”    AND BIBLIOGRAPHIC  Location  All Fields don’t have  “v”    AND BIBLIOGRAPHIC  Location  starts with  “z”    AND BIBLIOGRAPHIC  Location  matches  “[^g….]”    AND BIBLIOGRAPHIC  Location  matches  “[^ig…]”    AND BIBLIOGRAPHIC  Location  matches  “[^..9g.]”    AND BIBLIOGRAPHIC  Location  matches  “[^t…]”    AND BIBLIOGRAPHIC  Location  matches  “[^.t…]”    AND BIBLIOGRAPHIC  Location  matches  “[^..9t.]”    AND BIBLIOGRAPHIC  Location  matches  “[^oht]”    AND BIBLIOGRAPHIC  Location  matches  “[^eat]”    AND BIBLIOGRAPHIC  Location  matches  “[^nbt..]”    AND BIBLIOGRAPHIC  Location  matches  “[^nbmt.]”    AND BIBLIOGRAPHIC  Location  matches  “[^zzzzz]”    AND BIBLIOGRAPHIC  Bib Code 3  not equal to  “w”    AND BIBLIOGRAPHIC  Bib Code 3  not equal to  “d”

Query for #2:

ORDER  Order Date  greater than  “[date 18 months previous]”    OR (ORDER  Status  equal to  “o”    OR ORDER  Status  equal to  “q”    OR ORDER  Status  equal to  “f”)

Query for #3:

BIBLIOGRAPHIC  Bib Code 3  equal to  “w”    AND ITEM  Internal Note  starts with  “withdrawn then found”

Legacy Data

Author: Jim Gordon
Approval Group: CSG, BTech, Cataloging and Metadata Council
Update Group: Integrated Library System Steering Committee
Last updated date: 03/18/13

Archived Comments

Minor changes
Mon, 03/18/2013 – 14:26 — Trina Lopez
Just did some punctuation and grammatical changes. No changes to content.

Updates
Fri, 08/31/2012 – 15:19 — Charis Takaro
Adjusted the related documents and updated the handling of last withdrawn items that have current orders to reflect current practice.
CSG – this is just FYI since
Thu, 11/17/2011 – 15:49 — Jim Gordon
CSG – this is just FYI since it pertains to withdrawal.

Created: May 14, 2016
Last revised: November 7, 2016
Review date: None set

Leave a comment

Your email address will not be published. Required fields are marked *