• Submitted by Berklee College of Music
• April 9, 2015

By default EG suggest a Dewey based call number in a bib record when crating a new volume. Here is how to change that default to use LoC call numbers. The database table that needs to be updated is the asset.call_number_class table. You just change the order of the call numbers from 050, 055, 090 to 090, 050, 055. I found the info here:

http://list.evergreen-ils.org/pipermail/evergreen-catalogers/2012-June/000093.html

tweaking the asset.call_number_class table from stock values of…

select * from asset.call_number_class;

 id |           name           |           normalizer           |                                field                               
----+--------------------------+--------------------------------+---------------------------------------------------------------------
  3 | Library of Congress (LC) | asset.label_normalizer_lc      | 050ab,055ab,090abef

To what we have…

 id |           name           |           normalizer           |                                field                               
----+--------------------------+--------------------------------+---------------------------------------------------------------------
  3 | Library of Congress (LC) | asset.label_normalizer_lc      | 090abef,050ab,055ab

I used some SQL along the lines of (if I recall correctly)…

UPDATE asset.call_number_class SET field = ''090abef,050ab,055ab'
WHERE normalizer = 'asset.label_normalizer_lc'

Though in your case you might want to use something like to put the 099 before the 090…

UPDATE asset.call_number_class SET field = ''099XYZ,090abef,050ab,055ab'
WHERE normalizer = 'asset.label_normalizer_lc'