[OPEN-ILS-GENERAL] 099 / 090 / 050

[Yamil Suarez]

Donald,

We also use LC call numbers and to see the change you are talking
about in the create volume, here is what we did.
We made a change to the table "asset.call_number_class" in the column
called "field" using SQL...

from stock values of...

select * from asset.call_number_class;


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


To what we have now...

 id |           name           |           normalizer           |
                          field
----+--------------------------+--------------------------------+---------------------------------------------------------------------
<snip>
  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'

NOTE: I don't know the subfields values for the 099 tag off the top of
my head, so I put "XYZ" as placeholders. You will need to look up the
proper subfields for the 099.

Good luck,
Yamil




On Fri, Aug 1, 2014 at 8:43 AM, Donald Butterworth
<don.butterworth at asburyseminary.edu> wrote:
> All,
>
> After a decent night's sleep, I reread the email I sent yesterday about LC
> call numbers and printing, and realized the  099 / 090 / 050 question has
> nothing to do with printing. (Duh)
>
> The question really has to do with what call number is supplied in the call
> number display when a new volume is created. I should have asked if
> Evergreen follows the 099 / 090 / 050 hierarchy protocol.
>
> Sorry about that,
>
> Don
> ------------------------------------------------------
>
> First a question about default call numbers. A bib record potentially could
> contain all 3 call number fields for an LC library.
> 099 Local Free-Text Call Number
> 090 Local LC-type Call Number
> 050 LC Assigned Call Number
>
> It would be extremely rare for a bib record to have all three numbers, but
> if they were present, the 099 tag should be the one chosen by the system to
> print. When an 090 and an 050 are present the system should choose the 090
> to print. When only the 050 is present it should print. Is this protocol
> being followed in Evergreen?
>
>
>
>
> --
> Don Butterworth
> Faculty Associate / Librarian III
> B.L. Fisher Library
> Asbury Theological Seminary
> don.butterworth at asburyseminary.edu
> (859) 858-2227



-- 



--------------------------------

Yamil Suarez, MCS
Library System Administrator/Developer

Stan Getz Library
Berklee College of Music
1140 Boylston St
Boston, MA 02215

ysuarez at berklee.edu
617-747-2617