| Field Name | Description | Data type | Notes on Usage |
| Number of Aleph Loans - All | Count of loans on items that circulated in Aleph. Includes loans on items migrated to Alma and items that were withdrawn prior to Alma migration. Includes patron and pseudopatron loans. | Integer | These measures cannot be used in conjunction with measures for 'Alma migrated' items, or in conjunction with data in Alma Items, Alma Holdings or Alma Bibs. Use these measures with fields from Aleph Circulation History table only. |
| Number of Aleph Items Loaned - All | Count of the number of unique items that circulated in Aleph. Includes items migrated to Alma and items that were withdrawn prior to Alma migration. Includes items loaned to patrons and pseudopatron loans. | Integer | |
| Number of Aleph Loans - Alma migrated only | Count of loans on items that circulated in Aleph and were migrated to Alma. Includes patron and pseudopatron loans. | Integer | These measures can be used with any other fields except 'Aleph - All' measures. |
| Number of Aleph Items Loaned - Alma migrated only | Count of the number of unique items that circulated in Aleph and were migrated to Alma. Includes patron and pseudopatron loans. | Integer | |
| Alma User Group Code | Look-up table that maps Aleph Patron Status to Alma User Group Code and Alma User Group Description. | Text | Alma User Group look-up |
| Alma User Group Description | |||
| Due Date | Date | ||
| Item Status Code | Loan policy code | Text | Item Status code definitions were not standardized in Aleph. Some libraries may have defined the same code differently. Include Sublibrary in a report of Aleph loan statistics to get correct counts by Item Status code. |
| Item Status Description | Loan policy description | Text | |
| Item Process Status Code | Item process Status Codes, e.g., HD, MI, MS | Text | |
| Item Process Status Description | Item Process Status Description. e.g, Harvard Depository, MIssing, Lost | Text | |
| Last Renew Date | Date | ||
| Loan Cataloger | Username of staff person who loaned the item | Text | |
| Loan Cataloger IP | Workstation identifier or internal IP of the workstation from which the loan was made | Text | |
| Loan Date | Date | ||
| Loan Year | Calendar year | Date | |
Loan Month | Calendar month | Date | |
Loan FY | Fiscal year. Fiscal year starts July 1. | Date | |
| Loan Month FY | Month order by fiscal year. July is the first month of the fiscal year. | Date | |
| Loan Status | Contains: A (Active), C (Claimed Returned), and L (Lost) | Text | |
| Loan Number | Unique identifier for loan | Integer | |
| Loan Source | Contains H when the loan was created following a hold request and null otherwise. | Text | |
| Material type | Item material type | Text | |
| Non-Patron Loan Flag | Field contains Y for Patron Status Codes defined for pseudopatrons and N for Patron Status Codes for real patrons. | Text | Add filter for Non-Patron Loan Flag = N to exclude pseudopatron loans from loan count statistics. |
| Number of Renewals | Integer | ||
| Original Due Date | Date | ||
| Patron ID | Psuedopatron IDs are retained otherwise the field is null | Text | |
| Patron Note | Patron | ||
| Patron Status Code | Codes such as: 01, 02, 13, 60, | Text | See Non-Patron Loan Flag for full list of codes and descriptions |
| Patron Status Description | Description for each code: Faculty, Staff, Undergraduate Student, Bindery | Text | |
| Patron Type Code | Patron affiliation code | Text | |
| Patron Type Description | Patron affiliation description | Text | |
| Recall Date | |||
| Recall Due Date | |||
| Recall Type | |||
| Renewal Cataloger | |||
| Renewal Cataloger IP | |||
| Return Cataloger | |||
| Return Cataloger IP | |||
| Return Date | |||
| Sublibrary |
General
Content
Integrations