Voyager to Alma Migration Query: Review of System Administration Item Type Policy Components

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.

Query:

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.