Call for Data Cleanup Project Proposals

Please note that the call for data cleanup projects has finished. SeeLast Call for Data Cleanup Project Proposals for more information.

OCLS is preparing to complete data cleanup projects on behalf of colleges, but it will be necessary to plan the work and prioritize projects. Cleanup projects that can be run in batch and impact the greatest number of colleges will be prioritized. We are requesting proposals for data cleanup projects that you would like support with. For example, taking care of cannot-be-discarded items, and purging inactive holds.

We will review your proposals and let you know if there is capacity to complete each project. Some may be deferred until after our Go-live date in July 2022. Others may be out of scope for OCLS support services.

We anticipate that many of you will identify additional cleanup projects once you have the chance to see your data in your Alma environments. We will leave this call for proposals open and remind you to submit requests again in March. In the meantime, please let us know if there are projects we can begin immediately.

OCLS is already prepared to complete patron purges and removal of unpaid fines.

You must log in to Confluence and select the “edit” icon on this page to add your proposals to the table.

Submission Author and College Name	Proposed data cleanup project description (Please note that projects that can be run in batch and impact the greatest number of colleges will be prioritized.)	OCLS Comments

Submission Author and College Name	Proposed data cleanup project description (Please note that projects that can be run in batch and impact the greatest number of colleges will be prioritized.)	OCLS Comments
OCLS St. Lawrence - Brenda Desjardins Centennial Conestoga Sheridan George Brown Fleming Northern Confederation	Purge patrons from your Sirsi ILS system	Please confirm that you would like OCLS to undergo this cleanup on your behalf by adding your name and college name in the first column. Please provide the information necessary to identify these patron records separately in an email to Jennifer Mo and Stacey Boileau.
OCLS St. Lawrence - Brenda Desjardins Sheridan Georgian Fleming Northern Confederation	Forgive unpaid fines	Please confirm that you would like OCLS to undergo this cleanup project on your behalf by adding your name and college name in the first column.
St. Lawrence - Brenda Desjardins Centennial George Brown Georgian Fleming Northern Confederation	Purge inactive holds
Georgian	Review “shadowed” items with view of purging that are redundant
Centennial	Purge old shadowed bibliographic records (those without inventory, and not associated with current open orders)
Georgian	Serials issue as identified by Andrea: Some serial control/issues records failed because the SERC_ID contained a bib ID with extra charters, like: In other cases, the SERC_TITLE_KEY is not found in the Bib 035/020/022
Sheridan George Brown	Fix Current Location (999$k) missing or blank issue To resolve the issue with the transition of the data to Alma where information in the current location (999$k) is blank or the subfield $k is missing for a significant number of physical item records. For those records, please copy information in 999$l to 999$k (or insert $k if it is missing).
Sheridan	Clean up unlinked items in User Category 1 After old Patron records are deleted, please remove items which are not linked to any of remaining patron records from User Category 1.
Confederation	Can patrons under “STAFF” be merged into “STAFF_FAC” profile, and “staff” be deleted as a profile?
George Brown Algonquin	Purge all items charged to the pseudo patron Missing Note: Currently these items show as “on loan” in Alma **for Algonquin - with last activity date before Jan 1, 2019
George Brown	Identify and delete titles without items Note: most of these will be brief order records. Please send the list to review before deleting them.