Voyager to Alma Migration Query: MFHD 852 Lacks First Indicator
When migrating from Voyager to Alma, you may want to identify, review and fix any MFHD 852 fields that are missing the first indicator value. In this situation indexing may be incorrect, and the Call Number not easily searchable.
This query, which can be run using Voyager's Prepackaged Access Reports, will display the MFHD IDs of holdings records that have a blank first indicator value in the 852:
SELECT MFHD_MASTER.MFHD_ID, LOCATION.LOCATION_CODE,
MFHD_MASTER.CALL_NO_TYPE, MFHD_MASTER.CREATE_DATE FROM MFHD_MASTER INNER
JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID WHERE
(((MFHD_MASTER.NORMALIZED_CALL_NO) Is Null) AND
((MFHD_MASTER.DISPLAY_CALL_NO) Is Not Null));
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.