Refer for Replacement Procedures for Missing and Billed Items
The complete refer for replacement process relies on a wide range of library staff and a commitment by all units to follow these shared procedures. The process for selector notification of missing items and transmission of replacement decisions, which used to depend upon paper cards, will now be done with Millennium-generated reports in the form of Excel spreadsheets.
On a regular schedule, selectors are responsible for finding and sorting out their titles and indicating replacement selections to the appropriate staff; circulation staff are responsible for clearing holds; designated staff are responsible for updating item record statuses and submitting orders; systems staff are responsible for running the batch withdrawal of item records; and processing staff are responsible for handling replacement copies and updating holding records.
There is one schedule for the “Missing 3 Months +” and “Billed/Paid” lists, and another schedule for the “Billed/Not Paid” list due to different actions needed. Items shelved at NRLF that are missing or lost will go through a similar but different process, outlined in “Refer for Replacement: NRLF materials."
These procedures outline the steps for library staff working with “Missing 3 Months +”, “Billed/Paid” and “Billed/Not Paid” lists to:
Given limited collection budgets and shelving space, selectors will continue to choose replacements with due care, considering the availability of circulating paper copies at Berkeley, Stanford, or an RLF. Selectors may also want to check for the availability of an e-book in Google Books, HathiTrust, or The Library’s collection of licensed and purchased titles.
Reviewing “Billed/Paid” and “Missing 3 Months +” Lists:
Selectors will consult the “Billed/Paid” and “Missing 3 Months +” lists each quarter on January 5, April 5, July 5, and October 5 and send their decisions about titles they wish to replace to the designated staff member by the end of that month. The designated record updater will complete all their work by February 20, May 20, August 20, and November 20 and Systems will withdraw the records on March 1, June 1, September 1, and December 1.
Reviewing “Billed/Not Paid” Lists:
Selectors will consult the “Billed/Not Paid” list each quarter on February 5, May 5, August 5, and November 5, and send their decisions about titles they wish to replace to the designated staff member by the end of that month. The designated record updater will complete all their work by March 20, June 20, September 20, and December 20 and Systems will batch suppress (pseudo-withdraw) the records on March 1, June 1, September 1, and December 1.
For all lists:
1. The selector and/or review coordinator for each library location (listed in Appendix 1) retrieves the reports from the “Referred to Selector” site: http://www.lib.berkeley.edu/cgi-bin/notices/refer2selector.cgi.
Choose report type and location from the dropdown menus, then click submit to open the report spreadsheet in Excel. Reports for Gardner (MAIN) Stacks are also posted on the Doe/Moffitt Staff Wiki under “Collections”: http://www.lib.berkeley.edu/wikis/doemoff/index.php?n=Main.Collections.
The reports that must be reviewed are:
2. Selectors review the reports to identify the items they wish to replace.
Reports have the following columns (see screenshot in Appendix 3):
Rows may be deleted. Do not change, delete, or rearrange any columns. Do not add any columns on the left side or in the middle of the data.
Spreadsheet cells to be filled out by the selector, as needed:
Spreadsheets may be sorted. The embedded live links to Oskicat records facilitate the selector’s fact gathering during the decision-making process. These live links will also be used by staff with Millennium record maintenance authorization to go into the records to update status codes to reflect the selector’s decision to replace. A list of status codes appears in Appendix 4. Selectors will use the cells in the last group of columns (starting with “fund to be used for replacement”) to enter replacement preferences. There is no need to note availability of replacement copies because that information can be outdated, erroneous or not the best purchase option.
In the “Holds” column, the notation “yes” means a patron requested this item within the last six months, which may factor into the selector’s decision whether to replace. Note: all holds will be canceled or transferred to another available copy before an item is withdrawn.
If an item on a report list is no longer missing, either because it is currently checked out or was located on a final search and recently checked in, it will automatically drop from the list the next time the list is generated.
After August 2012 selectors can be assured that all items remaining in the Moffitt Library collection will be transferred to the MAIN collection and will be physically integrated prior to the Moffitt renovation. Before August 2012, if a copy of another location’s missing item is in the circulating collection of Moffitt, selectors should email Jan Carter requesting a transfer of the Moffitt copy, indicating it is to replace an RFR item and providing the title and item number.
3. Selectors notify designated staff (listed in Appendix 1) of items they wish to replace.
This step is not critical before the withdrawal or suppression of item records since items can be replaced or re-ordered at any time, though it is wise to consider replacement now to ensure regular decision making.
After selectors have filled in the appropriate cells with instructions for ordering the items identified to replace, their final product will be an Excel file that includes only the items they have chosen to replace. The list should not include items pending later decision, items not to be replaced, items submitted for photocopy replacement ordered through the Preservation Department, or items which have a current active replacement order in Millennium.
It may be easiest to create a new Excel file in which to copy and paste the full row of information about each item chosen to replace; another approach would be to delete all rows for items not chosen for replacement. The selector sends that Excel file of items to order to the unit designee who will update item record status codes and forward to the Ordering Unit.
For consistency, follow these conventions for naming your files:
selectorlastname reportname monthabbrev year .xls (omit spaces)
Example: “burnettemissingoct2011.xls” or “burnettebilledpaidoct2011.xls”
4. Follow the next steps based on the type of list being reviewed:
Bioscience and Natural Resources:
Gardner (MAIN) Stacks:
Institute for Research on Labor and Employment:
Institute for Transportation Studies:
Institute of Governmental Studies:
Media Resources Center:
Items are searched:
Sample report from the “Referred to Selector” page as viewed in Excel:
Item record status codes, which may be helpful to you when looking at records in OskiCat, are:
- DUE [date]
! ON HOLDSHELF
$ BILLED & PAID
1 ON SEARCH (searched once)
2 ON SEARCH (searched twice)
3 ON SEARCH (searched 3 times)
a NEW-BOOK SHELF
b AT BINDERY
c MISSING (referred for order)
e ON EXHIBIT
f MISSING (referred to selector)
i IN REPAIR
m ON SEARCH (reported missing)
o LIB USE ONLY
p IN PROCESS
t IN TRANSIT
z CLAIMS RETURN
NOTE: a more detailed flowchart is available by clicking here.