Skip to main content
OCLC Support

Why are my Doc Del or Borrowing Turnaround Time report for Loans showing I do not have any of the time period I chose?

Symptom
  • When you put in your query for the Turnaround Time report for Doc Del, it shows that there were none.
Applies to
  • ILLiad
Resolution

Here is the reason the Turnaround Time Report for Doc Del may not show any requests:

  1. The Turnaround Time report requires all the steps in the query.  If a step is skipped, then the Transaction is not counted.
  2. The Doc Del Turnaround time Report query is on the Document Delivery Web Reports page.
  3. Here are the steps:

             1. t.RequestType = 'Loan'

             2. AND t.ProcessType = 'Doc Del

3. AND ((a.ChangedTo LIKE '%Submitted by Customer') OR (a.ChangedTo = 'Request Added through Client') OR (a.ChangedTo like 'Imported from%'))

4. AND ((b.ChangedTo = 'Request in Processing') OR (b.ChangedTo = 'Awaiting Document Delivery Processing'))

5. AND c.ChangedTo = 'In DD Stacks Searching'

6. AND d.ChangedTo = 'Awaiting Doc Del Customer Contact'

7. AND e.ChangedTo LIKE '%Notified%'

 

If any are missing, then the Transaction is not counted.  When you use Routing rules to bypass steps, you will see zeros in the report.

Additional information
Page ID
40753