Skip to main content
ExLibris
  • Subscribe by RSS
    • Back
    Voyager
    Ex Libris Knowledge Center

    Voyager to Alma Migration Query: Identify Patrons who have Patron Statistical Category Codes

    1. Last updated
    2. Save as PDF
    • 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_ID))>0))

    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