# IUG 2024 Hackathon: Detect Changes to Sierra Code Tables

**URL:** https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848
**Category:** IUG Conference 2024
**Tags:** hackathon, sierra, iug-2024, code-tables
**Created:** [April 17, 2024, 1:46pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848 "2024-04-17T13:46:53Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![derekbrownrhpl](https://forum.innovativeusers.org/letter_avatar_proxy/v4/letter/d/c5a1d2/32.png) [@derekbrownrhpl](https://forum.innovativeusers.org/u/derekbrownrhpl)
#### Post date: [April 17, 2024, 1:46pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848/1 "2024-04-17T13:46:53Z")

</div>

**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](https://forum.innovativeusers.org/uploads/short-url/i1YlJxe8T1PzXT3XbKXWTA7uxe3.pdf) (1.6 MB)

---

<div class="post-metadata">

### Author: ![bgaydos](https://forum.innovativeusers.org/user_avatar/forum.innovativeusers.org/bgaydos/32/1045_2.png) [@bgaydos](https://forum.innovativeusers.org/u/bgaydos)
#### Post date: [May 8, 2024, 3:32pm UTC](https://forum.innovativeusers.org/t/iug-2024-hackathon-detect-changes-to-sierra-code-tables/1848/2 "2024-05-08T15:32:23Z")

</div>

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