Licenses

Create reports/dashboards relating to 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 per license?
  • What is the number of electronic collections per license?
  • What are the total expenditures for PO lines with specific licenses for specific fiscal years?
    For more information, see Licenses. (3:43 min)

license_star_diagram.png

Star Diagram – Licenses

Field Descriptions

The following fields are available in Licenses.

license_field_descrptions.png

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  
License Creator The creator of the license  
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 review 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 Possible values:
  • Active – The license is activated and in use
  • Inactive  – Mark the license is Inactive. Inactive licenses can be re-activated by selecting Edit in the row actions list and changing the license status value. Relevant only when updating an existing license.
  • Draft – The license is created but not in use
  • Expired – License "End date" is in the past (can be extended)
  • Retired – The license is no longer relevant
License Storage Location The storage location of the license  
License Type The type of the license  
License URI The URI of the license  
Tokens Total Indicates if the transformative agreement has a limited or unlimited number of articles that can be published in a year  
Unlimited The number of articles that can be published in the agreement period  

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 creation date, and the license term modification date.

License Terms
Field Description Additional Information
License Term The license term  
License Term Section The license term section  
License Term Creation Date The creation date of the license term  
License Term Modification Date The modification date of 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.

A content reuse widget was here but the content was missing. The reused content is Media_Repository/Alma/Analytics_Reused_Content/Vendor

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  
Vendor Status The status of the vendor Possible values:
  • Active
  • Inactive
  • Deleted

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.

A content reuse widget was here but the content was missing. The reused content is Media_Repository/Alma/Analytics_Reused_Content/Library_Unit

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 Data Type Data Size
License Creation Date The creation date of the license. The date in the format DD/MM/YYYY DATE  
License Creation Start of Week The date of the first business day of the week. The date in the format DD/MM/YYYY DATE  
License Creation Week Number The number of the week of the year. There are 52 weeks in a year. VARCHAR 2
License Creation Month Key The month of the date in number format. E.g. February shows the number 2 in this column. This field is useful when you want to sort by month. INT  
License Creation Month The month of the date in text format. The month, e.g. February VARCHAR 20
License Creation Full Month The year and month that the license was modified. The month in text format and the year. E.g. Feb 25 (for February 2025) VARCHAR 20
License Creation Quarter The quarter in the year in which the license was modified. The quarter of the date in a display format such as Q1 VARCHAR 20
License Creation Year The year in which the license was modified. The year of the date in the format YYYY . E.g. 2025 VARCHAR 20
License Creation Fiscal Month Key The fiscal month of the date in number format. E.g. If the fiscal year starts in June, this column shows the number 1 for June, the number 2 for July, and so on. INT  
License Creation Fiscal Year The fiscal year of the date in string format. The year is presented according to the description in the mapping table Fund and Ledger Fiscal Period.  For more information, see Configuring Fund and Ledger Fiscal Periods. VARCHAR 50
License Creation Date Filter Used to filter report results by date.

Possible values:

  • Current Academic Year
  • Current Fiscal Year
  • Current Month
  • Current Year
  • Last 3 Months
  • Last 30 Days
  • Last 365 Days
  • Last 7 Days
  • Older than 30 Days
  • Older than 60 Days
  • Older than 7 Days
  • Older than 90 Days
  • Previous Complete 12 Months
  • Previous Complete 24 Months
  • Previous Complete Two Years
  • Previous Fiscal Year
  • Previous Month
  • Previous Year
  • Two Fiscal Years Ago
  • Two Years Ago
 VARCHAR 100
License Creation Year-Month The year and the month in which the license was modified. Stores the year and the month in a display format such as  2023-1 VARCHAR 250

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 Data Type Data Size
License Modification Date The creation date of the license. The date in the format DD/MM/YYYY DATE  
License Modification Start of Week The date of the first business day of the week. The date in the format DD/MM/YYYY DATE  
License Modification Week Number The number of the week of the year. There are 52 weeks in a year. VARCHAR 2
License Modification Month Key The month of the date in number format. E.g. February shows the number 2 in this column. This field is useful when you want to sort by month. INT  
License Modification Month The month of the date in text format. The month, e.g. February VARCHAR 20
License Modification Full Month The year and month that the license was modified. The month in text format and the year. E.g. Feb 25 (for February 2025) VARCHAR 20
License Modification Quarter The quarter in the year in which the license was modified. The quarter of the date in a display format such as Q1 VARCHAR 20
License Modification Year The year in which the license was modified. The year of the date in the format YYYY . E.g. 2025 VARCHAR 20
License Modification Fiscal Month Key The fiscal month of the date in number format. E.g. If the fiscal year starts in June, this column shows the number 1 for June, the number 2 for July, and so on. INT  
License Modification Fiscal Year The fiscal year of the date in string format. The year is presented according to the description in the mapping table Fund and Ledger Fiscal Period.  For more information, see Configuring Fund and Ledger Fiscal Periods. VARCHAR 50
License Creation Date Filter Used to filter report results by date.

Possible values:

  • Current Academic Year
  • Current Fiscal Year
  • Current Month
  • Current Year
  • Last 3 Months
  • Last 30 Days
  • Last 365 Days
  • Last 7 Days
  • Older than 30 Days
  • Older than 60 Days
  • Older than 7 Days
  • Older than 90 Days
  • Previous Complete 12 Months
  • Previous Complete 24 Months
  • Previous Complete Two Years
  • Previous Fiscal Year
  • Previous Month
  • Previous Year
  • Two Fiscal Years Ago
  • Two Years Ago
 VARCHAR 100
License Creation Year-Month The year and the month in which the license was modified. Stores the year and the month in a display format such as  2023-1 VARCHAR 250

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  

Agreement Definitions

The Agreement Definitions table is a dimension table that stores information about agreements.

Agreement Definitions
Field Description Additional Information
Transformative Agreement Tokens Total The number of articles that can be published in the agreement period  
Transformative Agreement Unlimited Indicates if the transformative agreement has a limited or unlimited number of articles that can be published in a year  

Institution

A content reuse widget was here but the content was missing. The reused content is Media_Repository/Alma/Analytics_Reused_Content/Institution