• DWM#1 Exceptions Reports (Daily)
  • Failures (Daily)
  • Non-Failures (Daily)
  • Accession Discharge
  • Alias Check (Weekly)
  • Reconciliation Report (Weekly)
  • Collection Agency (Monthly)
  • Missing In Transit Stats (Monthly)
  • Orphan Stats (Monthly)
  • Patron Group Population Stats (Monthly)
  • Proc Stats (Monthly)
  • Transfer Schedule (Monthly)

Reserves Quarterly


Accession Report

What are Accession Reports?

Every week CUL retrieves a file from LAS database at ReCAP documenting the week's accessions.  LITO staff use this report to update CLIO locations and add the request button in the OPAC.  The Accession Report categorizes irregularities resulting from the CLIO update.  See below for complete list of problem categories.

Copies of the Accession Report are emailed to core staff.  Hard copy of categorized reports is printed for MRP staff with scannable barcodes.  MRP staff resolve problems and complete CLIO update.

Problem Categories on Accession Reports

  • BADLOC (Bad Location): Item with CLIO location not authorized for offsite transfer or mis-match between holdings and item record CLIO location.  MRP staff manually changes CLIO locations from encoding pattern xxx to off,xxx.
  • TEMP LOCATION: Item with encoding in any of the three Temp. fields in the Voyager item record.
  • CHECKED OUT: Item that have an active charge to a status patron (pseudopatron).  This category is mainly books processed by BSP (Binding and Shelf Preparation).  Regular, charged ReCAP returns are resolved by LITO staff during a weekly reconciliation.
  • IN TRANSIT: Item discharged from a non-owning Voyager Circulation happening location result in In Transit status.
  • SUPPRESSED: BIBL or HLDG record is currently suppressed.  Depending on the nature of the record, it may be unsuppressed.  Under- or unprocessed collections retain suppression to control access.  Duplicate serial runs also remain suppressed.
  • INACTIVE: Only one barcode in an ITEM record can be "Acitive."  If the offsite barcode is "Inactive" staff manually make it "Active."
  • DUPLICATE: Identical offsite barcode was assigned to two separate item records.  Item must be recalled to determine correct barcode assignment.
  • LOST/SYSTEM APPLIED BARCODES: Item status set to "Lost".  Once status is removed the item is immediately available for request.

Example Accession Report


Example pictured to the right, excluding problem categories. Details listed below.

TODAY'S FILE IS recap.d20120106.d20120112: Date range for current accession report.

  • new records read: Total number of items that were accessioned by ReCAP during period
  • old not found records read: Items that are currently accessioned in LAS but not entered in CLIO
  • total records read: Total number of items that were accessioned by ReCAP during period plus all previously not found records
  • bad locations: Items is BADLOC problem category
  • records not found: Total not found after report was run. Commonly referred to as orphan barcodes and require staff resolution
  • not found were RS records: Added at MRP's request
  • have temp locations: Items in TEMP LOCATION problem category.
  • already have offsite locations: Items that were already assigned off,xxx locations before transfer. Typically new serial issues added to title already off-site
  • barcodes with lost status: Items found with "Lost" Item Status (may or may not have an active charge)

BILO (BIND/INTR/LABL Overdue) Report


Quarterly Overdue Lists include all items charged to a status patrons of type: xxxBINDxxx (Binding), xxxINTRxxx (In Transit) or xxxLABLxxx (Labelling).  See DCMM-180 for more information.

"Offsite" report includes all items with CLIO locations xxx4off and off,xxx.  It is monitored by the ReCAP Coordinator. 

CLIO location xxx4off indicates that the item is a new acquisition and may be queued for transfer to ReCAP (84.1% of Feb 2010 report).  Once successfully transfered and accessioned, barcodes appear on the weekly Accession Report for MRP staff to discharge (see section CHECKED OUT).  Estimated timeframe for accession at ReCAP is 2-4 weeks after both charge and physical transfer.  Items charged for more than 12 months will be charged to a ReCAP Missing status patron.

CLIO location off,xxx indicates that the item is a new serial acquisition queued for transfer or that the item has been identified for preservation, re-binding or labelling (15.9% of Feb 2010 report).  Items charged for more than 12 months will be charged to a ReCAP Missing status patron.

Items may be currently staged for transfer, in transit or at ReCAP waiting for processing.  Since staff reduction at ReCAP in June 2009, the timeframe between physical transfer and accession has lengthened.  In October/November 2010 the transfer time for new acquisitions lengthened considerably, caused by a shortage of wooden carts available to BSP staff.

N.B. Because of the extended timeframe for the routine transfer of items to ReCAP compared to on campus shelving, a new composit Offsite report was created in November 2009 (discussed at the September 2009 meeting of CCMSCC).  In mid-2011 the timeline returned to normal, accessioning 2-4 weeks post-transfer.

Procedure for resolution

Barcodes that have been charged to a BILO status patron for more than 12 months are charged to one of two status patrons: RCPMISS001 or RCPMISS002.

  • Correct any obviously mis-scanned barcodes, check LAS to verify it is IN
  • Onsite barcodes are likely orphans; check each one to see if it there are two ITEM records for same volume.  If second ITEM is at ReCAP, discharge and delete the "ghost" ITEM
  • Check Hierarchy for irregularities and request volumes as needed
  • Batch query LAS status of unresolved barcodes
  • RCPMISS001 is used for all items that are currently NOT ON FILE at ReCAP (have not been accessioned)
  • RCPMISS002 is used for all items that are currently OUT at ReCAP (accessioned and retrieved)
  • If barcode status is DELETED, discharge item

