We migrated to Innovative in 2002.
Until about a month ago, we did not delete ORDER records.
This September we deleted some 40,000 status 1 (ON HOLD), and status z (CANCELLED) order records.
We still have over 900,000 order records in Sierra, 867,000 of which are FULLY PAID (status a).
500,000 of these fully paid order records have not been touched for at least 7 years.
Is there any point in keeping them?
What do you do?
Do you purge order records?
What is your cutoff date for purging FULLY PAID order records?
What do you keep? What do you purge? Why?
Do you archive order records before batch deleting?
Have you had occasion to refer to archived order records? Have you encountered difficulties doing searches on them?
Have you considered pulling data to a SQL searchable database that key staff can access before purging?
If yes, will you be willing to share your experiences?
We include order records in Daily Record LINK Maintenance? Having so many “dead” order records in our system creates serious problems with inaccurate information in BIB LOCATIONS, and Sierra’s / Encore's Locations facet, inaccuracies which end up choking public service.
What do you do? Do you exclude order records from Daily Link maintenance? Have you experienced disadvantages as a result of exclusion?
[Do you let patrons see titles on order? Do you let them place holds on ordered (but not yet received) material. Does exclusion from link maintenance impact requests on ordered titles?]
We’ll very much appreciate hearing about your experiences, suggestions.
Enterprise Applications / IT
Brooklyn Public Library
10 Grand Army Plaza
Brooklyn, NY 11238