Legacy charges (migrated from Sierra)

Polaris
1

Hi all,

Is there a way to find all the Sierra Legacy charges that migrated over? If patrons had charges on their accounts in Sierra, but the item had been deleted from Sierra when we migrated to Polaris the title of the item on the charge in Polaris just says [LEGACY} and gives the Sierra record number. We still have access to our Sierra so when I look up those patrons I can see what the title was.

Thanks.

2

There are usually CNV tables in your Polaris SQL database that you can see the “raw” data from your old system in and then use those to join into your Polaris data tables.

The exact names change, but this should get you there:

USE Polaris;

SELECT 
    s.name AS schema_name,
    t.name AS table_name
FROM sys.tables t
JOIN sys.schemas s
    ON t.schema_id = s.schema_id
WHERE t.name LIKE '%cnv%'
ORDER BY s.name, t.name;
1 Like