It is not worthwhile conducting shelf search for items on BILO report.  Experiement search in Fall 2011 found no books.

If an item charged to either status patron is accessioned or returned, it will be automatically discharged by MRP as part of the weekly Accession Report.  If not accessioned or returned, items will flow onto departmental NRTN reports to be searched, replaced or withdrawn.

  Feb 2010
May 2010
Aug 2010
Nov 2010
Feb 2011
May 2011
Aug 2011
Nov 2011 Feb 2012 May 2012 Aug 2012 Nov 2012 Feb 2013 May 2013 Aug 2013 Nov 2013
Total (Year+) 872 (108)
208 (13) 351 (45) 540 (28) 1614 (9) 630 (29) 452 (76) 488 (104) 366 (92) 353 (57) 160 (18) 310 (14) 188 (27) 154 (18) 197 (30) 206 (29)
Charged to RCPMISS001 unknown unknown
22 17 6 29 56 100 81 53 12 12 23 14 23 27
Charged to RCPMISS002 unknown
23 11 3 0 20 4 11 4 1 2 4 4 7 2

Claim Returns

Claim returns are referred to the ReCAP Coordinator by department circulation staff.  All are logged in an .xlsx file.  On a quarterly basis query the status of all outstanding claim returns.  If the item has been returned to ReCAP, alert the reporting staff member.

  Aug 2013 Nov 2013
Outstanding Claim Returns 21 20

DWM#1 Exception Reports

Exception reports are daily reports resulting from circulation activity. 

They are generated daily for departments and stored in individual circ desk folders on the L: drive.  For Delivery Services they may be found in 2 places:

  • Borrow Direct/ILL are in L:\Lito-Circulation-Reports\Borrow Direct
  • Offsite are emailed daily to  These were created in August 2011 and include offsite CLIO Locations from all happening locations.
  1. Missing In Transit
  2. Transaction Related Exceptions
  3. Item Related Exceptions

Circulation Statistics (Borrow Direct)

Represents the total activity each business day in the Borrow Direct happening location. 

The majority of the activity will be performed by bdrelais, representing items that were charged during Shipping or discharged during Completing.

Staff UNIs will appear, corresponding both to activities related to Front Desk Duty and collection maintenance follow up for books not found on shelf.

Missing In Transit (Borrow Direct and ReCAP)

When an item is discharged from a non-owning happening location it is assigned status "In Transit Discharged."  If it is not discharged from the owning happening location after 7 days, it is considered missing and included on this report.  Only items with Perm Loc off,xxx will appear on this report.  The number of items on this report fluctuates from day to day.

The number of items on this report depends on one of three factors: 1) CUL staff discharging from the correct happening location, 2) timely resolution of the Reconciliation Report, and 3) timely check-in of returns by ReCAP staff.

Statistics are compiled monthly to monitor overall trends and once annually longstanding (12+ months) items are charged to Missing.  An indication of a systematic problem is a monthly report of 100+ persisting titles.  Longstanding items should be evaluated on title-by-title basis before charging.

Most items are routinely resolved every Friday as part of the Reconciliation Report.  They were accidentally, improperly discharged at time of return or in processing before transfer.

Reserve books may be improperly discharged.  Books can be found on shelf but OPAC display indicates unavailability.  A new column for Temp. Loc. was added to the report on 10/26/2011 to quickly identify Reserve books with location xxx,res. Alert relevant Reserve desk staff to verify and discharge.


Report was revised on 1/20/2012.  Only Monday report had included all happening locations and included many duplicate entries.  Both issues resolved by eo33.

Periodically check LAS status by batch file, some new accessions are not discharged properly. 

Items that persist on this report longer than six months can be charged to RCPMISS002.

Problem categories and resolutions:

  • xxx,res Temp. Loc. : refer to relevant Reserve desk to verify and discharge
  • xxx2xxx Temp. Loc. : if LAS status is IN or REF, clear Temp. Loc. and discharge


Once annually charge items to RCPMISS002 that have been In Transit for more than 12 months.

  FY13 FY14 FY15
Charged to RCPMISS002 1    

Transaction Related Exceptions (Borrow Direct and ReCAP)

Items with designated Item Statuses assigned.

  • Cataloging Review : ignore if barcode begins OTF

Hold Shelf Expired (Borrow Direct)

Represent items that were recalled using the Borrow Direct status patron BDSTAFF001.  All can be ignored since the returns are immediately routed back to the lending partner.

Item Related Exceptions (Borrow Direct and ReCAP)

Item Related Exceptions represent items that either have a policy group or Item Status issue.  There are many different types of exception, only a few require staff action:

  1. Lost Item Charged : Remove Lost Item Status in Voyager, find associated patron fines in Circulation module and dismiss any corresponding fines as appropriate
  2. Lost Item Discharged : Remove Lost Item Status in Voyager, find associated patron fines in Circulation module and dismiss any corresponding fines as appropriate
  3. Missing Item Charged : Remove Missing Item Status in Voyager
  4. Withdrawn Item Charged : Remove Withdrawn Item Status in Voyager
  5. Foreign Item Charged : No action

ILL QR#2 - Overdue BD Lending Report


This report is run quarterly and includes all items charged to active Borrow Direct status patrons


