Page History

Update as of 4-13-26:

The problem of multiple srs_ids in the marc__t table, discovered in November 2025, remains unresolved. We are working with Index data and our hosting team from EBSCO to resolve the issue. We have a new workaround in place that allows you to use records on the marc__t table in your queries more easily. We have created a derived table with multiple records removed that you can use in your Metadb reporting database queries. 

Instead of using the folio_source_record.marc_ _ t table, you can point to the new derived table created daily to get your data from the MARC records in Metadb: local_derived.marc_ _ t

Update of 1-28-26:

The problem of multiple srs_ids in the marc__t table, discovered in November 2025, remains unresolved. The number of problem records is now over 282,000 instances. The workaround solutions described previously on this page for how to get the correct record from the marc__t table are no longer accurate. The following (new) method can be used in queries to select the correct record from the marc__t table:

...

• Note that you must find the MAX row number from the records_lb table, and join the records_lb table to the marc__t table on marc__t.srs_id = records_lb.matched_id. This is a different join than the one described below this section.previously
• It is not necessary to specify state = 'ACTUAL' in the Where section of the query, since that condition no longer limits the results to the correct record (an instance can have multiple srs_id's that are all "ACTUAL")

SELECT

              sm.instance_hrid,

              sm.content AS lc_classification,

              SUBSTRING (sm.content,'[A-Za-z]{0,}') as lc_class,

              TRIM (TRAILING '.' from SUBSTRING (sm.content, '\d{1,}\.{0,}\d{0,}')) AS lc_class_number,

              MAX (records_lb.__id)

       FROM folio_source_record.marc__t AS sm

       INNER JOIN folio_source_record.records_lb 

              ON sm.srs_id = records_lb.matched_id

        WHERE sm.field = '050'

              AND sm.sf = 'a'

              AND sm.ord = 1 

       GROUP BY sm.instance_hrid, sm.content

------------------------------------------------------------------------------------------------------------------------------------

...