Voyager to Alma Migration Query: Identify Patrons who have Patron Statistical Category Codes
- Product: Voyager
- Relevant for Installation Type: Multi-Tenant Direct, Dedicated-Direct, Local, TotalCare
Description
When migrating from Voyager to Alma it may be helpful to identify those patrons in your Voyager database who have statistical category codes associated with their patron record.
The following query, which can be run using Voyager Access Reports, provides a list of PATRON_ID codes for patron records that have one or more (the count is included) patron statistical codes.
Note that for cleanup purposes, in order to DELETE a Statistical Category Code, it must not be used in any patron records.
SELECT PATRON_STATS.PATRON_ID, Count(PATRON_STATS.PATRON_ID) AS CountOfPATRON_ID
FROM PATRON_STATS
GROUP BY PATRON_STATS.PATRON_ID
HAVING (((Count(PATRON_STATS.PATRON_
ORDER BY PATRON_STATS.PATRON_ID;
Related Knowledge Center article:
https://knowledge.exlibrisgroup.com/Voyager/Knowledge_Articles/Can_use_Voyager_patron_XML_utilities_to_batch_update_or_delete_patron_statistical_codes
For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.
See also this pass through query.
- Article last edited: 29-Jan-2022