All books are meant to be searched on a quarterly basis.  Search list consists of all items that have been charged for more than 6 months since generation of report.  Most items have been lost/damaged or are long overdue to the partner's patron.  Find rate is expected to be low.  Found books were likely missed during Completion processing. 


  1. Isolate items that have been charged for more than 6 months
  2. Student workers search by call number and verify match by barcode
  3. All search results are noted on the search list and found books given to Supervisor to be discharged and marked as Complete
  4. Books not found that have been charged for 12+ months will be charged to ILLMISS005 (2016 policy change based on very low rate of long overdues not returned)
  5. NOTE: best practice to look in Relais record of books 12+ months - if noted as missing or damaged, bill the borrowing institution
  6. If a book has been marked as "returned" but not "completed," charge it to ILLMISS005


Charged out X ago
Apr 2015 July 2015 Oct 2015 Jan 2016 Apr 2016 July 2016 Oct 2016
Jan 2017 Apr 2017 July 2017 Oct 2017 Jan 2018 Apr 2018 July 2018 Oct 2018
13+ months 25
5 7 5
10 7 11
12 months 1 0 2 2 6 5 5 3
3 3          
11 months 5 4 5 6 6 2 5 4
13 6          
10 months 3 8 4 14 9 2 3 5
8 9          
9 months 5 3 2 11 6 6 4 4
3 10          
8 months 12 9 9 7 6 7 6 13
9 6          
7 months 25 4 23 11 11 5 7 14
22 5          
6 months 10 10 18 9 21 8 11 8
34 19          
5 months 31 22 11 13 27 19 16 26
30 14          
4 months 136 57 41 241 72 92 53 248
96 76          
3 months 1,431 423 364 794 1,281 388 286 741
1,374 338          
2 months 1,697 550 542 1,194 1,867 609 829 1,181
1,601 631          
1 month 2,432 978 2,330 1,301 2,200 913 2,433 1,235 2,069 820          
  Oct 2016
Jan 2017 Apr 2017 July 2017
To Search 47 54   58
Found 3 2    

ILL QR#3 - Overdue BD Borrowing Report


This report identifies Columbia patrons who have long overdue Borrow Direct books.  Using the report staff contact patrons directly to encourage return. 

Policy and practice for handling lost, damaged & long overdue books can be found on the Delivery Services wiki.

Long Overdue Notice will only be sent to patrons when books are Overdue Lost, 6-12 months after original charge date.  They are alerted that if Columbia pays an invoice from a lending institution, they will be required to pay the replacement fine.  In such case the book return will not be accepted.  Corresponding notes are made in the patron's Voyager record for LIO staff's information.

The process is intended to minimize the number of invoices sent by partner institutions.  Handling invoices is a time consuming process for staff and is preferably avoided whenever possible.   


  • Remove the Lost Item Status from all books that are Not Charged Out | Lost (housekeeping function to make sure the OTF is purged)
  • Isolate all books that are Overdue | Lost 6-12 months after the original charge date
  • Send emails to all patrons who have long overdue books, cc the Columbia Borrow Direct alias and Add Note in Relais for record keeping.
Category Jan 2015 Apr 2015 July 2015 Oct 2015 Jan 2016 Apr 2016 July 2016 Oct 2016 Jan 2017 Apr 2017 July 2017 Oct 2017
Jan 2018 Apr 2018 July 2018 Oct 2018
                2,251 3,019 1,594          
Renewed                 1,966 4,153 743          
Overdue                 150 331 206          
Overdue Lost                 201 182 212          
Not Charged                 4 11 5          
Long Overdue Emails             39 (22 patrons) 38 (23 patrons) 21 (14 patrons) 29 (13 patrons) 12 (8 patrons)

ILL QR#4 - 2HSL2 Report

The procedure for routing books via intercampus delivery changed in late 2015.  The current procedures for Butler-HSL are here on the ILL wiki.

The changes obviated the need to use Temp Loc designators.  In the past, these Temp Loc settings were commonly not cleared when books were returned to Circulation desks, causing books to long display as unavailable.  This quarterly report helped generate search lists to find and resolve these coding errors.

In April 2016, Zack cleared away all xxx2hsl and hsl2xxx Temp Locs and corresponding Circulation Review Item Status.  If on the next report more recur, follow-up with department library supervisors to confirm change of practice.

Lehman, Mathematics, Music & Social Work were delinquent in adoption of new procedures in July 2016.

Only Music was delinquent in October 2016.

Only Barnard was delinquent in January 2017.

ILL QR#5 - Missing Status Patron Report


This report is run quarterly and includes all items charged to the 5 missing status patrons that belong to Delivery Services.  The goal is to perform a mid-point search between the initial search performed by Delivery Services staff and the formal, quarterly searches performed by Butler Collection Maintenance and outside library staff.

Within 3 to 6 months after the initial charge date all items flow onto departmental NRTN reports.  NRTN reports are run quarterly and progress through 3 stages: Search, Selector and Withdrawal.

Status Patron Definition
ILLMISS002 Borrow Direct Searches NOS
ILLMISS003 Scan & Delivery Searches NOS
ILLMISS004 GLX → HSL searches NOS
ILLMISS005 Long overdue ILL & BD loans (12+ months)


Add 2 new columns to the report:

  • FIRST_OCCURANCE = Value is based on the FY quarter.  Tracks how long each request has been on this report.  Items that have been searched 4 times should not be searched again.
  • DEPARTMENT = Use the CLIO Location to assign a text label for the department.  Iidentifies where the book should be searched.

