Re: [IUG] Rolling over YTD stats into LYTD field

[Nancy Helmick <helmick dot 1 at osu dot edu>]

I've mentioned that we got creative with the YTD data before, but it 
might bear repeating.

We manage to keep "buckets" of stats on circulation by using the 
YTDCIRC LYRCIRC fields but relabeling them.

[]



In this example, the TOT CHKOUT field = 41 which is the number of 
times item has circulated since we implemented in 1994
2005-2010 = 2 which is the number of times item has circulated since July 2005
2000-2005 = 21 which is the number of times item circulated between 
July 2000 and June 2005

When you subtract the combined total of the 2000-2005 and the 
2005-2010 fields from the value in the TOT CHKOUT field, the 
remainder is the number of times the item circulated between Aug 1994 
and June 2005 (18).

We took information from our former system and put it into the 945 
fields, so above you can see that the item was checked out twice 
while on reserve (945|h), 54 times between 1971 & 1983 (945|f) and 44 
times between 1984 & 1994 (945| j).

The 2005-2010 field was originally the LYRCIRC field which is 
dynamic.  In 2000 we zero'd it out and allowed data to accumulate 
there until June 2005.  In June 2005, we transferred the data from 
that field in the static PYRCIRC field which we then relabeled as 
2000-2005.  We changed the label of the LYRCIRC/2000-2005 field to 
2005-2010 and are now collecting data into that field.  In 2010, we 
plan to add the data from that field to the data in the PYRCIRC/ 
2000-2005 field and relabel it as 2000-2010 so we can relabel the 
LYRCIRC/2005-2010 field as 2010-2015 (or 2010-2020).

--Nancy

Nancy Helmick
The Ohio State University Libraries
helmick dot 1 at osu dot edu

Date: Fri, 10 Oct 2008 10:59:58 -0500
From: "Charlotte Moncrief" <charlotte at lmn dot lib dot al dot us>
Subject: Re: [IUG] Rolling over YTD stats into LYTD field
To: "'IUG INNOPAC List'" <innopac at innopacusers dot org>
Message-ID: <015301c92af1$3ebabc40$bc3034c0$ at lib dot al dot us>
Content-Type: text/plain;charset="US-ASCII"

Yes, we use Page #101386, too.  Using Rapid Update, the path is >D >R >I
>yes to maintain YTDCIRC AND LYRCIRC >yes to zero the YTDCirc totals.
It is not necessary to use a review file. The rapid update can run on the
whole database.  We have over 705,000 item records and it took 13 minutes.
We submit once a year on the last day of the fiscal year immediately after
System_Backup completes.
To prepare, I print a few item records beforehand.  Then after YTD/LYR runs,
I check the same item records to see if the Year-to-Date Circ is zero and
Last Year Circ has increased.

~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Charlotte Moncrief, MLS
Library Management Network, Inc.
2132 6th Avenue SE, Suite 106
Decatur, AL  35601
256-308-2529 x10
http://www.lmn.lib.al.us
Use GoodSearch by Yahoo http://www.goodsearch.com to help fund LMN!



-----Original Message-----
From: innopac-bounces at innopacusers dot org
[mailto:innopac-bounces at innopacusers dot org] On Behalf Of Hurcombe, Emma
Sent: Friday, October 10, 2008 9:00 AM
To: IUG INNOPAC List
Subject: [IUG] Rolling over YTD stats into LYTD field

Hi all,

I need to roll over the stats from the YTD field to the LYTD field and the
only information in the manual I can find is on page 107421.  However,  this
refers to multi PAC sites which we are not.

Can anyone give me some advice as to how I can roll over the stats so we can
use these fields to get an idea of item usage comparing this years stats to
last years?

Thanks for any help you can give.
Regards,
Emma


Emma Hurcombe, BA (HONS), PGDip ILM, MA
Systems Specialist (LMS)
Information Systems Aston (ISA)
c/o Library & Information Services
Aston University, Aston Triangle,
Birmingham, B4 7ET
Direct Dial Telephone: 0121 204 4503
Internal extension: 4503

Fax:    0121 204 4530
LIS Homepage:  http://www.aston.ac.uk/lis/




--- StripMime Report -- processed MIME parts ---
multipart/related
 multipart/alternative
   text/plain (text body -- kept)
   text/html
 image/jpeg
---