Hi Tessa, 

"Delete Date/Time" can be found in the data source Last Copy Delete Time - it may be in other sources also, but I don't know. I've been working on reviewing the sources, and my notes for this source is "Lists bib record ids with the date the last copy was deleted. NOTES: appears to only list bibs that were not also deleted. We use the library setting "Retain empty bib records / Retain a bib record even when all attached copies are deleted = False"; maybe useful to find some empty records? More testing needed." FWIW, my complete data sources review notes are viewable here: https://docs.google.com/document/d/1uCtW5IRatODwhOJJvPMeVxb35h63TuNzifUZoFn0NH8/edit?usp=sharing. We are running Evergreen 3.12.

More specifically for counting deleted copies, we run a monthly recurring report using the Item data source, filtering by Item > Is Deleted = True and Item > Last Edit Date/Time = Year + Month (plus the owning library and stats cats).  Our libraries have been using this report for years, and the numbers seem to align with other counts/staff expectations. Here are screenshots of the template:

Display fields
image.png

Filters
image.png

I hope this helps!
Lindsay

Lindsay Stratton
Integrated Library System Administrator / Systems Librarian
Westchester Library System
570 Taxter Rd., 4th Floor
Elmsford, NY 10523


On Thu, Mar 13, 2025 at 12:15 PM Jennifer Weston via Evergreen-reports <evergreen-reports@list.evergreen-ils.org> wrote:
Forwarding message sent to evergreen-catalogers list - 
Welcome, Tessa!
Anyone have Reporting suggestions to share?

---------- Forwarded message ----------
From: Tessa Johnson <Tessa.Johnson@thehowe.org>
To: "evergreen-catalogers@list.evergreen-ils.org" <evergreen-catalogers@list.evergreen-ils.org>
Cc: 
Bcc: 
Date: Thu, 13 Mar 2025 16:05:00 +0000
Subject: Question about database fields
Hey all,
New here. Feeling a little overwhelmed with the reporting side of things. At the moment I'm trying to run a report to see how many items were deleted from our catalog each month. I tried using "Last Edit Date/Time" field, but that doesn't seem to work. I saw in some of the documentation that there's a "Delete Date/Time" field, but I can't find in! Any suggestions for where to look for this field? Additionally, is there any document that talks about ALL of the fields, what they mean and where to find them? 

Thanks,
Tessa


--------------------------------
Tessa Johnson (she/her)
Collection Development & Systems Manager
Howe Library 


Book Cover 

Written correspondence to or from the Town of Hanover, its officials, and employees regarding town business is a governmental document, and is generally subject to public disclosure under NH RSA 91-A, the Right to Know Law. Though there are certain limited exceptions, you should assume that written correspondence is a public record, regardless of whether the correspondence is to or from a “hanovernh.org” email address, another email address, or another platform/website.


_______________________________________________
Evergreen-reports mailing list -- evergreen-reports@list.evergreen-ils.org
To unsubscribe send an email to evergreen-reports-leave@list.evergreen-ils.org