Lending Web Reports

The ILLiad Borrowing Web Reports will allow you to run Borrowing-specific reports regarding your requests, patrons, turnaround time, and other information. You will be able to see report results in both grid and chart data, and you will be able to export data to Microsoft Excel. Hover over the parameters of the report (i.e., Begin Date, End Date, Sites, Groups) for an explanation of the specific parameter.Report data will be displayed in a grid. Depending upon the report, visual charts and graphs may also be generated. You may choose how you wish the data to display using the Chart Options and by rearranging and reordering the report grids. All generated Borrowing Web Reports can be exported to Microsoft Excel.

Fill Rate Statistics

This report shows all of the requests that were received - broken down by articles and loans - for a time period. It also shows the percentage filled, cancelled, conditionalized and still in process for each request type.

Fill Rate Statistics query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Who We Lend To

This report shows the libraries receiving more than X items in a given time period (X being a variable to set). It shows the number of requests filled for each library, ordered from greatest to least, and the percentage of the overall amount filled.

Who We Lend To query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Request TypeLimit report results based on the type of request or include both types.
Number of RequestsLimit results in the report based on the number of requests that fit the criteria.
Typing 0 will return anything that fits the other criteria. Typing higher numbers will limit the results.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Requests Received by Day

This report shows the number of requests received by ILL staff for a particular day in the given time period. There is a line graph option as well.

Requests Received by Day query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Groups by SiteLimit results in the report based on group affiliation and processing site/delivery location.

Requests Received by System ID

This report shows the number of requests received by the system via a specific system ID. System ID options are OCLC, Docline (DOC), ISO ILL (ISO), Other (OTH), and Local (LOCL).

Requests Received by System ID query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Requests Filled by Day

This report shows the number of requests filled by ILL staff for a particular day in the given time period. There is a line graph option as well.

Requests Filled by Day query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Requests Filled and Unfilled

This report shows the number of requests filled and unfilled for a given time period. The unfilled requests break down by the reason for cancellation. There are two pie chart options for both the reasons for cancellation and the overall requests percentages.

Requests Filled and Unfilled query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Request TypeLimit report results based on the type of request or include both types.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Most Loaned Journals

This report shows the journals loaned from Lending more than X times (X being a variable you can set) for a given time period.

Most Loaned Journals query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Group ByThe field that results should be grouped by.
Number of RequestsLimit results in the report based on the number of requests that fit the criteria.
Typing 0 will return anything that fits the other criteria. Typing higher numbers will limit the results.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Most Loaned Monographs

This report shows the monographs loaned from Lending more than X times (X being a variable you can set) for a given time period.

Most Loaned Monographs query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Group ByThe field that results should be grouped by.
Number of RequestsLimit results in the report based on the number of requests that fit the criteria.
Typing 0 will return anything that fits the other criteria. Typing higher numbers will limit the results.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Most Unfilled Journals

This report shows the journals that were unfilled more than X times (X being a variable you can set) for a given time period.

Most Unfilled Journals query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Group ByThe field that results should be grouped by.
Number of RequestsLimit results in the report based on the number of requests that fit the criteria.
Typing 0 will return anything that fits the other criteria. Typing higher numbers will limit the results.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.

Turnaround Time

This report shows the amount of time required to fill articles, loans and both request types for a given period. It also shows the percentage of time spent by each part of the process. There is an option to turn on details for this report to view every request's turnaround time individually. Turning on details results in a very large report.

Turnaround Time query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Show Detailed Records for ArticlesShow detailed records for articles to display every transaction number, specific
times for each step of the process for that transaction, and the overall transaction
turnaround time. Selecting this option will result in a large report.
Show Detailed Records for LoansShow detailed records for loans to display every transaction number, specific
times for each step of the process for that transaction, and the overall transaction
turnaround time. Selecting this option will result in a large report.
Groups By SiteLimit results in a report based on group affiliation and processing site/delivery location.

Requests Submitted From Lending Web Page

This report shows the number of requests submitted using the Lending web page in the given time period.

Requests Submitted from Lending Web Pages query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
SitesLimit report results based on processing site/delivery location.

IFM Charges

This report shows the items billed via IFM for a given time period. This can be used to compare against the OCLC bills.

IFM Charges query
Begin DateThe beginning date of the report. This date is inclusive.
End DateThe end date of the report. This date is not inclusive.
Groups By SiteLimit results in the report based on group affiliation and processing site/delivery location.