Interlibrary Loan Reports

Princeton University Library
Interlibrary Loan and Document Delivery Reports

Notice:

I have created a Static Reports page in order to share the results of the statistics which must be gathered through Access.

To generate a report, select the link from the left.

Useful Reports:

Name of Report	Description
Find Transaction	Search for any transaction in Illiad.
Verify Elecdel Files	Show all TNs delivered and verify the pdf file.
Staff Workload Tracker	Summary of a staff member's ILLiad workload by year.

Borrowing Reports

Name of Report	Description
Borrowing Articles by Department	Filled Articles for ILS patrons by department and fiscal year.
Borrowing Cancelled Articles by Department	Articles cancelled by ILS per department and fiscal year.
Borrowing of Checked Out Materials	Materials requested b/c they were checked out at the time of ordering by FY.
Borrowing Loans by Department	Filled Loans for ILS patrons by department and fiscal year.
Borrowing Cancelled Loans by Department	Loans cancelled by ILS per department and fiscal year.
Borrowing LUO materials	List of borrowing requests held as Library Use Only.
Articles downloaded from the web	Summary of monthly pay-per-view/downloading activity.
Borrowing held in LRC or Rare Bks	List of borrowing requests held in LRC or Rare Books.
Borrowing Statuses	Status of all borrowing requests
Most Requested Books	Titles of books borrowed 2 or times
Most Requested Journals	Titles of journals from which 6 or more articles were obtained
Requests by Department	Number of requests submitted by each department including both ILS and AE
Requests by Department and User	Number of requests submitted by each department, broken down by user status - Includes both ILS and AE
Requests by Hour	Number of requests submitted each hour of the day
Requests Sent by Day	Number of ILL requests sent to lending libraries each day for a selected month
Turnaround Time by Month	Time from submission of a request until it is received, showing where the time goes.
UMI Dissertations Purchased	List of all dissertations successfully received from UMI.
Proquest Digital Dissertations Downloaded	List of all dissertations successfully downloaded from Proquest.
Users by Department	Number of registered, valid users in each department

Article Express Reports.

Name of Report	Description
All Active Requests	A list of all active Article Express Requests
Cancelled Requests	A list of all Article Express Requests which were cancelled
Email Sent by Branch	Shows all of the pull slip emails which were sent by a particular branch
Most Requested Journals	Titles of journals from which one or more article(s) were obtained
Requests by Department	Shows the number of all Article Express Requests submitted by each Department
Requests Sent To ILS	Lists all of the requests unable to be filled by Article Express
Sent to London	A list of all Article Express Requests which have been sent to London for filling by the British Library
Sent Requests	A list of all active Article Express Requests which have been sent to a Doc Provider
Turnaround Time	The turnaround time by month for all Article Express Items

Lending Reports

Name of Report	Description
Expired OCLC Requests	All OCLC requests which have been in the system for over 9 days
Old RLIN Requests	All RLIN requests which have been in the system for over 9 days
Requests Awaiting Stacks Search	All active requests which have been in the system for over 4 days
Lending Bills	All Bills for non-IFM items
Loan Labels	Prints out a loan label for anything in Lending
Microforms on Loan	Microforms out on loan to other libraries
Shipping Labels	Prints out a shipping label for anything in Lending
Lending Statuses	Status of all lending requests
Requests Filled and Unfilled	Number of requests filled or unfilled (and the reason why unfilled)
Requests Filled by Day	Number of lending requests filled each day during a selected month
Requests Received by Day	Number of lending requests received each day during a selected month
Who We Lend To	Number of lending requests filled for each library to which we loaned 10 or more items

Administrative Reports

Name of Report	Description
Lending Library Report by Month	Requests and their most recent status for a particular lender during the selected month and year
Requests Sent Over 40 Days Old	All items at the status 'Request Sent' over 40 days old
Rapid Requests Sent Over 4 Days	All items at the status 'Request Sent' over 4 days old
Searching Report for Staff by Date	Requests sent by ILL borrowing staff for a particular date