Lending Requests (Resource Sharing)
- Which partners were requested?
- Lending Request counts
- Which type of users issue the requests
- Time statistics between request and sent

Field Descriptions

Lending Requests Details
Field | Description | Additional Information |
---|---|---|
Actual Shipped Format | The shipping format | Possible Values:
|
Additional Notes | The additional notes added under the Notes tab of the Resource Sharing Lending Requests page | |
Borrowing Institution (Rapid ILL) | The Rapid ILL borrowing institution | |
Borrowing Library (Rapid ILL) | The Rapid ILL borrowing library | |
Citation Type | Indicates whether the resource is an article or book | |
Creator | Stores the creation date | |
Days of Material Sent to Return | Number of days from when the material sent to the partner until the material returned to the 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. |
Days of Request | Holds the number of days from when the request was created until the request was 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 Created to Material Sent | The number of days from when the lending request was created until the material was sent to the requested partner | 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. |
External Request ID | Holds the Request ID that arrived from the partner (external system ID) | See the field location in Alma in the figure Lending Requests - Edit, below. |
Hours of Material Sent to Return | Number of hours from when the material sent to the partner until the material returned to the 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. |
Hours of Request | Holds the number of hours from when the request was created until the request was 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 Created to Material Sent | Number of hours from when the lending request was created until the material was sent to the requested partner | 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. |
Identifier | Holds the ISSN/ISBN of the requested resource | |
Internal ID | Holds the Unique ID of the lending request | |
Item Barcode | Holds the item barcode | |
Item ID | Holds the Item ID of the borrowing resource | |
Item Policy | Hold the item policy | |
Item Return Date | Holds the date that the item returned to the library | |
Item Sent Date | Holds the date that item was sent to the partner | |
Journal Title | The title of the journal | |
Label | The labels on the lending request | |
Label History | The deleted labels on the lending request | |
Lending Request Status | Holds the status of the request | See the field location in Alma in the figure Lending Requests - Edit, below. |
Level of Service | The level of service of the lending request | |
Locate Status | Indicates whether the resource has been 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 | |
Material Type | Holds the Item material type | |
Minutes of Material Sent to Return | Number of minutes from when the material sent to the partner until the material returned to the 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. |
Minutes of Request | Holds the number of minutes from when the request was created until the request was 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 Created to Material Sent | Number of minutes from when the lending request was created until the material was sent to the requested partner | 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. |
Modification Date | Stores the modification date | |
Modified By | Stores the user name that modified the record | |
Needed by Date | Holds the date by which this material is needed | See the field location in Alma in the figure Lending Requests - Edit, below. |
Days of Delivery Duration | The number of days from when the lending library sent the requested material until the patron received it. | |
Hours of Delivery Duration | The number of hours from when the lending library sent the requested material until the patron received it. | |
Minutes of Delivery Duration | The number of minutes from when the lending library sent the requested material until the patron received it. | |
Received Date | The date that the requested material was received | |
Note | Text field for comments | See the field location in Alma in the figure Lending Requests - Edit, below. |
Num of Canceled Requests | Holds the number of requests canceled by the borrower | |
Num of Expired Requests | Holds the number of requests that expired | |
Num of General Messages | Holds the count of messages sent between the borrower and lender | |
Num of Locate Failed Requests | The number of failed locate requests | Includes data for requests that were created from May 2021 and later |
Num of Recalled Requests | The number of recalled requests | |
Num of Requests | Holds the number of lending requests | This includes the number of requests from all potential partners in the Rota |
Number of Non-fulfilled Requests | Holds the number of rejected requests | |
Overdue | Indicates if the item is overdue | |
Overdue Sent Date
|
The date the last overdue message was sent | |
Rapido Indicator | Indicates if the request originated from Rapido. | |
Rapido Pod | The Rapido Pod to which the request is linked. | |
Reject Reason | The reason the lending request was rejected | |
Requested Format | Indicates the format of the request (Digital/Physical) | See the field location in Alma in the figure Lending Requests - Edit, below. |
Requester Email | Holds the email address of the requester | See the field location in Alma in the figure Lending Requests - Edit, below. |
Shipping Cost | The shipping cost. | See the field location in Alma in the figure Lending Requests - Edit, below. |
Shipping Cost Currency | The currency of the shipping cost. | See the field location in Alma in the figure Lending Requests - Edit, below. |

