RE: SCAT Table question

["Steve Espinoza" <espinoza@xxxxxxxxxx>]

This issue stirs a curiousity we had about SCAT tables and "accession"
type call numbers.  FWIW, our resolution was to exclude these from our
SCAT table.

We did ask Innovative for a separate call number index for accession
type call numbers, so excluding these call numbers was simplified by
excluding that index from registering in our SCAT.  This keeps the "call
number not found" category to the Dewey and LC call numbers.

Prior to excluding, we discussed the merits of having "accession" type
call numbers in our SCAT table and we decided to leave them out because
(in our case) there is no connection from a call number like VTC 1077
(our video equivalent) to a subject heading.  Since this is a collection
management perspective, do you (or anyone) have other reasons for
collecting data about accession type numbers in the SCAT?  

If you were to get "accession type" numbers successfully in you SCAT
table, in what reports would these be used?  Someone may have some
really cool uses for this information that may prompt us to try to get
them in the SCAT table.

In 2002 Phase 3, I understand there will be an improved reporting of the
actual records involved when the call number registers in the "call
number not found" category.  We are looking forward to that enhancement.

-- Steve Espinoza

****************************
Steven R. Espinoza
Information Technology Consultant
Cal State San Marcos - Library
San Marcos, CA   92096-0001
Desk: 760-750-4361  Cell: 760-801-5537
eMail: espinoza@xxxxxxxxxx
 





-----Original Message-----
From: Felice K. Lowell [mailto:felice.lowell@xxxxxxxxxx] 
Sent: Monday, August 18, 2003 4:27 AM
To: innopac@xxxxxxxxxx
Subject: Re: SCAT Table question


The only way I know of to make the scat table work is to insure that the

database is "clean."  Unless you write into the scat table all possible 
variations you want recorded, you won't be getting accurate answers.  In

other words, if your call numbers are keyed Fiction|aAbe and Fiction 
|aAbe and Fiction |a Abe (note spacing), you will have to set up a scat
table which searches for all of those conditions.  The alternative is to

search for each condition, determine which alternative you prefer, and 
globally update all of those 099 fields which do not conform.  A lot of 
work now, but ultimately rewarding.
Another solution - again long term and labor-intensive - remove the 
location i.e. Fiction or Video or Vid from the call number so that the 
scat table sorts only by the call number portion.  Then you will also be

able to determine what titles are in which location for an inventory or 
other purpose.
Or , globally update Fiction |aAbe to 822|aAbe - and Vid |a822.33 to 
Video|a822.33 - and Video 1077 to Video|b1077, etc
 
Felice

Penny Cowan wrote:

>     I'm positive that SCAT tables will be the death of me!  Can anyone
> give words of wisdom when trying to track local call numbers -- i.e.  
> Video 1077, Video Midwest,  Vid 822.33, Fiction Abe, Bio Hunt, Garden 
> Jus,  etc.  We have all of these kinds of call numbers in 099 fields 
> that are indexed in our Dewey index.  Some are entered with a subfield

> a between words and some are not --  i.e. Fiction|aAbe,  Video 1057

> Our SCAT table contains both LC and Dewey call numbersr along with 
> these local call numbers and we are getting way too many that show up 
> as not in table.  Thanks, Penny Cowan




--- StripMime Report -- processed MIME parts ---
multipart/alternative
  text/plain (text body -- kept)
  text/html
---
--
This message was distributed through the Innovative Users Group INNOPAC
list
Public replies:  INNOPAC@xxxxxxxxxx
Update your subscription options:
http://innopacusers.org/list/listinfo/innopac