[OPEN-ILS-GENERAL] Report for Holds

[Sharp, Chris]

Marlene,

Bill is correct.  The Available Time is the time at which the hold is considered available for pickup (and the time that triggers a hold notice via email).  If the item is captured for hold at the pickup library, the Capture Time will be the same as the Available Time.  Otherwise it will be the Transit Received at Destination Time (forget the exact wording at the moment).

Chris

Chris Sharp
PINES Program Manager
Georgia Public Library Service
1800 Century Place, Suite 150
Atlanta, Georgia 30345
(404) 235-7147
csharp at georgialibraries.org
http://pines.georgialibraries.org/

----- "Bill Ott" <bott at grpl.org> wrote:

> 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.