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:
- The Turnaround Time report requires all the steps in the query. If a step is skipped, then the Transaction is not counted.
- The Doc Del Turnaround time Report query is on the Document Delivery Web Reports page.
- 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
Information on how to fix this is in the If I want to Limit the Doc Del or Borrowing Turnaround Time Report for only requests sent through Automated Request Manager, how would I do that? help article.