You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 87 Next »

Scope:  This procedure contains instructions for processing withdrawals, transfers, and reinstatements in Database Quality.

Contact:   Pedro Arroyo

Unit:  Database Quality

Date last reviewed: 09/8/2021

Date of next review: 9/15/2022

*As of 9/1/21, this procedure is 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:
  4. Display relevant Holdings record:

a.  In the Holdings Notes, enter the transaction data for the withdrawal, using the format date:yyyymmdd ttype:w userid:[netid] ploc:lts

b.  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 (see third illustration below).

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

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

 

d.  When withdrawing only certain parts of a multipart monograph or serial, include in the "WITHDRAWN" note specific information on which parts are being withdrawn –   Example:  

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:  

f.  Edit the appropriate Holdings Statement(s) to reflect ONLY those holdings that are retained. However, if you are withdrawing all parts of a multipart monograph or serial, 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 Single Volume Monographic Withdrawals
  • Batch Withdrawal Process has been updated for FOLIO. However, certain aspects of this process are still in development

    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, (currently Peter DelaCuadra). 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.
    2. A query, (or queries), is performed to verify that the data is as expected. (Looking for things such as unexpected multi-volume monographs, serials, items checked out, etc., any abnormalities are routed to DBQ for manual processing)
    3. Once data is verified as expected, item records are deleted by means of a Perl or Python script. (as of this writing, 9|17|2021, script is in process of development)
    4. Holdings are then harvested from Folio. MARCEdit will be used to edit the previously harvested holdings to follow the manual withdrawal steps. (Change LDR position 5 to "d" and add staff note in Holdings Note section "Withdrawn ([reason for withdrawal] date, net id)". For example: Withdrawn (lost/missing) 3/12/20, pd36 or Withdrawn (dupe-deselected) 3/12/20, pd36.
    5. The corresponding bibliographic MARC bibs are harvested from Folio as well. A 948 batch withdrawal statistic is added into the MARC record.
      For example: 948 2_ $a 20151212 $b w $d batch $e lts
    6. The MARC bibliographic records are re-imported back into Folio using Data Import with the correct import profile. (as of this writing, 9|17|2021, an import profile has not been written yet).
    7. If the holdings being withdrawn is the last CUL copy, the MARC bibliographic record will need to be suppressed.
    8. The corrected holdings records are also re-imported back into Folio using Data Import with the correct import profile. (as of this writing, 9|17|2021, an import profile has not been written yet).
    9. 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.


  • C. Transfers  
  • AS OF 9/10/21, THIS SECTION PENDING REVISION

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), 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 CUL catalog record is available in Voyager or OCLC, forward item(s) to the LTS Inputting Supervisor to be processed as new.
  2. Check for and report an open purchase order.
  3. Display bibliographic record. Verify that record matches book.
  4. Select Record > Show Associated Records. A Holdings and Items for bib box displays.
    • If there is a single holdings record for the title:
      • Select bibliographic record.
      • Select system tab.
      • Uncheck the Suppress from OPAC box and change the record status value to "c" in the leader area. Record should display in the OPAC.
      • Save the record.
      • Display holdings record.
      • Remove |x WITHDRAWN [date] and [initials] from the 852 field following the call number.
      • Add REINSTATED [date] to the Holdings Notes 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 (Procedure #136 ) field to the record using the value "s" for the type of transaction.

    •  

    • 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.
       
  • 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 852 $b in the MFHD.
  • 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 Lisa Maybury if the site is Acquisitions or Documents, or to Deb Warfield if the site is Serials. 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.



  • No labels