Split the list into sub-units for systematic searching: ILL QR#5 Missing Status Patron Report - Search Instructions.  All found books are to be discharged.  If the barcode does not match, pull all matching call numbers for a supervisor to verify.

  1. Butler
  2. Butler Other (includes graduate study reading rooms, Paterno, etc)
  3. Milstein
  4. Milstein-Barnard
  5. Lehman, Journalism & Social Work (send to jp43, aeb2243 and kk18)
  6. All other Outside Libraries
  7. Health Sciences (send to Gene Robinson)
  8. Offsite
Category Oct 2015 Jan 2016 Apr 2016 July 2016 Oct 2016 Jan 2017 Apr 2017 July 2017 Oct 2017
ILLMISS001 161 161 170 194 185 186 203 210  
ILLMISS002 789 870 959 937 1,080 1,105 1,456 1,549  
ILLMISS003 130 66 62 82 136 179 207 273  
ILLMISS004 17 20 21 19 22 27 28 28  
ILLMISS005 24 30 28 148 166 189 154 152  
TOTAL 1,121 1,147 1,087 1,380 1,589 1,686 2,048 2,212  

ILL QR#6 - Overdue ILL Lending Report


This report is run quarterly and includes all items charged to active Interlibrary Loan status patrons.

Note: At ASCC on 8/22/17 it was agreed that department staff will cease charging outgoing ILL loans to their department's status patron.  All outgoing loans from ZCU and RECAP are charged to GLXILL0001 and GLXILL0009 respectively.

  • AVEILL0001
  • BARILL0001
  • BUSILL0001
  • EAXILL0001
  • ENGILL0001
  • GLXILL0001
  • GLXILL0009
  • GSCILL0001
  • HSLILL0001
  • LEHILL0001
  • MATILL0001
  • MUSILL0001
  • SCIILL0001
  • UTSILL0001

All books are meant to be searched on a quarterly basis.  Search list consists of all items that have been charged for more than 6 months since generation of report.  Most items have been lost/damaged or are long overdue to the partner's patron.  Find rate is expected to be low.  Found books were likely missed during processing. 


  1. Search all items that have been charged for more than 4 months
  2. Recall all items that have been charged 7-12 months
  3. Recall and invoice all items that have been charged 13+ months
  4. Student workers search by call number and verify match by barcode
  5. All search results are noted on the search list and found books given to Supervisor for verification and discharge
  6. Books not found that have been charged for 13+ months will be charged to ILLMISS005
  7. Note: best practice to check the ILLiad record of books 13+ months - if noted as missing or damaged, bill the borrowing institution


Charged out X ago
Jan 2015 Apr 2015 July 2015 Oct 2015 Jan 2016 Apr 2016 July 2016 Oct 2016 Jan 2017 Apr 2017 July 2017 Oct 2017 Jan 2018 Apr 2018 July 2018 Oct 2018
13+ months 271 228
218 217 116 124 15 41
17 15 12          
12 months 3 9 7 7 12 6
9 4 20 2 4          
11 months 2 6 21 1 4 14 26 6 11 3 6          
10 months 4 8 19 3 10 12 13 12 17 5 6          
9 months 13 14 31 25 3 10 10 24 7 10 6          
8 months 14 30 4 20 17 30 12 18 4 10 6          
7 months 18 32 18 19 24 23 31 24 10 13 9          
6 months 22 46 17 23 18 19 32 19 25 34 13          
5 months 45 19 38 22 43 33 43 18 35 33 28          
4 months 77 51 48 45 103 64 44 30 53 60 185          
3 months 332 214 119 137 255 184 111 122 190 229 224          
2 months 522 643 220 342 559 663 343 373 493 445 460          
1 month 770 996 708 948 766 927 636 725 592 900 560          

Note: In summer 2016 the workflow for long overdue ILL books began to be integrated with that established for Borrow Direct.  All items 12+ months overdue were charged to ILLMISS005.

ILL QR#7 - In Transit Report


This report is run quarterly and includes all items discharged in the Borrow Direct happening location that currently have status “In Transit.”  Full report includes all items currently marked In Transit.  Identify BD books by a) discharge location or b) Perm Loc.

When Columbia-owned books are returned by Borrow Direct partner libraries they are processed by ILL Staff in Relais as completes.  Relais has a dynamic connection to Voyager and discharges all books in the Borrow Direct happening location.  All books then assume status “In Transit” and are then routed to the owning department library.  In the department library, Circulation staff then discharges the book in the owning happening location.  If a book does not receive this second discharge for any reason, the status will remain “In Transit” during and after re-shelving.

It is the case that some department log-ins list the Borrow Direct happening location.  Staff may mistakenly discharge books in this happening location.  Note: Borrow Direct Circ Desk happening locations were removed from all departments in Spring 2016.


A book with status In Transit appears to be unavailable in CLIO and no Borrow Direct/ILL link appears.


The book will be requestable from Borrow Direct if another partner has an available copy.

It's desireable to clear In Transit errors as quickly as possible to prevent unnecessary traffic.


  1. Discharge all In Transit books that have Perm Loc CIRCbdirec
  2. Remove all Holds & Recalls
  3. Discharge all books with a Temp Loc (typically in a Reserves location)
  4. Discharge all other books 1+ month In Transit


Assume all books are back on the shelf.

Remove holds/recalls from items (nor practical to retrieve) – consider other options as time goes on.

If there is not have a discharge date it may be a mis-communication between Relais and Voyager; the significance of an existing discharge date is not clear.

Category Jan 2015
Apr 2016
July 2015
Oct 2015 Jan 2016 Apr 2016 July 2016 Oct 2016 Jan 2017 Apr 2017 July 2017 Oct 2017 Jan 2018 Apr 2018 July 2018 Oct 2018
Total 1,878 343 779
1,138 874 579 573 166 672   280          
Discharge @ Circ Desk
    69 693 314 322 190 48 17 (1 month bc of backlog)   126          
