Scope:  This procedure contains instructions for processing withdrawals, transfers, and reinstatements in the Database Quality Unit.  Requests for these transactions typically come from selectors or from Collection Maintenance staff.  

Contact:   Pedro Arroyo

Unit:  Database Quality

Date last reviewed:  

Date of next review: April 2025



Withdrawals
Batch Single Volume Monographic Withdrawals
Transfers
Reinstatements
Medium Rare Annex
Additional Steps : Special Cases 


A. Withdrawals of physical materials in the collection:

I. Instance 

  1. Display Instance record. Verify that record matches book. If the title is marked "lost" or "missing", see special instructions below. 
  2. If the title is a serial, check for and report an open purchase order or ongoing subscription.
  3. For single-part monographs Click Actions→Edit Instance, and make the following changes in the Administrative Data section:
  4. Check the "Staff Suppress" box

Add an Administrative note with the proper coding for the withdrawal, using the format date:yyyymmdd ttype:w userid:[netid] ploc:lts    The macro for this is ,,w.

Examples (single-part and complete multivolume sets): 

(For single-part monographs):

(For withdrawing 3 volumes of a multivol:

II. Holdings record

 1. Display the appropriate Holdings record for the piece in hand:

2.  In the Holdings Notes, with Note Type: Note, enter "WITHDRAWN", and a short parenthetical note stating the reason, if available (e.g. lost, damaged, deselected, etc.), plus the date and your netID:

               


Make sure NOT to suppress the Instance and Holdings records if any of the other volumes are still associated with this Holdings.

3. If the part(s) being withdrawn are accompanying material that is included in the bibliographic description for the title (such as supplements or maps in a pocket), add a note specifying that the supplement/map/etc. has been withdrawn –   

4.  If you are withdrawing only certain parts or supplements from the Holdings, Edit the appropriate Holdings Statement(s) to reflect ONLY those holdings that are retained.  If you are withdrawing all parts of a multipart monograph or serial, however, retain the Holdings Statement information as is. 

5.  Save the Holdings record.

III. Item Record

1.  Display relevant Item record(s).

2.  For single-part monographs, delete the Item record by clicking Actions→Delete.  If the Item cannot be deleted because of dependencies or certain Item Statuses, bring the piece to the DBQ, Inputting, or Monographs Workflow supervisor, to Check-in the piece and remove the dependencies as applicable.

3.  For multipart monographs and serials, note item Enum/Chron information for the Holdings withdrawal note (if you have not already), and delete the Item records as described above.  

Make sure not to delete any item records for material that is NOT being withdrawn.

IV. Physical Disposal

1.  If you have the physical pieces in hand, stamp them "Withdrawn",  For books, the stamp can go on the inside front or back cover, title page, verso, or some combination of the above.

2.  Route the withdrawn, stamped physical pieces as follows: 



B. Batch Withdrawals: Single Monographic Volume or Complete Serial collections


For batch withdrawals of single volume monographs, a text file or Excel spreadsheet of barcodes of records to be withdrawn are sent to the Automation team. The list should have more than 25 entries. Lists of fewer than 25 entries will be processed manually by DBQ staff.

The batch withdrawal process is as follows:

  1. Text file or Excel spreadsheet is imported into DBeaver LDP and a separate table of the barcodes is created.
  2. A query, (or queries), is performed on the newly created table of barcodes. This is to acquire specific data needed to perform the batch withdrawal process. The primary data necessary to complete a batch withdrawal are the instance UUIDs, holdings UUIDs and the item UUIDs.
  3. Once item UUIDs are acquired, item records are deleted by means of a Perl or Python script.
  4. Utilizing the holdings UUIDs and a Perl or Python script involving the the Folio API, all holding work will be completed. This would include adding the withdrawal note in the holdings note, the transaction data note and the suppression of the holdings. Examples of withdrawal notes: Withdrawn (lost/missing) 3/12/20, netid or Withdrawn (dupe-deselected) 3/12/20, netid.
  5. If the holdings being withdrawn is the last CUL copy, the MARC bibliographic record will need to be suppressed.
  6. The corresponding instance UUIDs for the bibliographic MARC bibs will be used when implementing a Perl or Python script utilizing the Folio API to suppress the instance, if there are no other holdings attached with circulating material. The instance will not be suppressed if there is a valid holdings attached with circulating material.
  7. Spot check a few records in Blacklight to see if modifications have taken affect.
  8. Develop and run query in Dbeaver to verify bibliographic records of last CUL copy are suppressed and that all withdrawn holdings are suppressed and the items deleted.

Note: As of (05|16|2022), all scripts necessary to perform the aforementioned tasks in the Folio API are currently in development.


C. Transfers 

I. Initial Conditions

If the physical piece(s)-in-hand does not fit the conditions above, or has been cleared by the Serials or Cataloging supervisor, proceed to the following steps:

II. Single Part Item and Complete Multipart Item Transfers (for Partial Multi-Part Transfers, see section III below)

  1.  Display the Instance Record
    1.  Make sure the record is NOT suppressed in the database.  If it is suppressed, uncheck the Suppress from Discovery box. 
    2.  Enter an Administrative note for transfers using the format: date:yyyymmdd ttype:t userid:[netid] ploc:lts  The macro for this is ,,t
  2.  Display the Holdings record that matches the old location and copy number of the title and edition in hand.  If there is any discrepancy between the piece and its records, consult with the DBQ supervisor.
    1.  Make sure the record is NOT suppressed in the database.  If it is suppressed, uncheck the Suppress from Discovery box. 
    2.  Change the Permanent Location field to the new location.  
    3.  If needed, add an appropriate copy number in the Holdings record.
    4. Add a Holdings Note (with Note type: Noteshowing which collection the piece originally came from, and the date it was transferred.  Make sure the "Staff only" box is checked:

Exception: Not all transfers to the Annex require the Holdings note, as large transfer projects and book-moves can make it burdensome to add notes to every Holdings record.  LTS staff are still encouraged to add transfer notes for manual transfers whenever possible, however.

e.  Check the Oversize Chart for prefixes and/or suffixes appropriate for the new location, if applicable, and adjust the Call Number Prefix/Suffix fields accordingly.

3.  Search the database to verify that the old call number is NOT already in use for the new location. If it is, add publication date and work letter to the call number in the Holdings and on the piece in hand, or work letter only if call number already contains a date.  Consult with DBQ supervisor if needed.

Make sure to re-mark and re-label the piece if you make modifications to the call number.

4.  Save the Holdings record.


III. Partial Multipart Item Transfers  

  1. In the Instance record, add the Administrative note for Transfers as described above (best to use the macro ,,t)
  2. Display the holdings record that matches the old location and copy number of the title and edition in hand.
  3. Delete the volumes and/or numbers to be transferred from the original Holdings statements, INCLUDING supplements and indexes, if applicable.
  4. Save changes to original Holdings record.
  5. Display the holdings record that matches the NEW (destination) location and copy number. If there is no holdings record for the new location, skip to step 10 below.
  6. Verify that the destination Holdings record is not suppressed from discovery. If it is, UN-CHECK the "Suppress from Discovery" box.
  7. Add the appropriate "Transfer From" note to the Holdings Notes of the destination record (Note type: Note), as in the above example, but note which volumes were transferred. (e.g. "Vols. 3 and 4 transferred from Echols Ref.")
  8. Add the volumes and/or numbers to be transferred to the appropriate Holdings Statements of the destination Holdings record.
  9.  Save the destination Holdings.
  10. If there is no holdings record for the new location and copy number (including ANX locations, if you are transferring items to the Annex), create and edit one. Be sure to:

IV.  Item Records

Single Part Item and Complete Multipart Item Transfers  

a.  Display Item record. (After making and saving the appropriate changes to the Instance and Holdings) 

b.  Change Permanent Location field to match the newly-changed location in the holdings record.

c.  Edit the Permanent Loan Type, if appropriate -- for example: when transferring a title to or from a "Non-Circulating" reference collection. If you are transferring a title to a (Rare Annex #12a) location (e.g. "rmc,anx"), set the Item Type to "Non-Circulating". (NOTE: These are the only Annex locations for which the Item Type should be set to "Non-Circulating")

e. If the item status is checked out, missing, lost, etc., use consult with the DBQ supervisor, or check the piece in to change the status to "Available".

f.  Save the Item record

g.  Repeat for each item record associated with the transfer. 

 

Partial Multipart Item Transfers  

a.  Relink the item records for the pieces in hand, from the original holdings to the new (destination) holdings.

b.  Display each item record.

c.  Change Permanent Location to match the new Holdings record, as for single-part and complete sets, described above.

d.  Edit the Permanent Loan Type, if appropriate -- for example: when transferring a title to or from a "Non-Circulating" reference collection. If you are transferring a title to a (Rare Annex #12a) location (e.g. "rmc,anx"), set the Item Type to "Non-Circulating". (NOTE: These are the only Annex locations for which the Item Type should be set to "Non-Circulating")

V. Final Steps  

  1. Line out all previous location stamps -- (see exception below).
  2. Edit handwritten locations and call numbers in the book -- (see exception below).
  3. For serials, if you know that the new location is picking up an open subscription from the old location, write "Ongoing, currently received" on the location flyer. In addition, for unbound issues not barcoded separately, give recent issues (as displayed in the OPAC) to LTS Serials or Documents for further processing.
    If the transfers are computer disks , sound recordings   , or video recordings  , do additional processing if required for the new location.  Consult with a cataloger as needed.
    Exception: for unbound serials not barcoded separately, edit only the first and last issue in each bundle.
    Insert a location flyer and place completed transfers on the appropriate shelf (#12a) .
  4. Send the items to the Physical Processing unit for re-labeling and routing to the appropriate library.

  1. Search FOLIO for the piece.  If no record is found, import one from OCLC, or Input as applicable. (Instance Statistical Code: Source of Acquisition: miscellaneous)
  2. If there is an Instance record in FOLIO, verify that the record matches the book.
  3. Check for and report an open purchase order associated with the item, if applicable.
    1. If you find an open PO associated with the piece, see Special Instructions below.
  4. If the piece in-hand was the only copy cataloged in FOLIO, the Instance record may be Suppressed. If so:
    1. Un-check the "Suppress from Discovery" box in the Instance record. 
    2. Set the Catalog Date to the CURRENT date.

c. Save and Close the Instance record.

 

Save the Holdings record.

Display item record[s]. If no item record is found, create item record[s] and barcode book[s].

Re-display the bibliographic record. Add a 948 local statistics (Procedure #136 ) field to the record using the value "s" for the type of transaction.

  1. Cross out all "withdrawn" stamps.
  2. Edit penciled locations and call numbers, if needed.
    Insert a location flyer and place completed transfers on the appropriate shelf.