Skip to main content
ExLibris
  • Subscribe by RSS
  • ExLibris Dev

    Licenses

    Using the Licenses subject area, you can create reports/dashboards relating to licenses and answer the following types of business questions:
    • What is the number of portfolios and collections per license?
    • What are the total expenditures for PO lines with specific licenses for specific fiscal years?
    Star Diagram – Licenses

    Field Descriptions

    The following fields are available in Licenses.
    Licenses – Field Descriptions
    For information on how to create an analytics report that shows the obligation note for the license, see Displaying the Obligations Note for Licenses.

    License Measures

    The License Measures table is a fact table that stores all measures relating to licenses, such as number of licenses and number of license terms.
    License Measures
    Field Description Additional Information
    Number of Licenses The number of licenses  
    Number of License Terms The number of license terms This number includes both local and out-of-the-box terms.

    License Header

    The License Header table is a dimension table that stores information about the license such as the license ID, the license name, and the license creator.
    License Header
    Field Description Additional Information
    License ID The ID of the license  
    License Code The code of the license  
    New for May!
    License Creator
    The creator of the license  
    New for May!
    License Modified By
    The user who modified the license  
    License Name The name of the license  
    License Begins The date the license begins  
    License Ends The date the license ends  
    License Note The note of the license  
    License Originating Licensor Key The licensor key of the license  
    License Originating Parent Code The originating parent code of the license  
    License Parent ID The parent ID of the license  
    License Review Status The renewal status of the license  
    License Signed By The user who signed the license  
    License Signed On The date the license was signed on  
    License Second Party Signed By The second party who signed on the license  
    License Second Party Signed On The date the second party signed on the license  
    License Status The status of the license  
    License Storage Location The storage location of the license  
    License Type The type of the license  
    License URI The URI of the license  

    License Terms

    The License Terms table is a dimension table that stores information about the license terms such as the license term section, the license term create date, and the license term modification date.
    License Terms
    Field Description Additional Information
    License Term The term of the license  
    License Term Section The term section of the license  
    License Term Create Date The create date of the license term  
    License Term Modification Date The modification dateof the license term  
    License Term Value The value of the license term  

    License Vendor

    The License Vendor table is a dimension table that stores information about the license vendor such as the Vendor code and the Vendor name.
    License Vendor
    Field Description Additional Information
    Vendor Code The vendor code  
    Vendor Name The vendor name  
    Additional Code The additional code  
    ERP Code The ERP code  

    License Agent

    The License Agent table is a dimension table that stores information about the license agent such as the agent code and agent name.
    License Agent
    Field Description Additional Information
    Agent Code The agent code  
    Agent Name The agent name  
    Additional Code The additional code  
    ERP Code The ERP code  

    License Library Unit

    The License Library Unit table is a dimension table that stores information about the license library unit such as the Library Code and Library Description.
    Library Unit
    Field Description Additional Information
    Library Code Stores the library code  
    Library Description Stores the library description  
    Library Name Stores the library name  
    Unit Type Store the type of organization unit Values can be Institution/Library

    License Creation Date

    The License Creation Date table is a dimension table that stores details about the license creation date. Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:
    • Calendar Fields – These are date fields as they display in the calendar.
    • Fiscal Date Fields – These are date fields that match the institution's fiscal period. In the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.
    Using this dimension, the user may drill down from year to month to the specific date on which the license was created. The number of the license is accumulated to the relevant level in the hierarchy.
    License Creation Date
    Field Description Additional Information
    License Creation Date Stores the license creation date in a date format such as 2/29/2014.  
    License Creation Month Key Stores the month of the date in number format such as 2 for February This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
    License Creation Month Stores the month of the date in month description format such as February  
    License Creation Full Month Stores the month and the year of the date in a display format such as Feb 12 This field is useful when comparing data on a month basis between years.
    License Creation Quarter Stores the quarter of the date in a display format such as Q1  
    License Creation Year Stores the year of the date in number format such as 2012  
    License Creation Fiscal Month Key Stores the fiscal month of the date in number format such as 2 for February This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
    License Creation Fiscal Year Stores the fiscal year of the date in a string format such as 2012. If the fiscal year description is stored in the institution fiscal period configuration table. This value is taken from there.

    License Modification Date

    The Modification Date table is a dimension table that stores details about modification of licenses.
    The License Modification date is the date of the last change to the title.
    Key fields are used whenever calculations are required. Description fields may be used for formatting the display of the report. Alma stores the following types of fields:
    • Calendar Fields – These are date fields as they display in the calendar.
    • Fiscal Date Fields – These are date fields that match the institution's fiscal period. For the examples below, the fiscal period of the institution is for fiscal year 2012 that starts June 1, 2011 and ends May 31, 2012.
    Using this dimension, the user can drill down from year to month to the specific date on which the license was created.
    License Modification Date
    Field Description Additional Information
    License Modification Date Stores the item modification date in a date format such as 2/29/2014.  
    License Modification Month Key Stores the month of the date in number format such as 2 for February This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
    License Modification Month Stores the month of the date in month description format such as February  
    License Modification Full Month Stores the month and the year of the date in a display format such as Feb 12 This field is useful when comparing data on a month basis between years.
    License Modification Quarter Stores the quarter of the date in a display format such as Q1  
    License Modification Year Stores the year of the date in number format such as 2012  
    License Modification Fiscal Month Key Stores the fiscal month of the date in number format such as 2 for February This field is useful when you want to sort by the month, which does not work properly when using the alphabetical field.
    License Modification Fiscal Year Stores the fiscal year of the date in a string format such as 2012. If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.

    License Negotiation (Network Inst.)

    The License Negotiation table is a dimension table that stores information about the license negotiation such as the License Negotiation Member and License negotiation Start Date.
    License Negotiation (Network Inst.)
    Field Description Additional Information
    License Negotiation Contact Email The license negotiation contact email  
    License Negotiation Currency The license negotiation currency  
    License Negotiation End Date The license negotiation end date  
    License Negotiation ID The llicense negotiation ID  
    License Negotiation Member The license negotiation member  
    License Negotiation Price The license negotiation price  
    License Negotiation Renewal Cycle The license negotiation renewal cycle  
    License Negotiation Start Date The license negotiation start date  

    Institution

    The shared Institution dimension allows the network institution to view reports according to institution. It is available in every subject area. It contains the following fields:
    Institution
    Field Description Additional information
    Institution Code The code of the institution.  
    Institution Name The name of the institution.  
    If an analytics report is run from a member institution in a collaborative network implementing a Network Zone, all member institutions are included in the report for Institution Code and Institution Name.
    If an analytics report is run from an institution that is not part of a collaborative network implementing a Network Zone, only the single institution from which the report is run is included in the report for Institution Code and Institution Name.
    Reports involving data across a collaborative network implementing a Network Zone may take longer to run than reports within one institution.

    • Was this article helpful?