The purpose of this page is to support individual colleges with:
Mapping existing user data for migration
Considering future requirements for SIS integration
Demystifying the identifier fields
Presenting suggested best practices with rationale to support decision making
Note: The Patron Files - Mandatory and Non-Mandatory Fields - Backgrounder page is also considered recommended reading for additional user data information including use cases, mandatory fields and helpful links.
Note: Elements in table below have been harvested from Patron worksheet in Symphony_Field_Mapping.xlsx and could differ slightly with other ILS migrations.
Some elements from the form have not been included if no recommendations exist.
Element | Migration Form Translation | Considerations for SIS Integrations | Recommendations with Rationale |
|---|---|---|---|
Patron Data | |||
USER_ID Also referred to as *Information repeated under identifiers header. | Used for mapping existing loans, bookings, holds, reserves, fines, fees, and blocks in current system to patron data in Alma. | Not used beyond migration. | Map to the barcode information in your existing ILS. This field will be a unique identifier and is typically consistent across all user types. Barcode is also a common method used in libraries to complete circulation transactions therefore, is is reliable for linking patron data with circulation data. |
USER_TITLE | User’s title in current ILS, SIS and HRIS systems. Mr, Ms, Dr for example. | Some colleges have EDI policies that advise the removal of gendered language unless necessary. Your library may choose to include or exclude this data in future SIS loads based on internal business needs. | If your library is reviewing whether to remove gender identifying data in the future, you may choose not to migrate this field with your existing data. The same considerations can be made for patron gender information. |
USER_PRIV_EXPIRES | Privilege expiry date in existing ILS. | Colleges can determine expiry dates and purge dates within Alma. Expiry dates can be unique for to each library based on internal business needs. | While expiry dates can be determined at the institutions, standardized purge policies may be suggested to the Steering Committee to ensure patron database limit compliance. |
INTERNAL_EXTERNAL | Used for mapping users during migration. Map users that are delivered in current SIS loads to EXTERNAL. Map users that are created manually in the current ILS to INTERNAL. | Users created within Alma are considered internal because they are created and managed within Alma. Users created and updated using the SIS load are considered external because account management exists outside of Alma. | N/A |
Identifiers | |||
USER_ID Also referred to as | Used for mapping existing loans, bookings, holds, reserves, fines, fees, and blocks in current system to patron data in Alma. | Not used beyond migration. | Map to the barcode information in your existing ILS. This field will be a unique identifier and is typically consistent across all user types. Barcode is also a common method used in libraries to complete circulation transactions therefore, is is reliable for linking patron data with circulation data. |
UNIV_ID BAR ADDL_ID_1 ADDL_ID_2 ADDL_ID_3 | Map any existing identifiers in current ILS to the UNIV_ID or barcode field.
| Alma requires the following for each patron record. Primary ID - must be unique to each user SIS match - must exist within SIS Authentication match - must exist within SSO If these values are the same, your library may only need a single identifier. If they are not the same, you can have up to 4 additional identifiers. Eg, if your college uses the student email as the SSO identity, the SIS match, is unique for each user and is represented by a barcode on your student card, no other identifiers are needed. | The identifiers can be locally configured at each institution. The network zone uses linked accounts to perform fulfillment activities within the network zone. This eliminates the need for standardization across the network. As long as each value exists within the record, it does not matter which field they occupy. It only matters that you identify which will be the Primary ID. |
Statistical Categories | |||
USER_STAT_CATEGORY | If colleges are receiving this data currently, it exists in the “User Cat” fields in Symphony and elsewhere in other ILS systems. This data will be migrated to the USER_STAT_CATEGORY fields in Alma. | If you do not currently receive this information, your college may want to discuss which fields are relevant for statistical reporting when configuring the SIS integration. There are 10 available fields for user statistical data. | Many colleges already receive statistical data in their SIS load or through other methods. For data that is common across the network standardization is recommended. Shared field names will support consistent reporting of statistical data. Some colleges may not receive all fields listed below. For data that is present, the following field names are recommended: PROGRAM - Student’s current program affiliation. FACULTY - Faculty or school responsible for delivering programs to students (eg Liberal Arts and Science or Business). DEPARTMENT - Staff or faculty department affiliation. What other fields might be used by colleges? |
Additional Elements | |||
PREFERRED_EMAIL | Email is one of the mandatory fields within the patron account. | If email is also used for SSO or SIS integrations, Ex Libris can configure systems so that email does not need to be duplicated. | |
First Name | Core information | Mandatory | |
Last Name | Core information | Mandatory |