Clean Up Reports

Updated: Feb 23, 2021

 Completed

  • Barcodes that cannot be searched or scanned in Aleph (or Alma) because they contain symbols, spaces and other oddities.
  • Holding 852 errors ($$c not in tab40)
  • Records with no collection code
  • Collection codes with no holdings or items
  • Suppressed records
  • Circ-Created records
  • Marc tag typos
  • Hold LKR errors
  • Novanet Office – P863 Barcodes
  • Patron credits (positive balances)

 STL (Sent to Libraries)

  • Collections with multiple item statuses – need to examine and edit so there is one collection per item status
  • Item Process Status report, determine what process statuses are obsolete
  • Unclosed Orders
  • Electronic/print records split
    p_and_e_20200408.xlsx
    e_in_p_20200408.xlsx
    p_in_e_20200408.xlsx
  • ACQ – Order status LC with IPS OO
  • ACQ – Order status VC with IPS OO
  • ACQ – Order status CLS with IPS OO
  • ACQ – Order status CLS with IPS IP
  • Collection = NOMAP
  • Holding records with no collection – part 2
  • NET holdings with no URL (missing or malformed 856)
  • ACQ created bib records
  • Invalid 852$$b – distributed to Cat Working Group

Library specific reports

  • SMU – Thesis records – separate print and electronic

Upcoming

  • Local note fields in bib records
  • Orphan bib, holding, and item records
  • Suppressed bibs related to Acquisitions
  • Closed fund codes
  • Records encoded with incorrect language
  • HOL records linked to multiple BIB records
  • Item records with no HOL (unlinked)
  • Subscriptions with no order link
  • Invoices with any status that is not “Paid”
  • Orders with no renewal date – on hold
  • Patrons missing 02 address
  • Expired patron records with blocks
  • On hold reports
  • Lost book report
  • OCLC reclamation repairs
  • Invalid 852$$b
  • No 852$$b
  • Bib 856$$b removal
  • Invalid or duplicated 852$$c
  • Records without 852$$b/c
  • z30_temp_location=Y
  • Collection codes not in tab40
  • Electronic items without holdings
  • Add 856$$m to Electronic holdings
  • Holdings without items