Info Hub

Saving Global Updates

Last updated:
Apr 28, 2023
Topic(s):
Database maintenance, Global Update
Summary:

Create and save Global Update commands for reuse

Converting 856 links to 956 links

Last updated:
Mar 6, 2023
Topic(s):
Database maintenance
Summary:

Convert supplemental material 856 links to 956 links in member-contributed records in the Central Catalog.

Searching for bib records without item, checkin, or order records

Last updated:
Feb 12, 2024
Topic(s):
Database maintenance
Summary:

Find non-electronic resource bibliographic records that do not have an attached item, checkin, or order record.

Searching for active item holds using a Sierra SQL query

Last updated:
Sep 15, 2022
Topic(s):
Database maintenance, Metadata cleanup using SQL
Summary:

Find items with holds still active using a Sierra SQL query.

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.

Pages