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

    Voyager to Alma Migration Query: Identify Department Codes that are Duplicates

    Created By: Laura Guy (contact)
    Created on: 10/12/2020



    When migrating from Voyager to Alma, you may need to identify and resolve any duplicate (non-unique) Department Codes. See the Voyager To Alma Migration Guide for additional help on how non-unique Department Codes are migrated.

    This query, which you can run using Voyager Prepackaged Access Reports, can help you identify duplicate Department Codes.

    SELECT DEPARTMENT.DEPARTMENT_CODE, Count(DEPARTMENT.DEPARTMENT_ID) AS CountOfDEPARTMENT_ID
    FROM DEPARTMENT
    WHERE (((DEPARTMENT.DEPARTMENT_CODE) Is Not Null))
    GROUP BY DEPARTMENT.DEPARTMENT_CODE
    HAVING (((Count(DEPARTMENT.DEPARTMENT_ID))>1));

     

    For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.

    If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.