Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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.

    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.