Discharge @ BD

ILL QR#8 - INTR Report


This report is run quarterly and includes all items that have a non-standard Temp Loc.

It includes both active OTFs and genuine mistakes.  Some departments use Temp Loc INTR to indicate a book has been transferred for Reserves in another department.

The primary errors to clear up are Temp Loc adm for Offsite collections.

Category Sept 2016 Dec 2016 Feb 2017 June 2017 Sept 2017
Dec 2017 Mar 2018 June 2018 Sept 2018 Dec 2018
35 39 45 43 36          
24 13 16 20 19          

Item Status Report

Item Status can affect both perception and agency of patron access to Offsite collections. 

  • Perception: patron is led to believe that an item is not available because of OPAC Status display in search results or item display.  
  • Agency: patron is blocked from the Request It from Offsite webform.  For more information please see the Item Status section of the ReCAP Appendix.

Several Item Status categories were not accounted for in either current practice or automated systems that apply to ReCAP processing.  The Item Status Report was created to identify and resolve: Withdrawn, Missing, In Process, Cataloging Review, Circulation Review and At Bindery.  Other statuses are used for record keeping (Damaged) or are resolved through existing procedures (Lost on the NRTN and In Transit on the Reconciliation).

More information about Item Status in Voyager may be found in DCMM (documentation still un-published in draft phase).

  At Bindery Cat Review Circ Review Claims Returned In Process Missing Withdrawn
Jan 2011 10 135 27 0 17 34 111
May 2011 10 111 13 0 4 14 23
July 2011 6 20 11 0 0 3 3
Nov 2011 5 55 9 0 0 10 79
Feb 2012 6 57 8 0 0 9 20
Aug 2012 24
81 43 0 0 22 37
Nov 2012 12 20 21 0 0 8 20
Feb 2013 6 43 11 0 0 31 19
May 2013 9 22 16 0 0 18 27
Aug 2013 4 34 18 0 0 5 20
Nov 2013 6 65 54 0 0 8 39

Each status must be removed individually.  Pick and Scan functionality in Voyager can not be used because Damaged Item Status is used for record keeping and must be retained.

Resolve on quarterly basis:

  • At Bindery: Remove status.  Check for other irregularities to Voyager record structure.  (Obsolete practice at HSL and East Asian)
  • Cataloging Review: Remove status.  Verify record is not OTF.  Retrieve OTFs for processing.  (Butler Circ current practice is that only OTFs are assigned this status)
  • Circulation Review: Remove status.  Check for department specific Notes in ITEM Record, route as appropriate.  (Set by HSL and department staff to alert that transitional Temp. Loc. must be removed (e.g. sci2hsl).  HSL has used as reminder to send book to bindery.  Butler Circ will typically place Hold, not assign this status.)
  • Claims Returned:
  • In Process: Remove status.  Most often applied accidentally during fragile processing.
  • Missing: Remove status and unsuppress as appropriate.
  • Withdrawn: Remove status and unsuppress as appropriate.

Mis-Shelved On Campus Report

Purpose: Used to identify ReCAP books potentially mis-shelved on campus after circ return.

Background: CUL staff occassionally mis-shelve Offsite collections on campus instead of returning them to ReCAP.  All ReCAP items have a barcode placed in the top left corner of the front cover.  To assist with identification, incoming deliveries have a pink RECAP sticker applied to the spine or front cover by circulation staff.  The pink sticker distinguishes requests from books in process for new accession

Shelving mistakes occur in low quantities, typically when the pink sticker is not applied to the spine.  In 2008 CUL staff reported to the ReCAP Coordinator that ReCAP books had been found mis-shelved on campus.  In Spring 2009 a library school intern was assigned to systematically identify and resolve mis-shelvings.  From the initial project developed a report and procedure to find missing books.

It's recommended that a search be conducted once a year.  All missing books may be charged to status patron RCPMISS003.

Procedure:  Once annually generate a report identifying candidate barcodes.  Over 2-3 months perform a sequence of LAS status queries to narrow down candidates to search.  Bibliographic data from Voyager is added to aid searching. 

An actionable report can not be generated until several weeks after initial query.  Many items are in-transit and must be given time to arrive at their destination, whether they are being delivered to campus or returning to ReCAP.

Steps to generate search list:

  1. Identify candidate barcodes: Contact LITO to run a report of barcodes that meet three criteria: a) OUT status at ReCAP, b) no active charge in CLIO and c) ITEM record does not have a Temp. Loc. (i.e. not on Reserve).  Request as standard report witte@bearberry:~/offsite.d/zack/zackrpt3.  Output comes in email text that must be reformatted in an MS Excel worksheet.  Includes four categories of data: a) barcode, b) customer code, c) retrieval date and d) days OUT from ReCAP.  This report includes items in-transit to and from ReCAP.  Given time, most of these barcodes will either be refiled at ReCAP or charged in Voyager.
  2. Obtain granular data for barcodes: Contact LITO to add CLIO data to the set of barcodes.  Data categories to add include: a) CLIO location, b) Title, c) active charge, d) suppressed HLDG and e) call number.  Output is a MS Excel  file that includes columnar data.  Exclude all items with an active charge or suppressed.  Resolve incomplete withdrawals. 
  3. (Re)Query the status of barcode file: Contact LITO to batch query the current status of the barcodes.  Send barcode list as a .txt file.  Update list by excluding barcodes that do not have status Out on Ret from ReCAP.  Retain only barcodes with Out status for the report.  Retain data categories: barcode, customer code, status and date.  Re-query at least two times.
  4. Onsite shelving search: Issue departmental reports for onsite shelving search.  Ignore non-print collections.  Charge not found books to RCPMISS003.
  5. Process flows to NRTN Report: If an item is returned to ReCAP, it will be automatically discharged and become accessible.  If the book remains charged to Missing it will flow onto the NRTN Report.  Department libraries (re)search on shelf for items.  If not found they are replaced or withdrawn according to department practice.
