Borrowing Requests (Resource Sharing)
Using the Borrowing Requests (Resource Sharing) area, the Design Analytics user can create reports/dashboards for the Borrowing Requests (Resource Sharing) area and is able to answer the following types of business questions:
- Which partners were requested
- Request counts
- Which type of users issue the requests
- Time statistics between request and arrival
- How many requests were rejected
- How many requests were completed

Star Diagram – Borrowing Requests
Field Descriptions
The following lists the fields available in Borrowing Requests.

Borrowing Requests – Field Descriptions
Borrowing Request Details
The Borrowing Requests table is a fact table that stores all measures relating to specific borrowing requests from a specific partner. This table also holds details about the borrowing requests, including request status, request format, and locate status. The primary keys are ID and PARTNER_ID.
Field | Description | Additional Information |
---|---|---|
Request Level Measurements | ||
Num of Requests | Holds the number of patron borrowing requests | This includes the number of requests from all potential partners in the Rota |
Num of Requests Filled | Holds the number of requests that have a receiving date | |
Number of Request Renewals | Holds the number of request renewals | |
Num of Request Renewal Rejections | Holds the number of request renewal rejections | |
Num of General Messages | Holds the number of general messages | |
Num of Locate Failed Requests | The number of failed locate requests | Includes data for requests that were created from May 2021 and later |
Partner Level Measurements | ||
Num of Partners in Rota (Total) | Holds the total number of partners in the Rota | |
Num of Partners in Rota (Consulted) | Holds the number of consulted partners in the Rota | |
Num of Active Partner Requests | Holds the number of borrowing requests whose Partner Active Status is set to Active | |
Num of Digital Accesses | Holds how many requested digital files were actually accessed by patrons | |
Num of Non Fulfilled Partner Requests | Holds the number of borrowing requests whose Partner Active Status is set to Reject (indicates that the request to this partner cannot be fulfilled) | |
Num of Canceled Partner Requests | Holds the number of canceled partner requests | |
Num of Expired Partner Requests | Holds the number of expired partner requests | |
Num of Rapid Local Override | The number of times librarians overrode the RapidIILL block for borrowing requests when the borrowing library has the requested item locally. | |
Days of Request for Partner | Holds the number of days of request for partner. The time begins when the request is sent to the partner and ends when the request is either sent to a different partner or is completed. | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Days of Request to Material Arrival | Number of days from when the request was created until the material arrived | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Days of Request Sent to Material Arrival | Number of days from when the request was sent to the partner until the material arrived | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Days of Request Sent to Non-Fulfilled | Number of days past from when the request was sent to the partner until it was rejected (non-fulfilled) | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Days of Arrival to Patron Loan | Number of days from when the material arrived until the patron loaned the item | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Days of Patron Check-In to Return | Number of days from when the patron checked in the item until it was returned to the ILL library | The Day value is the number of complete days. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Request for Partner | Holds the number of hours of request for partner. The time begins when the request is sent to the partner and ends when the request is either sent to a different partner or is completed. | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Request to Material Arrival | Number of hours from when the request was created until the material arrived | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Request Sent to Material Arrival | Number of hours from when the request was sent to the partner until the material arrived | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Request Sent to Non-Fulfilled | Number of hours past from when the request was sent to the partner until it was rejected (non-fulfilled) | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Arrival to Patron Loan | Number of hours from when the material arrived until the patron loaned the item | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Hours of Patron Check-In to Return | Number of hours from when the patron checked in the item until it was returned to the ILL library | The Hour value is the number of complete hours. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Request for Partner | Holds the number of minutes of request for partner. The time begins when the request is sent to the partner and ends when the request is either sent to a different partner or is completed. | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Request to Material Arrival | Number of minutes from when the request was created until the material arrived | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Request Sent to Material Arrival | Number of minutes from when the request was sent to the partner until the material arrived | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Request Sent to Non-Fulfilled | Number of minutes past from when the request was sent to the partner until it was rejected (non-fulfilled) | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Arrival to Patron Loan | Number of minutes from when the material arrived until the patron loaned the item | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Minutes of Patron Check-In to Return | Number of minutes from when the patron checked in the item until it was returned to the ILL library | The Minute value is the number of complete minutes. If the value is composed of several time periods, the sum of the values is considered. |
Digital Resource First Access Date |
The date and time that the digital resource was first accessed |
|
Digital Resource First Access Date (Calendar) |
The date that the digital resource was first accessed (without the time) |
|
Identifier | Holds the ISSN/ISBN of the requested resource | |
Internal ID | Holds the Unique ID of the borrowing request | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Item ID | Holds the Item ID of the borrowing resource | |
Item Loan ID | Holds the item loan ID after the item was loaned | |
Fulfillment Request ID | Hold Request ID | |
Item Loan Date | Holds the date that the material was loaned by the patron | |
Item Return Date | Holds the date that the item was returned to the ILL | |
Item Arrival Date | Holds the date that the material arrived to the library | |
Journal Title | The title of the journal of the borrowing request | |
Additional Notes | The additional notes added under the Notes tab of the Resource Sharing Borrowing Requests page | |
Chapter Title | The chapter title of the borrowing request | |
Chapter Number | The chapter number of the borrowing request | |
Is Filled | Indicates if the borrowing request was filled | |
Issue | The issue of the borrowing request | |
Pages | The pages of the borrowing request | |
Volume | The volume of the borrowing request | |
Label | The labels on the borrowing request | |
Label History | The deleted labels on the borrowing request | |
Level of Service | The level of service of the borrowing request | |
Lending Library | The lending library | |
Lending Institution | The lending institution | |
Partner Active Status | The status of a partner on a specific request Rota | Possible values are Active/Rejected/Non-Active/Cancelled/Expired. |
Citation Type | Indicates whether the resource is an article or book | |
Locate Status | Indicates whether the resource is located or not | |
Lost Item Fee Amount | The mount of the lost item fee | |
Lost Item Fee Currency | The currency of the lost item fee | |
Lost Item Fee VAT | The VAT of the lost item fee | |
BL Request Targets | British Library codes for where to search for the material | |
BL Customer ID | Holds the customer code and password of the British Library system | |
BL Requested Delivery Terms | British Library codes for the delivery format and speed | |
BL Requested Actions | British Library codes for other instructions for queries | |
Needed by Date | Holds the date by which this material is needed | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Request Non-Fulfilled Date | Holds the date that the request was rejected for this partner | |
Request Sending Date | Holds the date that the request was sent to the partner | |
Item Check-In Date | Holds the date that the item was returned to the library by the patron | |
Item Loan Indicator | Indicates whether the requested resource was loaned | |
Patron Information Indicator | Indicates whether more information is needed from the patron | |
Request Completed Indicator | Indicates whether the lifecycle of the request is in progress or it is completed | |
Max Fee | Holds the maximum fee that the patron is willing to pay for this service | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Agree Copyright | Indicates whether the patron has checked the Agree Copyright check box | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Note | A text field for comments | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Creator | Stores the creation date | |
Modification Date | Stores the user name that modified the record | |
Modified By | Stores the modification date | |
Borrowing Request Status | Holds the status of the request | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Cancellation Reason | The cancellation reason of the borrowing request | This enables you to follow trends and understand why requests are being cancelled. |
Copyright Status | The copyright approval status | |
Shipping Cost | The shipping cost. | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Shipping Cost Currency | The currency of the shipping cost. | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Shipping Date | The date and time the lender shipped the item to the borrower. | Date fields can consist of a partial date, such as just the year or a month and year. |
Shipping Date (Calendar) | The date the lender shipped the item to the borrower. | Calendar Date fields always consist of a month, date, and year. If the information is not provided, 01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date. |
External Identifier | The ID of the library that fulfills the borrowing request | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Request Type | The request format and the request type | |
Requested Format | Indicates the format of the request (Digital/Physical) | See the field location in Alma in the figure Borrowing Requests - Edit, below. |
Supplied Format | The format in which the borrowing request was supplied to the patron | Possible values: Physical or Digital |

