Retrospective projects

Required projects

The following are non-library-specific retrospective projects that libraries should work into their normal workflow as time & resources permit.

Ask the Database Manager if you need assistance with a particular project.

Urgent

• There are currently no urgent projects that would take priority over one's normal workflow.

No specific deadline

• Fix invalid GMDs & GMD qualifiers (so that they are indexed & display correctly now, can be more easily used for record analysis now, and can be more easily correctly converted to 3XX fields & deleted when that time comes)

Optional projects

The following optional non-library-specific retrospective projects are opportunities for cleaning up the database and thereby improving the quality & reliability of user access, if you have the available time and manpower to do so.

Ask the Database Manager if you need help compiling a list of records that need editing or want to know more about what a particular project involves.

• Add 347 fields to Blu-ray+DVD, DVD+CD, etc. combo pack records
• Add 257 field to video records for country of production
• Change tagging of genres from 650 to 655
• Add newly created genre terms & subject headings to applicable older records
• Delete "duplicate" 007 fields
• Delete "duplicate" 505 fields
• Add 753 and possibly also 347 fields to PC games & other software
• Add subject & genre headings to older records that currently have none at all
• Check old "MacroFix" records against the actual item and what's in WorldCat to make sure the correct OCLC number & description were used, and clean up the record accordingly
• Overlay any remaining records affected by the Smartport/006 bug
• Change fictitious character headings from 650 to 600
• Fix typos in ISBNs & ISSNs, or move them to 020 |z
• Fix records that have a Date Cataloged but are still marked "Preliminary" in the 999 or 099 field
• Check & when appropriate fix or remove records that are still marked "Preliminary" in the 999 or 099 field but were created more than a year ago.
• Fix records that are still marked "Preliminary" in the 999 or 099 field but have items out and circulating
• Add 006/007 fields to AV records that lack them
• Remove e-book ISBNs from print records and print ISBNs from e-book records
• Fix records that have a Date Cataloged but no data in the 300 field.
• Check and, when necessary, overlay records that still say "[Library code] LIBRARY DATA"
• Check & when appropriate fix records with questionable nonfiling indicators
• Remove 599 fields, Serial Controls, and/or MARC Holdings records that are still present after the library's last copy has been removed