srs_marctab record version

Notes:

-provide instructions for using ACTUAL

-we don't know when this issue started, but we found it in early November 2025

-this issue came up and was fixed for LDP, but not later for Metadb

-we are not sure what is causing the problem

-there may be a solution, but we do not know how often it runs 

-https://github.com/metadb-project/metadb/blob/c7ee129f52fab3e73966fd77c99b92eff5a3bb40/cmd/internal/libmarct/marc/marc.go#L30

-is this code above running often enough to clean up the data? Does it clean up the data?

-considering doing a test during first week of December

https://github.com/metadb-project/metadb/issues/92

There are multiple versions of records in the srs_marctab table in the CUL LDP. The correct version is called ACTUAL. Here is an example of how you might specify getting the ACTUAL version.

language_extract AS (

SELECT

     sm.instance_id AS instance_id,

     substring(sm.content, 36,3) AS LANGUAGE,

     sr.state,

     sr.id

FROM srs_marctab AS sm

LEFT JOIN srs_records AS sr on sr.id = sm.srs_id

WHERE

     sm.field = '008'

AND sr.state = 'ACTUAL'