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.
testing for new database structure. 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

2002 Princeton University Library
Updated 02/20/02