Issue | Reported Date | Temporary/Workaround Solution | Solution Status and Date |
---|---|---|---|
In the public.srs_records table, the column external_id is actually the instance_id | None needed | Fixed | |
In the public.srs_marctab table, all ids are in uuid format, and this does not match the format of ids in other tables | Cast all ids from tables that connect to srs_marctab as "::uuid" Example code when joining srs_marctab AS sm to srs_records AS sr LEFT JOIN srs_marctab AS sm ON sr.id::uuid = sm.srs_id | None | |
In the public.srs_marctab table, the instance_id column is incorrect and should not be used. | The srs_marctab table can be connected to the public.inventory_instances table via hrid, and the instance_id can be brought in from the inventory_instances table. Example code: SELECT WHERE sm.field = '000' Another way to get data from the srs_marctab table and insert a correct instance_id is via the srs_records table. Example code: SELECT --NOTE that all ids in the srs_marctab table have been cast as uuids, so cast the OTHER table's id as ::uuid
| Fixed, the instance_id column from srs.marctab has been corrected as of 9/12/22. | |
public.audit_circulation_logs did not start recording loan renewals until December 17, 2021. |
| The circulation_loans table has a record of renewals (renewal count) starting 7/1/2021, but note that these are only for items checked out since 7/1/2021. | None |
public.notes table does not contain any data, and will impact any queries using this table | updated 10-17-22 | None | Upgrade 1.8 will solve this issue (update date to be determined). As of 10-17-22, LDP Test (1.8.2) shows the return of the Notes table. |
Invoice and fund tables migrated from Voyager show amounts of 100 times the actual amount | 10/17/22 | The data type for monetary amounts in Voyager finance tables was "Text," but when migrated to Folio was turned into "numeric." the decimals were stripped out – this means that when using Voyager historical data for funds and transaction amounts, divide your results by 100. | No fix foreseen |