We use the Loans module, and the loan renewed date field, with a Loans flex field group set up to record prior loan renewals, if a long-term loan. Loan begin and end dates are easily viewed and sorted via the List View, and alerts can be set up to notify Registrars when a loan is nearing the end of its loan period. Jeffrey Smith Assistant Registrar for Collections Information Collections Department Freer Gallery of Art and Arthur M. Sackler Gallery Smithsonian Institution [cid:image001.jpg@01D78456.649F3BD0] From: The Museum System (TMS) Users <[log in to unmask]> On Behalf Of Chad Petrovay Sent: Wednesday, July 28, 2021 11:31 PM To: ListServ tmsusers <[log in to unmask]> Subject: Re: Tracking Loan Expiration External Email - Exercise Caution Sounds like a decent use case for a flex field. On Wed, Jul 28, 2021, 11:53 Weathers, Kaitlyn <[log in to unmask]<mailto:[log in to unmask]>> wrote: External Email - Exercise Caution Hi all, I'm looking for some insight as to how you and your institutions track loan expirations in TMS. Unfortunately, we have not made full use of the loans module, so most of our information is living in the objects module. We currently use attributes to track expiration year with status flags that include the month of expiration. I'm hoping that we can establish a system so that we can develop a report that can be run to let us know when renewals are due. Right now what we're doing does not work for us. Any suggestions you all have would be appreciated! Best, Kaitlyn Kaitlyn Gardy Weathers Associate Registrar for Loans and Exhibtions Colonial Williamsburg Foundation Mailing: PO Box 1776 | Shipping: 309 First Street Williamsburg, VA 23185 Phone: 757.220.7548 | Fax: 757.565.8752 [colonialwilliamsburg.org/give/other-ways-giving/donate/?Code=BGNB01]<https://nam02.safelinks.protection.outlook.com/?url=http%3A%2F%2Fcolonialwilliamsburg.org%2Fgive%2Fother-ways-giving%2Fdonate%2F%3FCode%3DBGNB01&data=04%7C01%7Csmithje%40si.edu%7C52a1711acb234337c54708d952416e5b%7C989b5e2a14e44efe93b78cdd5fc5d11c%7C0%7C0%7C637631263247716497%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=D%2FVPk%2FwXDnECrQ94cHK5y28piabAYrZUsDHHBXrrxhM%3D&reserved=0> Help support the Colonial Williamsburg Foundation, a private, not-for-profit 501(c)(3) educational institution. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask]<mailto:[log in to unmask]> with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed. To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.