Voyager to Alma Migration Query: MFHD Records that are Suppressed but which have Items Attached
When you migrate from Voyager to Alma, you may want to identify and review MFHD records that are suppressed, but which have items attached. You may want to evaluate whether or not the suppress condition is correct.
This query, which can be run via Voyager Prepackaged Access Reports, will identify MFHD records that are suppressed, and which have items attached. Note that because this query's output includes Item Status information, some item records will be included multiple times (once for each Item Status).
SELECT DISTINCT MFHD_MASTER.MFHD_ID, MFHD_ITEM.ITEM_ID,
ITEM_STATUS_TYPE.ITEM_STATUS_DESC, ITEM.CREATE_DATE,
LOCATION.LOCATION_NAME,
utf8to16([mfhd_master].[DISPLAY_CALL_NO]) AS Display_Call_No,
MFHD_ITEM.ITEM_ENUM,
MFHD_ITEM.CHRON, ITEM.COPY_NUMBER,
ITEM_BARCODE.ITEM_BARCODE
FROM ITEM_STATUS_TYPE INNER JOIN (((((MFHD_MASTER
INNER JOIN MFHD_ITEM ON MFHD_MASTER.MFHD_ID = MFHD_ITEM.MFHD_ID)
INNER JOIN LOCATION ON MFHD_MASTER.LOCATION_ID = LOCATION.LOCATION_ID)
INNER JOIN ITEM ON MFHD_ITEM.ITEM_ID = ITEM.ITEM_ID)
INNER JOIN ITEM_STATUS ON ITEM.ITEM_ID = ITEM_STATUS.ITEM_ID)
LEFT JOIN ITEM_BARCODE ON ITEM.ITEM_ID = ITEM_BARCODE.ITEM_ID)
ON ITEM_STATUS_TYPE.ITEM_STATUS_TYPE = ITEM_STATUS.ITEM_STATUS
WHERE ((MFHD_MASTER.SUPPRESS_IN_OPAC)="Y")
ORDER BY ITEM_STATUS_TYPE.ITEM_STATUS_DESC;
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.