System Events

This subject area replaces the former Events subject area, which reported on a very large number of events, some of them redundant or not used. This made it very difficult to produce effective reports on events that run in a reasonable amount of time. The current System Events subject area includes only a select number of events, so that reports can be run quickly and efficiently.

The events in the System Events subject area has been collected from a list that includes:

• Event that are used in reports that the institution created and ran at least once in the past year.
• Events in out-of-the-box reports under Alma/shared/events/reports
• Events related to the creation, deletion, and update of invoice lines and invoices

For a list of the events available in the System Events subject area, see List of Events in the Alma Analytics System Events Subject Area.

Field Descriptions

The following lists the fields available in System Events:

Event Measures

The Event Measures table is a fact table that stores the number and duration of events.

Event Measures

Field	Description	Additional Information
Number of Events	Stores the calculated fields that count all the unique events (by distinct event ID). Each event can have several entries in the table with different keys and values.

Event Details

The Event Details table is a dimension table that stores additional details about the event.

Event Details

Field	Description	Additional Information
Event Category	Stores the category of the event
Event Creator	Stores the creator of the event	To have this field anonymized, contact Ex Libris support
Event Description	Stores the description of the event with parameters
Event ID	Stores the unique ID of the event
Event Key Name	Stores the key name – a category of event, such as Account Type and Action
Event Key Value	Stores the key value – a member of the key name such as Public and Staff	To have this field anonymized, contact Ex Libris support
Event Message	Stores the message with fillers for the parameters
Event Module	Stores the module of the event
Event Purge Policy	Stores the purge policy of the event
Event Severity	Stores the severity of the event
Event Sub Module	Stores the sub module of the event
Event Type	The number of the event	For more information on event types, see the List of Events in the Alma Analytics System Events Subject Area.
Session ID	Stores the session ID

Event Date

The Event Date table is a dimension table that stores details about the date of the event such a month, year, and quarter. Key fields may be used when calculations are required. Descriptions fields may be used for formatting the display of the report.

Using this dimension, users may drill down from year to month to the specific event. The number of events are accumulated to the relevant level in the hierarchy.

Event Date

Field	Description	Additional Information
Event Date and Time	The date and time of the event
Date Key	Stores the date in the format 2/29/2012
Start of Week	The date of the first business day of the week
Week Number	The number of the week of the year
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 month
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 month
Month Desc	Stores the month of the date in month description format such as February
Year Key	Stores the year of the date in string format such as 2012
Fiscal Year Key	Stores the fiscal year of the date in string format such as 2012
Year Desc	Stores the year of the date in string format such as 2012.
Full Month Desc	Stores the month and the year of the date in a display format such as Feb 12
Full Month Key	Stores the month in a number format such as 9 for September and the year
Full Quarter Desc	Stores the quarter of the date in a display format such as Q1 and the year
Full Quarter Key	Stores the quarter of the date in a display format such as 1 and the year
Quarter Desc	Stores the quarter of the date in a display format such as Q1
Quarter Key	Stores the quarter of the date in a display format such as 1
Date Filter	Used to filter report results by date.
Event Date	Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific event date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy.

Event Library Unit

The Event Library Unit is a dimension table that displays information about the library that in which the event occurred.

Security Events

The Security Events table is a dimension table that stores details of security events generated by Alma. This table stores events associated with CATEGORY=SECURITY and MODULE=USER_MANAGEMENT. Using this dimension, a user may create the FERPA (Family Educational Rights and Privacy Act) reports that indicates which users in Alma may view details of other users. Use of fields from this folder restricts the report to information related only to the security category. Even if other event types are present in the data, they do not appear in the report.

Security Events

Field	Description	Additional Information
Accessing User ID	Stores the user ID of the user that accessed other user information	To have this field anonymized, contact Ex Libris support
User ID	Stores the user ID of the user whose details have been seen	To have this field anonymized, contact Ex Libris support
User Accessing Operations	Indicates when the Viewed operation was used to access the information
User Subentity List Name	Describes the entity that has been seen such as address, email, and so forth.

Institution

Shared Dimensions with Other Subject Areas

None.

Page tags: article:topicproduct:almacontent:Documentationlang:english