Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

MARC _ _ t table issue: Multiple srs IDs associated with same instance ID

In the Metadb reporting database, the folio_source_record.marc__t table , each instance_ID should have a unique srs_id associated with it in the Metadb reporting databaseeach instance ID. However, in early November 2025, the Reporting Team noticed noticed that, for some records, there were that there duplicates of the multiple srs_id ids associated with each instance_HRID in the folio_source_record.. The multiples were older versions of the marc record, which normally would not appear in the marc__t table. The marc__t table should include only records where the state field of the record is 'ACTUAL,' but it is including records where the state field is 'OLD.' So we are getting duplicate counts of the same record in cases where the record has been updated. This issue came up before with LDP software and was addressed. There is code to address this issue for the Metadb software, but it is not clear that it is working correctly. The Reporting Team is working with Index Data to address this problem. 

...