When migrating from Voyager to Alma, it may be desirable to identify and review those bibliographic records that have an invalid MARC Record Leader record status (LDR/05).  You may want to clean up any invalid codes.

This query, which can be run using Voyager Prepackaged Access Reports, will find bibliographic records with a records status code other than a, c, d, n, or p.

SELECT BIB_TEXT.BIB_ID, BIB_TEXT.RECORD_STATUS,
BIB_TEXT.TITLE_BRIEF,
BIB_TEXT.EDITION, BIB_TEXT.IMPRINT,
BIB_TEXT.NETWORK_NUMBER, BIB_MASTER.SUPPRESS_IN_OPAC
FROM BIB_TEXT INNER JOIN BIB_MASTER
ON BIB_TEXT.BIB_ID = BIB_MASTER.BIB_ID
WHERE (((BIB_TEXT.RECORD_STATUS) Not Like "a"
And (BIB_TEXT.RECORD_STATUS) Not Like "c"
And (BIB_TEXT.RECORD_STATUS) Not Like "d"
And (BIB_TEXT.RECORD_STATUS) Not Like "n"
And (BIB_TEXT.RECORD_STATUS) Not Like "p"));

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.