Borrowing Requests - Edit
Borrowing Creation Date
The Creation Date table is a dimension table that stores details about the borrowing request creation date. Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:
- Calendar Fields – These are date fields that are displayed in the calendar.
- Fiscal Date Fields – These are date fields that match the institution's fiscal period. In the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.
Using this dimension, the user may drill down from year to month to the specific date on which the borrowing request was created. The total number of borrowing requests is listed next to the relevant level in the hierarchy.
Field | Description | Additional Information |
---|---|---|
Borrowing Creation Date and Time | Stores the borrowing creation date in the date format 2/29/2012 and the time in hours and minutes | |
Borrowing Creation Date | Stores the borrowing creation date in the date format 2/29/2012 | |
Borrowing Creation Start of Week | The date of the first business day of the week | |
Borrowing Creation Week Number | The number of the week of the year | |
Borrowing Creation Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
Borrowing Creation Month | Stores the month of the date in month description format such as February | |
Borrowing Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Borrowing Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
Borrowing Creation Year | Stores the year of the date in string format such as 2012 | |
Borrowing Creation Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
Borrowing Creation Fiscal Year | Stores the fiscal year of the date in string format such as 2012 | |
Borrowing Creation Date Filter | Used to filter report results by date. | |
Borrowing Creation Year-Month | The year and the month in a format such as 2023-1 | |
Borrowing Creation Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Rapido Attributes
The Rapido Attributes table is a dimension table that stores details about Rapido.
Field | Description | Additional Information |
---|---|---|
Rapido Automatic Renewals Allowed | Indicates if automatic renewals of the borrowing request are allowed | |
Rapido Cancelled by Mediation | Indicates (Y/N) whether the borrowing request was cancelled during staff mediation | |
Rapido Expire Time (in days) | The number of days until the borrowing request expires | |
Rapido Fill Locally | Indicates if the borrowing request is filled locally | Possible values: Yes, No, Test |
Rapido Indicator | Indicates if the request originated from Rapido. | |
Rapido Label | The Rapido label | |
Rapido Label History | The Rapido label history | |
Rapido Number of Renewals | The number of times the borrowing request was renewed | |
Rapido Pod Delivery Time (in days) | The Rapido Pod delivery time (in days) | |
Rapido Pod Delivery Time (in hours) | The Rapido Pod delivery time (in hours) | |
Rapido Pod ID | The Rapido Pod ID to which the request is linked. | |
Rapido Pod Loan Period | The Rapido Pod loan period | |
Rapido Pod Name | The Rapido Pod name | |
Rapido Pod Shipping Cost | The Rapido Pod shipping cost | |
Rapido Source of Request | The source of the Rapido borrowing request | Possible values are:
|
Due Date
The Due Date table is a dimension table that stores details about the due date of transactions, such as month, year, and quarter. The primary keys are Date_Key.
Field | Description | Additional Information |
---|---|---|
Due Date | Stores the loan date in the date format 2/29/2012 | |
Due Start of Week | The date of the first business day of the week | |
Due Week Number | The number of the week of the year | |
Due Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
Due Month | Stores the month of the date in month description format such as February | |
Due Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Due Quarter | Stores the quarter of the date in a display format such as Q1 | |
Due Year | Stores the year of the date in string format such as 2012 | |
Due Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | |
Due Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
Due Year-Month | The year and the month in a format such as 2023-1 | |
Due Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Partner
The Partner table is a dimension table that stores the details about the partner to which the borrowing request was sent. The primary key of the table is PARTNER_ID.
Field | Description | Additional Information |
---|---|---|
New for December! Alternate Symbol |
The alternate symbol of the institution | |
Partner ID | Holds the unique partner ID | |
Partner Institution | The institution of the partner | |
Partner Name | Holds the partner name | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Partner Code | Holds the partner code | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Partner Status | Holds the partner status (Active/Reject/Non Active) | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Partner System Type | The system type of the resource sharing partner | |
Partner Deleted Status | Indicates if the partner was deleted. | |
Profile Type | Holds the protocol type with which we communicate with the partner (ARTEmail, NCIP) | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Average Supply Time | Average time it takes for the supplier to process the request and send the material | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Delivery Delay | Average time it takes to send an item back to this supplier | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Currency | Holds the currency that this partner is using | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
Creation Date | Stores the name of the user that created the record | |
Created By | Stores the creation date | |
Modification Date | Stores the user name that modified the record | |
Modified By | Stores the modification date |

