Date:         Mon, 12 Dec 2005 10:33:11 -0800
Reply-To:     ILLiad-l Discussion List <[log in to unmask]>
Sender:       ILLiad-l Discussion List <[log in to unmask]>
From:         Frank Haulgren <[log in to unmask]>
Subject:      Re: ILLiad & overdue fines
In-Reply-To:  <[log in to unmask]>
Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed

All Interested -

It's pretty easy to set up a MS-Access query that will track ILLiad 
overdues.  We run this report daily then drop the data into an Excel 
spreadsheet that calculates the fines.  That spreadsheet is emailed to our 
Circ Manager who has one of her staff manually enter the fines into the 
patron's III circ record.  There may be a way to by-pass the Excel 
component and have Access calculate the fine amount but I haven't figured
that out.

I have included the SQL text for my query below.  You could probably drop 
this into MS-Access and get a better idea of what the query looks like. 
Any questions feel free to contact me.

Frank Haulgren
ILL & Document Delivery Manager
Western Washington University

SQL text from MS-Access (has a 1 day grace day built in):

SELECT dbo_Transactions.TransactionNumber, dbo_Transactions.DueDate, 
dbo_Tracking.ChangedTo, dbo_Tracking.DateTime, dbo_Transactions.Username, 
dbo_Transactions.LoanAuthor, dbo_Transactions.LoanTitle, 
dbo_Users.LastName, dbo_Users.FirstName, dbo_Users.Number, 
dbo_Users.Status, dbo_Users.Status
FROM (dbo_Transactions INNER JOIN dbo_Tracking ON 
dbo_Transactions.TransactionNumber = dbo_Tracking.TransactionNumber) INNER 
JOIN dbo_Users ON dbo_Transactions.Username = dbo_Users.UserName
WHERE (((dbo_Transactions.DueDate)<Date()-2) AND 
((dbo_Tracking.ChangedTo)="Item Checked In") AND 
((dbo_Tracking.DateTime)>Date()-1 And (dbo_Tracking.DateTime)<Date()));


On Fri, 9 Dec 2005, Deljuana wrote:

> Hello Ms. Riley,
> I am responsible for entering the overdue ILL fines.  The way it works here
> is I manually calculate the overdue fine and enter it in Voyager.  And then
> the circulation desk collects the fines and gives me copies of the receipts.
> I just started working here last month and was amazed to find that we're
> technologically challenged for such simple stuff.  If your circulation
> department also uses Voyager maybe they will agree to collect ILL fines as
> well for you.  Wish I had more to offer but the tools are limited, sorry.
>
>
> -----Original Message-----
> From: ILLiad-l Discussion List [mailto:[log in to unmask]] On Behalf
> Of Monica Riley
> Sent: Friday, December 09, 2005 12:11 PM
> To: [log in to unmask]
> Subject: [ILLIAD-L] ILLiad & overdue fines
>
> Hello All,
>
> Can anyone offer suggestions on how to charge daily fines on overdue ILL
> books in ILLiad without having to collect money separately in the ILL
> dept.  We have been using ILLiad borrowing since March and stopped
> charging fines and just block patron's accounts, but that is not working
> well.  We really don't have an ILL office, but a work area that does not
> work well for patron traffic and we don't want to deal with money
> separate from circulation.  We use Voyager and wonder if there's some
> way to transfer the fines from ILLiad to Voyager.  I'm curious to know
> how other libraries handle overdues? and if you charge daily fines, how
> much do you charge?  Thanks.
>
> Monica Riley
> ILL Librarian
> Robert W. Woodruff Library
> Atlanta University Center
>