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: 10/11/2021

Date of next review: 10/15/2022

*As of 10/11/21, this procedure is still in the process of being updated for the FOLIO-based environment. 

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

 
General Rule: Determine whether to withdraw, transfer, or reinstate items based on the instructions found in Section "6. Disposition" of the "Selection Policy for Shelf Space Adjustment ", unless special circumstances apply. To determine if items are unique to CUL, follow these steps:

1. Search in FOLIO by title for other copies, and by series title, if online call number includes volume enumeration.
   
   

A. Withdrawals  

1. Display Instance record. Verify that record matches book. If the title is lost or missing, see special instructions below.
   
2. If the title is a serial, check for and report an open purchase order.
3. Display relevant item records:

   • For single-part monographs, delete item record . (Procedure #135)

   • For multipart monographs and serials, note item statuses and Enum/Chron information, then  delete item record(s) (Procedure #135) .
   • Any withdrawn item that is older than 6 months will be batch deleted by Batch processing periodically. <--(Double-check with Batch Processing)
4. Display relevant Holdings record:
   1. At the top of the Holdings, record, check the box to SUPPRESS FROM DISCOVERY.
   2. In the Holdings Notes, enter the transaction data for the withdrawal, using the format date:yyyymmdd ttype:w userid:[netid] ploc:lts

Note: the macro that will enter the above information is: ,,w (with the cursor in the Note field).                

                c. For multipart items, record the number of pieces withdrawn by adding "pcs: " to the end of the note, followed by the number of pieces withdrawn:

                 d. In a separate Holdings Note, with Note Type: Note, enter "WITHDRAWN", and a short note stating the reason (e.g. damaged, deselected, etc.)       

EXAMPLES of WITHDRAWN Notes/Reasons for withdrawal in HOLDINGS NOTES:

• WITHDRAWN (LOST), 8/21/00 abc
• WITHDRAWN (DAMAGED), 8/21/00 abc
• WITHDRAWN (DESELECTED), 8/6/00 abc
• WITHDRAWN (REPLACED BY PRESERVATION PHOTOCOPY), 9/24/00 abc

d.  When withdrawing only certain parts of a multipart monograph or serial, add specific information in the "WITHDRAWN" Holdings note on which parts are being withdrawn, and why. 

e.  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 –   Example:  Vol. 3 and accompanying maps WITHDRAWN (MISSING) 9/3/21

f.   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.

g.  If all volumes have been withdrawn, check the suppress from discovery box in the Holdings. Suppressing the Holdings will automatically queue the MFHD for deletion from OCLC.  For serials, also set the Receipt Status to "Not currently received."

h.  Repeat these steps for all copies and locations to be withdrawn.

5.  Re-display the Instance record:

a. If there are no active (unsuppressed) holdings records remaining for the title, suppress the Instance record from discovery.  Suppressing the BIB record will automatically queue the BIB record for deletion from OCLC.

b. If you have the physical pieces in hand, stamp them "Withdrawn."

c.  Dispose of the withdrawn physical pieces as follows:   Send to LTS Documents all items that bear a "Federal Publications" sticker, have been stamped "Depository", or have a "D" penciled on the cover, title page, or other preliminary pages.

      Otherwise:

• Place print serials in the recycle bin at your workstation.
• Place all other items on the withdrawn monograph book truck in LTS Rm.107E.      

Holdings Notes Examples for Withdrawals (where "abc"= staff NetID)

•         WITHDRAWN (LOST), 8/21/00 abc
•         WITHDRAWN (DESELECTED), 8/6/00 abc
•         WITHDRAWN (REPLACED BY PRESERVATION PHOTOCOPY), 9/24/00 abc
•         Vol. 3 WITHDRAWN (MISSING), 7/21/00 abc
•         Suppl. WITHDRAWN (DESELECTED), 8/18/00 abc $z Lacks suppl.
•         Vol. 8-15 WITHDRAWN (REPLACED BY PRES. PHOTOCOPY), 9/28/00 abc  

  ---

  
  

  B. Batch Withdrawals: Single Monographic Volume or Complete Serial collections
  
• Batch Withdrawal Process has been updated for FOLIO.
  

  
  

  For batch withdrawals of single volume monographs, a text file or Excel spreadsheet of barcodes of records to be withdrawn are sent to the batch processing team. Batch processing will only perform the batch withdrawal process if the count is greater than 25. Less than 25 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 the writing, (05|16|2022), all scripts necessary to perform the aforementioned tasks in the Folio API are currently in development.
  

• C. Transfers 

I. Initial Conditions

Transfer the item(s) online according to the instructions found in section "6. Disposition" of the " Selection Policy for Shelf Space Adjustment.  

If the transfer involves a title for "rmc,anx" or one of the "ranx" sublocations, follow the Rare Annex (12a) instructions below.

If the transfer involves superseded editions or volumes, see also Special Instructions below.

If the title is a serial, check for and report an open purchase order. 

If the title bears a "Pamphlet" call number, send it to the Library Annex.

Process the physical piece(s) as follows (except for Rare Annex material)      

II. Single Part Item and Complete Multipart Item Transfers 

1.  Display the Holdings record that matches the old location and copy number of the title and edition in hand.

2.  Verify that the record is NOT suppressed from public view. If it is suppressed, uncheck the Suppress from Discovery box.

3.  Change the Permanent Location field to the new location.  

4.  If needed, add a copy number in the Holdings record and Item records.

5.  Check the Oversize Chart for prefixes and/or suffixes appropriate for the new location.

6.  In the Holdings notes, enter transactions for Withdrawal (,,w), and for Added Location (,,l) OR added copy (,,a, if transferring something to a collection that already has a copy), plus a note  showing which collection the piece originally came from, and when it was transferred:

Exception: Transfers to Annex do NOT require a transfer note

7.  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 already in use, or work letter only if call number already contains a date.                                                                                                                               

8.  Save and close the Holdings record.

III. Partial Multipart Item Transfers  

1. Display the holdings record that matches the old location and copy number of the title and edition in hand.
2. Delete the volumes and/or numbers to be transferred from the Holdings statements, INCLUDING supplements and indexes.
3. Display the holdings record that matches the new location and copy number. If there is no holdings record for the new location, skip to "8" below.
4. Verify that the record is not suppressed from the OPAC. If it is, uncheck the Suppress from Discovery box.
5. Add the appropriate "Transfer From" note to the Holdings Notes (Note type: Note), as in the above example.
6. Add the volumes and/or numbers to be transferred to the appropriate Holdings Statements.
7. Save the Holdings record.
8. 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:
   
   • Check the Oversize Chart for prefixes and/or suffixes appropriate for the new location.
     
   • Search FOLIO to verify that the old call number is not already in use for the new location. If it is already in use, add a w suffix to the last cutter in the call number.
     
   • Add an appropriate transfer note to the Holdings note, as in the above example.
     
   • Include appropriate Holdings statements for volumes, supplements and indexes.

IV.  Item Records

1. Single Part Item and Complete Multipart Item Transfers  

   a.  Display item record.

   b.  Change Permanent Location field to match 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")

   d. ***ITEM STATUS CHANGE: POSSIBLE UNDER CURRENT PERMISSIONS?***Click on the graph button. If Withdrawn appears under status, remove it.

   e.  ***SAME AS ABOVE-- WOULD WE REMOVE "Deselected" Holdings note instead? Click on the quill pen button. If deselected note appears, remove note.

   f.  Save the Item record

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

    

2. Partial Multipart Item Transfers  

•       a.  Relink the item records for the pieces in hand from the old holdings record to the new holdings record.
•       b.  Display each item record.
•       c.  Change Permanent Location to match location in the Holdings record.
•       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")
•      e.  Click on the graph button. If Withdrawn appears under status, remove it.
•      f.  Click on the quill pen button. If deselected note appears, remove note.
•      g.  Save the record to Voyager.
•      h.  Repeat for each item record.
  

V. Final Steps

1. Re-display the Instance record.  If it is suppressed, uncheck the suppress from Discovery box.
   
2. Add two 948 local statistics fields to the record: one for the withdrawal; another for an added copy, an added location, or added volumes -- as appropriate. If you unsuppress the bib record, add an additional 948 to indicate a fast shelve statistic (,,s).  Note: If a new BIB record is created, add additional 948 statistics fields for inputting ( ,,i ) and fast-catting ( ,,f ) to insure that the record is exported to OCLC as a newly cataloged record.
3. Save the record to the database.
4. Line out all previous location stamps -- see exception below.
5. Edit pencilled locations and call numbers -- see exception below.
6. 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.
   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) .
   

• Examples  
  
•   Transfer from Uris, 3/13/03
•   Vols. 1-8 transferred from Uris, 3/13/03  

• D. Reinstatements

1. Search FOLIO for the piece. If no Instance record is available in FOLIO or OCLC, forward item(s) to the LTS Inputting Supervisor to be processed as new (Instance Statistical Code: Source of Acquisition: miscellaneous)
2. If there is an Instance record in FOLIO, verify that record matches 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 piece cataloged in FOLIO, the Instance record will likely be Suppressed.  
   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.

• Display Holdings record.
• In the Holdings Notes section, remove the "WITHDRAWN [date/initials]" note.
• Add REINSTATED [date] to the Holdings Notes field following the call number:

If necessary,

Select system tab.

Uncheck the Suppress from OPAC box. Record should display in the OPAC.

Click on Leader. Change the record status value to 'c'.

Save the record.

Display item record[s]. If no item record is found, create 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. •  

   • If there are multiple holdings records for the title:
     • Display holdings record that matches book in hand.
     • Remove |x WITHDRAWN [date] and [initials] from the 852 field following the call number.
     • Add |x REINSTATED [date] to the 852 field following the call number.
     • If necessary, add 8XX fields .
     • Select system tab.
     • Uncheck the Suppress from OPAC box. Record should display in the OPAC.
     • Click on Leader.  Change the record status value to 'c'.
       
     • Save the record.
     • Display item record[s]. If no item record is found, create record[s] and barcode book[s].
     • Re-display the bibliographic record. Add a 948 local statistics field to the record using the value "s" for the type of transaction.  
       

• 1.  Process the physical pieces as follows:

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.
      
   

• E. Medium Rare Annex
• See Instructions for Rare Annex Transfers Processing (LTS Procedure #12a)
• 
  

• F. Additional Steps: Special Cases
• 1.  Lost and missing titles:
• If you delete the sublocation "anx", edit the Permanent Location on the item record(s) to match the Holdings Permanent Location.
• 2.  Open purchase orders: when withdrawing or transferring serials, and for all reinstatements, check to see if there is an open purchase order for the title:
• a.  With the Acquisitions Client open in the background, type [control] m to bring up a line item screen. If multiple line items are attached, select the appropriate location from the Line Item Summary, then click on Details to bring up the appropriate line item screen.
• b.  With the appropriate line item screen displayed, click on the Order tab, then click on the ellipsis in the Order Number field.
• c.  Verify that the Location is correct.
• d.  Check the title bar at the top of the screen. If it states that the purchase order is complete or canceled, do nothing. If it states that the purchase order is approved/sent or pending, send an e-mail notification to Supervisor of either Monographic or Serials processing as appropriate. In the e-mail, give the following information:
• Action (withdrawal or transfer)
• Brief serial title
• BIB ID
• Purchase Order Number
  
• 3.  Rare Annex Transfers (Procedure #12a)
  
• 4.  Selection Policy for Shelf Space Adjustment. --additional guidelines:
• a.  Retain a unique print copy of an item if the only other manifestations in CUL are microform, CD-ROM, or networked resorce. Do not retain a unique microform if the title is available in print.
• b.  When filling in serial "back volumes missing in other units," retain volumes (numbers, issues, etc.) that are unique to CUL but do not retain additional copies, even if there is more than one incomplete serial run in CUL.
• 5.  Shelves for completed transfers and reinstatements:
• a.  For Rare Annex transfers, see Special Instructions (Procedure #12a) otherwise:
• b.  Deliver all unbound serials that are not separately barcoded to Collection Management--Serials, otherwise
• c.  Place items on the appropriate Physical Processing truck at the east end of Room 110, if remarking is required (e.g. location or call number on spine are incorrect).
  
• d.  If remarking is not required, place items for Olin, Kroch, or Uris on the "return to stacks" shelf in Room 107E or 110. Place items for other libraries on the outgoing mail shelves in Room 110.
• 6.  Superseded editions or volumes: add appropriate notes to holdings records to indicate the treatment of these "ongoing" transfers. For example:
• 852 ... $z Latest ed. only.
• 852 ... $z Latest ed. in Reference.
• 7.  State-supported library:
• If any CUL state-supported library is withdrawing material, the following procedure will apply:
• a.  The withdrawing library will:
  • Create a list of material for withdrawal.
  • Post list to SUNY listserv   SUNYLA-L@LISTSERV.BINGHAMTON.EDU offering material for quick disposal to other SUNY libraries.
  • Specify last date responses will be accepted.
  • Take responses and tag material for shipping to designated libraries using UPS call tag.
  • Obtain shipping and delivery information from requesting library. Shipping costs will be borne by the requesting library.
  • Send materials to LTS Database Quality staff for withdrawal, along with shipping information as appropriate.
• b.  Technical Services staff will:
  • Receive material for withdrawal (DBQ).
  • Update records in voyager for withdrawn titles (DBQ).
  • Ship requested material to designated library (G&E).
  • Discard remaining volumes in accordance with CUL's general withdrawal policies (DBQ).
  • Work with library accounting to collect shipping fees, if necessary (N/A with UPS call tag).
• 8.  Withdrawal requests from publishers:
• a. When selectors inform LTS that the Library has received a request from a publisher to withdraw a particular title (usually because of controversial or erroneous content), but that request has been refused, add the following note to the appropriate Voyager BIB record:

• 500 ## $aPublisher withdrew this title from publication in light of controversy about its content.

• b. For more information about these situations, see Collection Development's Policy on Returning or Destroying Materials o n Request.
• 
  
  
•