Voyager to Alma Migration Query: Review of System Administration Item Type Policy Components
Created By: Laura Guy (contact)
Created on: 9/29/2020
When migrating from Voyager to Alma, it may be useful to review System Administration policies by item type. This query lists all the Item Type Policy components of System Administration.
The following query, which can be run using Voyager's Prepackaged Access Reports, provides a record of what the Item Type system settings are.
SELECT CIRC_POLICY_GROUP.CIRC_GROUP_NAME, ITEM_TYPE.ITEM_TYPE_NAME, CCur(Sum([Replace_Cost]/100)) AS [Replace-Cost], ITEM_TYPE_POLICY.ORDER_QUANTITY_NUMBER, ITEM_TYPE_POLICY.REORDER_POINT, ITEM_TYPE_POLICY.SHORT_LOAN FROM (ITEM_TYPE_POLICY INNER JOIN ITEM_TYPE ON ITEM_TYPE_POLICY.ITEM_TYPE_ID = ITEM_TYPE.ITEM_TYPE_ID) INNER JOIN CIRC_POLICY_GROUP ON ITEM_TYPE_POLICY.CIRC_GROUP_ID = CIRC_POLICY_GROUP.CIRC_GROUP_ID GROUP BY CIRC_POLICY_GROUP.CIRC_GROUP_NAME, ITEM_TYPE.ITEM_TYPE_NAME, ITEM_TYPE_POLICY.ORDER_QUANTITY_NUMBER, ITEM_TYPE_POLICY.REORDER_POINT, ITEM_TYPE_POLICY.SHORT_LOAN;
For other queries that may be useful, see my "Surviving Almanado: tips for a successful pre-implementation" presentation's Accompanying Materials.
Posted as is. If you need assistance in running custom SQL queries in Prepackaged Access Reports, consult the Voyager Customer Listserv.