Report Statistics              


NRTN is an abbreviation of "Not Returned."  Quarterly NRTN reports list items with "Lost" Item Status.  They are generated in four sections: Search, Selector, Withdraw, and Retrospective.  All can be found online.  Offsite collections appear on both the Offsite reports and department reports.

The primary reasons that offsite collections become lost are:

  • Overdue to patron
  • "Lost" status not cleared after return at Circulation
  • Item part of Preservation or BSP backlog
  • Multi-media item with obsolete, post-binding item record

Each CUL department handles NRTN reports differently according to local search routine.  See DCMM-244, DCM-246 and DCMM-248 for more information.

Resolution of both current and restrospective NRTN reports involves checking the current status of barcode in LAS database.  Status query is ReCAP equivalent of a shelf search.  The goal is to remove "Lost" status whenever appropriate.  All items should ideally be searched on campus at the owning library.

It is important to maintain integrity of verified Offsite collections.  If an item has LAS status NOT ON FILE, change the CLIO location from off,xxx to xxx4off.  All items that have status OUT should already be charged to a patron or status patron.  Patron charges (and fines) must be left in place.  Resolution of status patron charges should be done in consultation with department staff.

Small quantities of new accessions with "Lost" Item Status are now identified and resolved weekly on the Accession Report.   "Lost" Item Status may date back to 1999.  "Lost" Item Status prevents request.


  • IN or REF : Remove Lost status
  • NOT ON FILE : delete ITEM or flip location as appropriate
  • OUT : no action
  • PWI or PWD : no action

Table 1: Search, Selector and Withdrawal report totals

Date Search Selector Withdraw Retrospective
November 2013 110 (10)
22 (7)
187 (166)
609 (212)
August 2013 29 (13)
202 (171)
26 (5)
608 (246)
May 2013 217 (181) 27 (5) 77 (34) 636 (309)
January 2013 47 (8) 86 (38) 25 (17) 644 (226)
October 2012 91 (39)
31 (23)
114 (84)
542 (226)
July 2012 34 (25) 135 (96) 207 (136) 306 (114)
April 2012 168 (104) 218 (138) 80 (15) 326 (106)
January 2012 233 (140)
93 (17) 34 (26) 449 (123)
October 2011 123 (28) 39 (32) 232 (106) 263 (55)
July 2011 110 (33) 251 (118) 108 (80) 190
April 2011 288 (143) 151 (91) 118 (101) 182
January 2011 165 (98) 124 (107) 32 (20) 166
October 2010 137 (111) 34 (21) 27 (4) 158
July 2010 40 (27) 30 (3) 29 (9)  
April 2010 42 (3) 31 (9) 39 (6)  
January 2010 36 (10) 43 (7) 24 (7)  
October 2009 52 (8) 27 (8) 62 (6)  

Each quarter the first reports are archived and remain stable.  The Retrospective report is refreshed.

Columns summarize two pieces of data: total items on list and total items charged to a status patron (in parentheses). Charges to study carrels are counted as regular patrons.

Staff use status patrons to push items onto the NRTN report.  Offsite collections are frequently mis-shelved on campus.  Regular department procedure involves search of campus shelving.  The increase in status patron charges beginning in July 2010 represents charges placed from BILO and Mis-Shelved On Campus reports.

Each month the retrospective report for Offsite collections changes.  Items may move onto the report a) because an item with location off,xxx has progressed through the Search, Selector and Withdrawal reports or b) because a "Lost" item with location xxx flips to off,xxx.

Items that have been Permanently Withdrawn should maintain off,xxx CLIO location.  Although these items have "Lost" Item Status they have associated fines that would be erased if discharged.  If permw'd items resurface, they must be sent to ReCAP as new accessions.

ReCAP QR#5 - On Campus CLIO Location


Run monthly as part of the accession data updates.  Identifies all items that are accessioned at ReCAP that do not have offsite CLIO locations (off,xxx).  It is necessary to check current status in LAS to determine solution.  Some cases will require retrieval from ReCAP.

  • Two offsite barcodes assigned to single ITEM record
  • Same offsite barcode assigned to two ITEM records
  • BADLOC not resolved as part of Accession Report
  • Staff processing error (ex post facto encoding)

Monthly e-mail includes barcode numbers and CLIO locations.

Large quantity of items are Astrophysics books (temporarily) relocated to Math with CLIO location phy,msci in August 2011.  These are noted in parentheses on the statistics table below.

On-Campus CLIO Location
Jan 2012 Mar 2012 May 2012 July 2012 Aug 2012 Sept 2012 May 2013 June 2013 Aug 2013 Nov 2013 Aug 2016        
Items 11 738 (650) 718 (650) 680 (650) 671 (650) 668 (650) 721 (650) 676 (650) 690 (650) 663 (650) 836 (593)        

Orphan Barcodes


An orphan barcode is any offsite barcode that is active in the LAS database but not present in Voyager.  They are books genuinely lost in ReCAP.

