Voyager to Alma Migration Query: Bibliographic Records with an invalid Record Status in the MARC Leader

When migrating from Voyager to Alma, it may be desirable to identify 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.
 
If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.