Skip to main content
ExLibris

Knowledge Assistant

BETA
 
  • Subscribe by RSS
  • Back
    Voyager

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Voyager
    3. Community Knowledge
    4. Voyager to Alma Migration Query: Identify Patrons who have Patron Statistical Category Codes

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

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Description
    • 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
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Voyager to Alma Migration Query: Identify Patrons by Barcode Status
      • Voyager to Alma Migration Query: Identify patrons with "non-active" patron barcodes (lost, expired, etc.)
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Community Content Type
      How To
      Content Type
      Knowledge Article
      Language
      English
      Product
      Voyager
    2. Tags
      This page has no tags.
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved