TMSUSERS Archives

The Museum System (TMS) Users

TMSUSERS@SI-LISTSERV.SI.EDU

Options: Use Monospaced Font
Show Text Part by Default
Show All Mail Headers

Message: [<< First] [< Prev] [Next >] [Last >>]
Topic: [<< First] [< Prev] [Next >] [Last >>]
Author: [<< First] [< Prev] [Next >] [Last >>]

Print Reply
Subject:
From:
Patricia Raynor <[log in to unmask]>
Reply To:
The Museum System (TMS) Users
Date:
Fri, 11 Apr 2003 12:10:44 -0400
Content-Type:
text/plain
Parts/Attachments:
text/plain (38 lines)
This is a problem that I have been trying to solve unsuccessfuly.  With our
old database we could track loan objects individually by end date.  We have
many loans where multiple objects have separate loan ending dates (we borrow
and lend a lot of paper artificats for shorter periods of time)

We do not create a new loan for a single object.  I also use the loan
reserve status field to indicate whether it is still on loan or has
returned.  However, I have not been able to satisfactorily come up with a
solution for tracking single objects by loan end/return date.

I'd also like to hear how others track single loan objects.

Patricia  A. Raynor
Museum Specialist
National Postal Museum
Smithsonian Institution
Washington, DC 20560-0570
202-633-9376
202-786-2767 (fax)

Temporary mailing address:
National Postal Museum
Smithsonian Institution
2 Massachusetts Avenue, NE
Post Office Box 75039
Washington, DC 20002

>>> [log in to unmask] 04/11/03 11:47AM >>>
The following is a question from NPG's Registrar's office:
Can anyone share with me how you track single objects within a loan of
multiple objects when that single object returns from loan earlier than
the
rest of the objects?  Is a new loan created for that single object or do
you
track the status of each object individually on the objects card in "Loan
reserve/status"?  For reporting purposes I need to be able to track the
exact dates each object has been out on loan.

ATOM RSS1 RSS2