*** This version of Confluence is for testing only and contains a copy of content from June 29th 2026. No changes will be preserved. ***
-
Created by
Sharon Helen Markus, last updated on Feb 11, 2025
2 minute read
Here are a series of data checks between the LDP and Metadb to verify the accuracy of Metadb data after the February 7-9 software updates
| Date | Test | LDP Results | Metadb Results | Notes | Tester |
|---|---|---|---|---|---|
| 2/10/25 | instance_hrid rows created in the MARC table | 706907713 srs_marctab | 706873319 folio_source_record.marc__t | Natalya | |
| 2/11/25 | instance_hrid rows created in the MARC table | 706928287 srs_marctab | 706930661 marc__t | the difference is larger than expected for number of lines per records added; 2374 lines for 12 records | Natalya |
| 2/11/25 | instances, holdings, loans, items | 11057210 instances 11887996 holdings 787110 loans 9830540 items | 11057224 instances 11887999 holdings 787291 loans 9830547 items | metadb counts slightly higher | Sharon |
| 2/11/25 | marc records | 22511684 srs_marc ids 706928287 srs_marc_tab instances 11002043 srs_marc_tab 001 11002043 srs_marc_tab 999i 11002043 srs_records instances | 22513379 srs_marc ids 706930661 srs_marc_tab instances 11002068 srs_marc_tab 001 11002068 srs_marc_tab 999i 11002052 srs_records instances | metadb counts slightly higher | |
| 2/10/25 | Count of pol_ids from primary tables, 1-15-25 through 2-9-25 LDP: po-lines Metadb: folio_orders.po_line | 1,387 | 1,387 | Joanne | |
| 2/10/25 | Count of item_ids from primary tables, 1-15-25 through 2-9-25. LDP: inventory_items Metadb: folio_inventory.item | 8,953 | 8,927 | LDP count is higher. Maybe items were deleted today that had previously been created before today? | Joanne |
| 2/10/25 | Count of loan_ids from primary tables 1-15-25 through 2-9-25 LDP: circulation_loans Metadb: folio_circulation.loan | 21,725 | 21,693 with "date"; 21,727 with "timestamptz" | Total of loan_ids change for Metadb when casting the date as "timestamptz." Date types don't make a difference in the totals for LDP. | Joanne |
| 2/10/25 | Count of holdings_ids from derived tables, created 1-15-25 through 2-9-25 LDP: folio_reporting.holdings_ext metadb: folio_derived.holdings_ext | 14,206 | 12,565 | LDP greater. Metadb is missing counts for 2-4-25 through 2-9-25 inclusive in the sample date range; there may be other gaps | Joanne |
| 2/10/25 | Count of holdings_id from primary tables, 1-15-25 through 2-9-25 LDP: inventory_holdings Metadb: folio_inventory.holdings_record | 14,206 | 14,206 | They match in the primary tables, with date fields cast as "date" | Joanne |