Aleph Circulation History
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 non-patron (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 Paton Loans | Count of loans to Aleph patrons with a patron status code less than 60. | Integer |
|
Number of Aleph Non-Patron Loans | Count of loans to Aleph patrons with a patron status code of 60 or higher | Integer |
|
Aleph Barcode | Barcode from Aleph Items table. Note that Aleph items is a static table of items at the time of migration to Alma. | Text |
|
Aleph Create Date | Item date of creation in Aleph | Date |
|
Aleph Create FY | Item creation fiscal year | Text |
|
Aleph Create Month | Item creation calendar month | Text |
|
Aleph Create Month FY | Item creation fiscal year month | Text |
|
Aleph Create Year | Item creation calendar year | Text |
|
Aleph Loan Count | Static number of total Aleph loans | Text |
|
Aleph Migrated Flag | Indicates whether the item migrated from Aleph (Y) or was added post-migration (N) | Text |
|
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 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 |
|
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 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 |
|