Responsibility for the lack or loss of data lies entirely with Columiba Libraries staff, not ReCAP.  Resolution is resource-heavy and complicated and can only be completed with book-in-hand.  Orphans include all collections and sub-collections, both general and special collections. 

Orphans barcodes are the largest category of "missing" collections.  At the highest point there were 41,555 orphans in November 2008.  As of March 2012, 29,612 remained.  In July 2013 about 5,000 additional orphans were discovered, previously overlooked by staff.  Many of these were a result of incomplete withdrawal in the past.

Orphan barcodes are an endemic part of ReCAP processing.  New accessions are currently orphaned at a rate of roughly 0.35%.  These are considered to be "born orphan."  There are many causes, usually difficult to discern case-by-case.

Identification and resolution began in late 2008.

Processing orphans presents many challenges.  Chief among them the diversity of collections at ReCAP.  Besides customer code there is nothing to identify ownership of books by department library.  Each sub-collection presents complications stemming from the history of the collection, language, classification, and method of processing.

Orphan Barcode Project

In September 2012 a large-scale project was designed to resolve outstanding orphan barcoces.  An Action Plan (.docx) was created to detail how 16,715 CU and CR barcodes will be completed over three years by student worker staff.  Approximately 25 barcodes will be retrieved from ReCAP per business day until the end of December 2015.

For more information see related project documentation:

Other customer codes will be resolved by deparment staff: AD, AR, AV, HR, HS, RS and UA.

Orphans by Customer Code
Project Barcodes AD
Sept 2012 16,715 3 15
5 496
16,219       200
444   0 291 2,767 95 21
Dec 2012 15,884 0 19 5 7,869 5 496 15,388   156   200 93   4 291 2,822 43 0
Mar 2013 15,303 1 15 5 7,867 5 496 14,807   132   160 26   8 291 2,819 362 0
May 2013 14,622 1 16 5 7,867 5 496 14,126   110   162 5   9 291 2,826 71 0
Aug 2013 14,794 3 149 9 7,876 6 16 14,778       2,768 29   13 291 2,802 583 0
Nov 2013 14,102 3 143 8 7,864 0 19 14,083 39 143 121 2,810
35 8 2 291 2,813 616 0
Feb 2014 14,040 0 151 8 7,864 18 18 14,022 38 129 121 2,964 52 8 2 291 2845 531 0

New Orphans


There has been an ongoing project since June 2011 to resolve all "new" orphans.  Approximately 0.35% of new, non-RBML accessions are born orphan per week.

Two weekly reports list both new and retropective orphans.  The report of new orphans covers all items accessioned during the past week.  Immediate action is taken by the ReCAP Coordinator to request and resolve all non-RBML barcodes. 

RBML staff enter barcodes in Voyager from hard-copy reports.  There is often a short delay before data input.  Primary concern for new orphans is non-RBML collections.  RBML orphans are expected to resolve themselves.

The retrospective report is large.  It may change weekly.  If staff delete a barcode of an existing accession, it flows onto this report.


At right is an excerpt from the new orphan report.  It is a list of barcodes followed by category summaries.  Categories correspond to those in the weekly Accession Report

  • records read: Total number of items that were accessioned by ReCAP during period
  • records not found: Total not found after report was run = orphans
  • records found: Accessions minus orphans

Avery Orphans

Spring 2009 intern project to explore resolving orphan barcodes systematically. 

Documentation: Flowchart (.xls)

East Asian Orphans

Some East Asian orphans can be identified by customer code EV.  In Summer 2010, 3,695 orphan barcodes were encoded EV.  The vast majority have dumb barcodes; only 209 have smart barcodes.

Since February 2007 East Asian general collections were accessioned with CU-prefix barcodes.  For the first several years CJK-language collections were accessioned with customer code EV.  Since they now have customer code CU, it makes the orphans indistinguishable from other departmental collections at ReCAP. 

Link to project website on East Asian Library/ReCAP website.

100- Prefix Orphans

Summer 2011 project to resolve all 100- prefix orphans.  Majority were theses and dissertations belonging to RBML.  Leftover work includes approximately 125 extramuro dissertations to be completed by MPS staff.

Documentation: Flowchart (.xlsx)

Overdue ILL/BorrowDirect

Permanent Withdrawal Report

A dynamic record of all barcodes submitted to CUL Systems staff for permanent withdrawal from ReCAP since December 2006.

Batch files for permanent withdrawal is sent to ReCAP every Wednesday. Confirmation email is sent by ReCAP staff to alias Email confirms withdrawn barcodes and alerts about problems. Problems may be barcodes not on file, already withdrawn or currently on the shelf at ReCAP.

Reconciliation Report

Often Offsite collections are returned to ReCAP still charged to a patron, status patron or In Transit.  Each week a list of barcodes and corresponding CLIO locations is discharged by LITO staff.  This list is informally called the reconciliation report.  Items are discharged weekly from the correct happening location according to CLIO location.

Most items on the report have In Transit status.  In Transit status is added when a item is discharged from a non-owning service desk.  For more information see the Appendix section on Happening Location.

CUL staff must manually clear all charges and In Transit statuses.  If charge or status remains in place, the item will be unavailable for patron request.  Patron may incur additional fines if discharge does not occur.

How Reconciliation Report is Generated

  1. LITO staff identifies all items with a status of In Transit.  There are three such statuses: In Transit, In Transit Discharged, and In Transit on Hold
  2. From that list LITO staff removes the current week's ReCAP accessions and adds them to the Accession Report.  A list of items with status In Transit on Hold are sent to Butler Circulation staff to resolve.
  3. The barcodes on the weeded list are batch queried by LITO to determine current status.
  4. If an item status in LAS is [IN or REFILE] it is added to the reconciliation report to be discharged from the appropriate service desk.

