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
WHERE (((DEPARTMENT.DEPARTMENT_CODE) Is Not Null))
GROUP BY DEPARTMENT.DEPARTMENT_CODE
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.