IUG 2024 Hackathon: Detect Changes to Sierra Code Tables

Program Title: Detect Changes to Sierra Code Tables
ILS: Sierra
Program Description: The Sierra Administrator adds, occasionally renames and on rare occasions, deletes fundamental system codes. Common examples include Location Codes, Material Types, Item Types, Statistic Groups, Patron Types and Loan Rules. Unfortunately, the busy admin can forget to notify all colleagues, vendors
and integration partners of these updates to the Sierra database. The admin also needs to remember to update related tables, such as Admin Corner’s Locations Served and Bibliographic Locations tables.

Speaker/ Information: Bob Gaydos: Stark Library, OH
Rebecca King: Thousand Oaks Library, CA
Devan Parkison: Skokie Public Library, IL

IUG-2024_Hackathon_Code_Table.pdf (1.6 MB)

This system has been built and deployed to the Production environment at Stark Library.   It is working quite well, although I still have more Sierra tables I want to add to those currently monitored.   I will make it available for download in the next couple of weeks.   Contact me if you’d like to be notified when the download is available.