Problems with Reconciliation

To minimize the amount of reconciliation performed by LITO, CUL circulation staff are encouraged to discharge items in the appropriate, owning happening location.  This may mean that more than one happening location needs to be used while discharging daily ReCAP returns.

GFA periodically changes item status displays in LAS.  This may break programs written by LITO with result that not all items with a current Voyager charge appear on the weekly reconciliation reports.

Example Report (abridged)

off,ave AR00560987
off,glx CU13480707
off,leh CU01615459
off,msr MR00093114
off,psy CU04441206
off,sci CU11901209
off,swx CU08180784
off,utmrl UT00011029
off,utn CR00250007
off,utp UT63969742
off,uts CU08149879

Synchronization Report

Examines the correspondence of customer code, barcode prefix and clio location.

  • All three as expected
  • Wrong barcode prefix
  • Wrong/missing clio location
  • Wrong customer code 

Asynchronicity results when:

  • Collections change ownership after accession.  Pre-1800 titles from Butler Stacks were given over to RBML during the Google Project.  off,glx was flipped to off,rbx.  Complication in shared model when "circulating" colletions are identified by customer code.
  • Accessioned with wrong barcode/customer code. 
  • Staff make errors, unaware of correct code.

Report is created in Access with a query to isolate barcode prefix.

  • Create an expression Left([BARCODE],2).

Temporary Location Report

"Temp. Loc." is the abbreviation for Temporary Location used in the Voyager ITEM record.  For more information on how Temporary Locations may be changed see DCMM-505.

Temporary Locations are assigned to Offsite collections primarily to temporarily relocate on Reserve.  At the end of the semester or school year staff remove Temp. Loc. and return books to ReCAP. 

Precat (MPS) also uses temporary locations before transfer to ReCAP.  Once Precat items are accessioned at ReCAP, the Temp Loc is removed.  Newly accessioned Precat barcodes are listed in the weekly Accession Report under TEMP LOCATION and are resolved by MRP staff.

If a Temp. Loc. is mistakenly applied to Offsite collections, it blocks the appearance of the request link and prevents patrons from placing requests via CLIO.

  • In this case the Temp. Loc. is mus,fol (Music Library Scores Folio) when the correct, permanent location is off,mus (Music Library Offsite).
  • The holdings record verifies that the correct location is off,mus.
  • The display in CLIO indicates that this item belongs in the Offsite collection but is on campus, "Shelved in Music Scores Folio."  There is no request button.
  • In this case, the item had not been correctly resolved from the weekly Accession Report.  Once the Temp. Loc. and Temp. Type are cleared the request button will appear on the following Friday.  No further action necessary.


A series of steps are needed to generate, refine and resolve the Temp Loc Report.

  1. Request as standard report: /m1/clioprod/anurag/reports/zack_reports/recap_temploc20110519/  Report is returned a .txt file to be imported into Excel.
  2. Batch query status in LAS for all barcodes.
  3. Separate Offsite and Local Barcodes
  4. Sort the results by LAS status: IN/REF/INC, OUT, NOT ON FILE, and PWI
  5. Resolve all items that are IN, REF and INC.  There are three categories
    1. On campus CLIO Location (xxx, xxx4off or xxx,xxx) that was not cleared as part of the weekly Accession Report.  To resolve, remove both the Temp. Loc. and Temp. Type.  Flip location to off,xxx as appropriate.
    2. Reserve CLIO Location (xxx,res) that was not cleared before return to ReCAP.  Double check in Voyager and refer to department reserves.
    3. Happening Location/CLIO Location (CIRCxxx) that was applied by mistake and HSL transit CLIO Locations (xxx2hsl).  These CLIO Locations are not used as storage locations and should be removed.  Must be changed in the Voyager Circulation Module before clearing in Cataloging Module.  Procedure: a) retrieve Item by barcode, b) right click on Item Record and select "Edit Item...", c) click on "Item" tab, d) change Temp. Loc. to off,glx and e) return to Cataloging Module and clear Temp. Loc. in ITEM record.
  6. Resolve all items that are OUT. 
    1. Majority have current Reserves locations (xxx,res).  No action necessary.
    2. Non-Reserves with on campus Temp. Loc., check first for charge to patron.  If charged, clear Temp. Loc. as appropriate.  If not charged, clear Temp. Loc. and charge to RCPMISS002.
    3. CIRCrbx, RESVglx: clear Temp. Loc. and charge to RCPMISS002.
  7. Resolve all items that are NOT ON FILE
    1. Majority of these items have Temp. Loc. glx,pre and should not be adjusted. (May 2011 3,875 =  80.4%)
    2. Most local barcodes are Inactive within ITEM record with Active offsite barcode (can be deleted except for Avery)
    3. Some represent ghost ITEM records to be deleted
    4. Others are ITEMs whose offsite barcode has been orphaned
May 2011 105 1,553 4,819 0
November 2011 70 1,248 2,758 1
February 2012 32 1,606 2,141 0
May 2012 29 1,386 1,869 0
August 2012 66 1,177
November 2012 40 1,371
May 2013 165 1,368 2,316 0
August 2013 653 810 1,605 24


ReCAP User Inquiry Alias:

ReCAP Access Supervisor: Holly Kozlowski

Phone: (212) 851-5621