Info Hub

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.

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.