| Field Name | Description | Data type | Notes on Usage |
| Number of Aleph Loans | 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. |
| 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 | Code for patron affiliation or type | Text | Patron Type look-up table |
| Patron Type Description | Description of patron affiliation or type | Text | |
| Recall Date | Date | ||
| Recall Due Date | Date | ||
| Recall Type | Contains 01 for Regular, 02 for Rush | Text | |
| Renewal Cataloger | See Loan Cataloger | Text | |
| Renewal Cataloger IP | See Loan Cataloger IP | Text | |
| Return Cataloger | See Loan Cataloger | Text | |
| Return Cataloger IP | See Loan Cataloger IP | Text | |
| Return Date | Date | ||
| Sublibrary | Library code. Owning library at the time of the loan. | Text |
General
Content
Integrations