[OPEN-ILS-GENERAL] Report for Holds

[Bill Ott]

Coleman, Marlene wrote:
> Can someone tell me the field (data) other than Capture date, that would be a timestamp for when an item actually is given the status of "on holds shelf".  In a multibranch system, and consortium environment, the capture timestamp may change the status to "intransit" and doesn't tell when it actually is placed "on the hold shelf".  I'm trying to edit a report template to replace capture date to something to assist in pulling "old holds" from the holds shelf, for our situation.  Does this data field exist?
>   

If I recall correctly, what is displayed in the staff client as the 
"Available" time may either be the capture time, or dest_recv_time from 
the action.hold_transit_copy table.  For now, there are two places to 
look to determine this time, depending on whether or not the item was 
transited.

I believe, starting in version 1.6, there is an additional field in 
action.hold_request for "shelf time", which is what you're looking for.