Connect ny unique item project
This presentation is the property of its rightful owner.
Sponsored Links
1 / 24

Connect NY Unique Item Project PowerPoint PPT Presentation


  • 51 Views
  • Uploaded on
  • Presentation posted in: General

Connect NY Unique Item Project. Noreen Reale Falcone Library Le Moyne College. Goal of Project.

Download Presentation

Connect NY Unique Item Project

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


Connect ny unique item project

Connect NY Unique Item Project

Noreen RealeFalcone Library

Le Moyne College


Goal of project

Goal of Project

  • To free up space in our stacks, Le Moyne College Library wanted to identify withdrawal candidates from the circulating collection acquired earlier than a given date that had no record of circulation since 1994, when we acquired Innopac (and subsequently Millenium).


Requirements of project

Requirements of Project

  • To work from withdrawal candidate lists that were produced from Le Moyne’s Millenium catalog.

    • Note: the lists were to be used to identify withdrawal candidates only. They were not intended to be “pull” lists.

  • To maximize the effectiveness of Connect NY’s Inn-Reach book lending network, we wanted to make sure that we were not withdrawing the last copy in the system.

    • After some discussion among the librarians, it was thought that preserving two copies in the system, when they existed, would make for a more robust sharing network.


Methodology of project

Methodology of Project

  • Produce lists of items from Le Moyne’s circulating collection acquired before a given date that had zero circulation recorded in Millenium.

  • Obtain lists of items from the Connect NY union catalog that were either:

    • Uniquely held by Le Moyne (we owned the only copy)

    • Held by Le Moyne and exactly one other library

  • Produce from these, lists of items that had not circulated AND which were held by two other Connect NY libraries

    OR (fallback) held by at least one other Connect NY library.


Connect ny unique item project

62,900 lbks with tot chkout = 0 and catdate ≤ 01/15/2003


Connect ny unique item project

lbks – no circ

62,900

54,601 – single copy


Connect ny unique item project

78,139 uniquely held and 37,686 uniquely held plus one other library


Connect ny unique item project

lbks – no circ

unique

NOT

54,601

42,256

12,345

78,139


Connect ny unique item project

lbks – no circ

unique / unique +1

NOT

54,601

42,256

37,878


Connect ny unique item project

no circ

NOT

unique

42,256

Unmatched Query – “find records (rows) in one table that have no related records in another table”


Connect ny unique item project

(no circ NOT unique) NOT unique +1

37,878


Connect ny unique item project1

Connect NY Unique Item Project

Questions?


  • Login