Borrowing Requests - Partners
Requester
The Requester table is a dimension table that stores the details about the Staff and Public users that request the item. The primary key of the table is USER_ID.
The field descriptions can be found in the User Details shared dimension.
Library Unit
The Library Unit table is a dimension table that stores details about the library where the borrowing request was created. The primary key of the table is LIBRARYID.
The field descriptions can be found in the Library Unit shared dimension.
Bibliographic Details
The Bibliographic Details table is a dimension table that stores the bibliographic details of the borrowing request item. The fields are from the MMS_DISPLAY table. The primary key of the table is MMS_ID.
The field descriptions can be found in the Bibliographic Details shared dimension.
Assigned To
The Assigned To table is a dimension table that stores details about the user details of the staff member to whom the request is assigned.
Field | Description | Additional Information |
---|---|---|
Campus Code | Stores the campus code of the user | |
External ID | Stores the ID of the user in the originating system | |
First Name | Stores the user’s first name | |
Gender | Stores male or female | |
Job Description | Stores free-form text that describes the function of the user in the library | |
Job Title | Stores the job category definition to which the user belongs based on the Job Categories code table | |
Last Activity Date | The last date that a patron made a request or borrowed or returned an item | |
Last name | Stores the user’s last name | |
Middle Name | Stores the middle name of the user | |
Preferred First Name | Stores the user’s preferred first name | See the field location in Alma in the image below. |
Preferred Last Name | Stores the user’s preferred last name | See the field location in Alma in the image below. |
Preferred Middle Name | Stores the user's preferred middle name | See the field location in Alma in the image below. |
Primary Identifier | Stores the primary identifier that the user uses in order to log on to Alma | |
Status | Indicates if the user is active | |
User Group | Stores the group with which the user is associated such as Faculty, Graduate, or Student | |
User ID | Stores the unique ID of the user | |
IdP Service in Use | Indicates if an identity provider service is in use | |
User Record Type | Indicates if the user is a Public User or a Staff User | |
User Title | Stores the title of the user | |
User Type | Stores the values Internal and External |
Institution
Shared Dimensions with Other Subject Areas
For information concerning shared dimensions with other subject areas, see Shared Dimensions.