Info Hub
Removing Historical Rave Links using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL, Legacy
- Summary:
-
Search for historical rave links no longer in use using a Sierra SQL query and delete them from any records.
-
Removing OCLC prefixes in 001 field using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL
- Summary:
Ensure that OCLC prefixes are not in the 001 field using a SQL query.
Identifying item records without bib records using a Sierra SQL query
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Metadata cleanup using SQL
- Summary:
Find item records that are not linked to a bibliographic record using a SQL query.
Verifying minimal bibliographic record standards
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance
- Summary:
Check that bibliographic records contributed to the Central Catalog meet the minimal bibliographic record standards for contribution. If not, upgrade any to include the mandatory fields.
Removing Historical Rave Links
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Legacy
- Summary:
Search for historical rave links no longer in use and delete them from any records.
Removing OCLC prefixes in 001 field
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance
- Summary:
Ensure that OCLC prefixes are not in the 001 field.
Verifying that all Delete Records are Suppressed
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance
- Summary:
Search for bibliographic delete records and ensure that they are suppressed from the Central Catalog.
Removing Historical Suppression Codes
- Last updated:
- Sep 15, 2022
- Topic(s):
- Database maintenance, Legacy
- Summary:
Search your local database for historical suppression codes no longer in use and update them to the current ones.