Lending Creation Date
- Calendar Fields – These are date fields as they display 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.
Field | Description | Additional Information |
---|---|---|
Lending Creation Date | Stores the lending request creation date in a date format such as 2/29/2012 | |
Lending Creation Start of Week | The date of the first business day of the week | |
Lending Creation Week Number | The number of the week of the year | |
Lending 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 |
Lending Creation Month | Stores the month of the date in month description format such as February | |
Lending Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Lending Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
Lending Creation Year | Stores the year of the date in string format such as 2012 | |
Lending Creation Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
Lending Creation Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
Lending Creation Date Filter | Used to filter report results by date. | |
Lending Creation Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific creation date. | This column provides the user the option to view the cumulative measures in each level of the hierarchy |
Rapido Attributes
Field | Description | Additional Information |
---|---|---|
Rapido Automatic Renewals Allowed | Indicates if automatic renewals of the borrowing request are allowed | |
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 if 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
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 Year | Stores the fiscal year of the date in string format such as 2012. | |
Due Time | Stores the time in the hours:minutes:seconds format for the loan date | |
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
Field | Description | Additional Information |
---|---|---|
Partner ID | Holds the unique partner ID | |
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 Description | Holds the partner description | |
Partner Status | Holds the partner status (Active/Reject/Non Active) | See the field location in Alma in the figure Borrowing Requests - Partners, below. |
New for June! 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 used to 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 a 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 the item back to the 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 |

Library Unit
Location at Time of Loan
Bibliographic Details
Physical Item Details
Field | Description | Additional Information |
---|---|---|
Modification Date | The date that the physical item was modified. | |
Modified By | The user that modified the physical item. | |
Creator | the username of the operator that created the physical item | |
Creation Date | The date that the physical item was created. | |
Alternative Call Number Type |
An alternative call number type (Note that Alternative Call Number=Item Call Number.) |
|
Description | Description of the item | |
Barcode | The unique identifier of the specific physical item | |
Material Type | Describes the nature of the material represented by the item record | |
Item Policy | Defines the conditions under which a request for this item can be fulfilled | |
Provenance Code | A code used to identify separate items that belong to different groups (but may be shelved together) | |
Base Status | Indicates the availability of the item in its permanent location (in place/not in place) | |
Process Type | When the item is being processed (acquisition/loan/bindery/etc) this indicates the type of processing | |
Lifecycle | Indicates whether the item is active or deleted | |
Chron I | The main level of chronology - usually the year | |
Chron J-M | Additional chronology fields | |
Enum A | The main level of enumeration - usually the volume | |
Enum B-H | Additional enumeration fields | |
Has Committed to Retain | Indicates if the library has committed to retain the item | |
Retention Note | A free-text note concerning the library's commitment to retain the item | |
Retention Reason | The reason the library has committed to retain the item | |
Is Magnetic | Whether the item is magnetic material or not. | |
Expected Receiving Date | The date when a purchased item is expected to arrive at the library | |
Due Back Date | Indicates the date that an item in a temporary location is due back to its permanent location | |
Inventory Date | The last time inventory was checked (not currently in use) | |
Inventory Number | The inventory number | |
Inventory Price | The price of the physical inventory for each physical item | |
Last Loan Date | The last time the item was loaned | |
Statistics Note 1-3 | Holds statistic notes | |
Internal Note 1-3 |
Internal notes 1-3 | |
Receiving Date | The date the material was actually received/activated for the first time | |
Temp Call Number Type | A call number type provided when the item is in a temporary location | |
Display Temp Call Number | A normalized temporary call number for display | |
Originating System ID | The ID of the item in the source system from which it has been imported | |
Temp Physical Location In Use | Whether the item is currently (at the time at which the report is run) in a temporary location or in a permanent location. |
For example: An item was moved from a permanent location to a temporary location on November 28, 2017. It was loaned on November 29, 2017, and when it was loaned, it was still in a temporary location. It was returned from loan on December 13, 2017. On December 14, 2017 it was returned to its permanent location. If an Analytics report was run between November 28 and December 13, the Temp Physical Location In Use is Yes. If the report was run before November 28 or after December 13, the Temp Physical Location In Use is No. Note that for resource sharing lending requests, this field is always "Yes" after the loan is performed. |
Time Loaned - not sum | The amount of time that the physical item was loaned | |
Permanent Call Number | The permanent call number | |
Fulfillment Note | The fulfillment note | |
Receiving Date and Time | The date and time the material was actually received/activated for the first time | |
Replacement Cost | The replacement cost | In order to filter your report based on the Replacement Cost field, you must add a second copy of this field and edit the formula with the following CAST("Physical Item Details"."Replacement cost" AS DOUBLE). This causes Alma Analytics to treat the field as numeric. |
Assigned To
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 | |
IdP Service in Use | Indicates if an identity provider service is in use | |
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 | |
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 |