Leganto Instructor Usage Events

Create reports/dashboards relating to Leganto instructor usage events.

Using the Leganto Instructor Usage Events subject area, you can create reports/dashboards relating to Leganto instructor usage events and answer the following type of business question:

  • What are the changes done in a reading list during a period of time?

leganto_instructor_usage_events

Star Diagram – Leganto Instructor Usage Events

Field Descriptions

The following fields are available in Leganto Instructor Usage Events.

leganto_instructor_usage_events_field_descrptions.png

Leganto Instructor Usage Events – Field Descriptions
Date fields can consist of a partial date, such as just the year or a month and year. Calendar Date fields always consist of a month, date, and year. If the information is not provided,01 is added, so that a date of 2020 is rendered 01/01/2020. This date format is useful when filtering the report by date.

Instructor Usage Events

The Instructor Usage Events table is a dimension table that stores details about instructor usage events.

Instructor Usage Events
Field Description Additional Information
Total Events Total number of events  
Active Instructors Number of active instructors  
Event Creator The creator of the event  
Event Date The date of the event  
Event Type The type of the event  
Event Value The value of the event The value of the event type
New UI Indicates if the usage was made in the new Leganto UI.  

The following table describes the possible values of the Event Type field:

Event Types and Values
Event Type Event Value
Create a Reading List The name of the reading list.
Associate to Course Associate – <the new course code> <the course section>
De-associate to Course De-associate – <the old course code> <the course section>
Change reading list publication The publication status. Possible values:
  • All Students Restricted
  • Course Students
  • Anyone Restricted
  • All Students Full
  • Anyone Full
  • Anyone Restricted, All Students Full
  • Draft
Add Section The section ID
Add Section Tag The tag value
Add Citation Tag The tag value
Delete Citation The citation ID
Remove Citation Tag The tag value
Delete Section The section ID
Remove Section Tag The tag value
Rollover reading list Old Course ID/New Course ID
Citation sent to Library The citation ID
Add Citation Public Note The text of the public note
Change Citation due date The new due date
Add Citation The citation ID
Create a Course from LTI  A course was created from a learning management system using Learning Tools Interoperability (LTI)
Instructor added annotation The text of the annotation
Instructor added workflow note The text of the workflow note
Instructor or course operator clicked on citeit and saved it The site URL where Cite It! was selected and saved
Instructor's comment to library - citation The text of the comment to the library
Instructor's comment to library - list The text of the comment to the library

Courses

The Courses table is a dimension table that stores details about the course, including the course name, the course year, and the course creator. The primary key of the table is COURSE_ID.

Currently, when reading lists can be associated with multiple courses, only the first course appears in Analytics. All courses associated with a reading list will appear in Analytics in an upcoming release (at which point all data, past and present, will appear).
Courses
Field Description Additional Information
Academic Department The academic department of the course  
Campus Name and Participants The campus name and the participants in the course  
Course Code The code of the course  
Course Creation Date The date that the course was created  
Course Created By The creator of the course  
Course End Date The end date of the course  
Course ID The ID of the course  
Course Instructor The name of the course instructor  
Course Instructor Preferred Email  The preferred email address of the course instructor  
Course Instructor With Primary Identifier The course instructor with the course instructor's primary identifier This field is useful when a course has more than one instructor. This field allows you to display the instructors together with their identifiers.
Course Instructor Identifier The primary identifier of the course instructor  
Course Modification Date The date that the course was modified  
Course Modified By The person who modified the course  
Course Name The name of the course  
Course Section The section of the course  
Course Start Date The start date of the course  
Course Status The status of the course  
Course Submit List By The date by which all reading lists for the course should be submitted  
Course Term The term of the course  
Course Visibility Indicates if the course is archived or unarchived  
Course Year The year of the course  
No list Expected Indicates if the No List Expected checkbox for the course is selected or not Possible values: Checked and Unchecked. You select this checkbox to alert the librarian that this course deliberately does not include a reading list. For more information on this checkbox, see Indicating that Courses Deliberately Have No Reading List.
Number of Citations The total number of citations  
Number of Participants The total number of participants in the course  
Processing Department The processing department of the course  
Processing Department Code The code of the processing department  
School-Faculty The school or faculty of the Academic Department in which the course was given  
Searchable ID 1-10 Searchable ID 1-3 of the course  
Weekly Hours The weekly hours of the course  

Reading Lists

The Reading Lists table is a dimension table that stores details relating to a reading list, including the reading list name, the reading list status, and the reading list creation date. The primary key of the table is READING_LIST_ID.

Reading Lists
Field Description Additional Information
Instructors and Collaborators IDs The IDs of the instructors and collaborators  
Number of Citations The total number of citations  
Number of Mobile Activities The total number of activities from mobile devices  
Number of Non-Mobile Activities The total number of activities from non-mobile devices  
Number of Suggestions The number of student suggestions for the reading list  
Publication List Visibility To whom the reading list is visible Possible values are:
  • Authenticated Students
  • Enrolled course’s students
  • Open to Everyone
  • Material Open to All Authenticate Students
  • Archived
Leganto First Sent for Library Review Date The date that the reading list was first sent for review  
Leganto Last Sent for Library Review Date The date that the reading list was last sent for review  
Publication Status The publication status of the reading list Possible values are:
  • Draft
  • Published
Reading List Associated to a Course Indicates if the reading list is associated to a course (yes/no)  
Reading List Code The code of the reading list  
Reading List Creation Date The date that the reading list was created  
Reading List Created By The creator of the reading list  
Reading List Deleted Indicates if the reading list was deleted  
Reading List Description The description of the reading list  
Reading List Due Back Date The due back date of the reading list  
Reading List ID The ID of the reading list  
Reading List Locked Indicates if the reading list is locked (yes/no)  
Reading List Modification Date The date that the reading list was modified  
Reading List Modified By The person who modified the reading list  
Reading List Name The name of the reading list  
Reading List Number of Loans The number of loans for the reading list If an item appears on the reading list multiple times, loans for that item are counted only once.
Reading List Owner The owner of the reading list  
Reading List Owner Preferred Email The preferred email of the reading list owner  
Reading List Reset Date The date the reading list was reset  
Reading List Status The status of the reading list  
Date Sent For Library Review The date that the reading list was sent for review  
Reading List Type The reading list type Possible values are Parent and blank (no value)
Reading List Visible Start Date The start date that the reading list is visible to students.  
Reading List Visible End Date The end date that the reading list is visible to students.  
Reading List Sticker Price The total price of the citations with sticker price  
Reading List Sticker Price (Covered by Library) The total sticker price of the citations that are covered by the library  
Review Requester Name The name of the review requester Last name, first name format
Review Requester Name and ID The name of the review requester with the requester's ID ID, last name, first name format
Review Requester Preferred Email The preferred email of the review requester  

Reading List Section

The Leganto Reading List Section table is a dimension table that stores details relating to a reading list, including Section Name, Section Order, and Section Creation Date.

Reading List Sections
Field Description Additional Information
Section Creation Date The creation date of the section  
Section Created By The creator of the section  
Section Description The description of the section  
Section End Date The end date of the section  
Section ID The ID of the section  
Section Library External Tags Code The code of the library external tags of the section Includes tags of type "Library-External"
Section Library External Tags Description The description of the library external tags of the section Includes tags of type "Library-External"
Section Library Internal Tags Code The code of the library internal tags of the section Includes tags of type "Library-Internal"
Section Library Internal Tags Description The description of the library internal tags of the section Includes tags of type "Librray-Internal"
Section Locked Indicates if the section is locked  
Section Modification Date The modification date of the section  
Section Modified By Who modified the section last  
Section Name The name of the section  
Section Number of Citations The number of citations for the section  
Section Order A number indicating the place of the citation in order  
Section Start Date The start date of the section  

Event Date

The Event Date is a dimension table that stores details about the event date.

Event Date
Field Description Additional Information
Date Key Stores the event date in a date format such as 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  
Month Desc Stores the month of the date in a display format such as February  
Full Month Key Stores the month and the year of the date in a display format such as 2/2017  
Full Month Desc Stores the month and the year of the date in a display format such as Feb 2017  
Full Quarter Key Stores the quarter of the date in a display format such as 1 and the year  
Full Quarter Desc Stores the quarter of the date in a display format such as Q1 and the year  
Quarter Key Stores the quarter of the date in a display format such as 1  
Quarter Desc Stores the quarter of the date in a display format such as Q1  
Year Key Stores the year of the date in a string format such as 2012.  
Year Desc Stores the year of the date in number format such as 2012  
Fiscal Month Key Stores the fiscal month of the date in number format such as 2 for February  
Fiscal Year Stores the fiscal year of the date in string format such as 2012.  
Date Filter Used to filter report results by date  
Year-Month The year and the month in a format such as 2023-1  

Citation Metadata Details

The Citation Metadata Details table is a dimension table that stores the citation metadata details of the course reserves.

Citation Metadata Details
Field Description Additional Information
Additional Person Name The additional person name  
Author The author of the article  
Barcode The barcode of the book  
Book Call Number The call number of the book  
Book Chapter Number The chapter number of the book  
Book Edition The edition of the book  
Citation ID The ID of the citation  
DOI The digital object identifier  
End Page The end page of the book  
End Page 2 An additional end page of the article  
ISBN The ISBN of the book  
ISSN The ISSN of the journal  
Issue The issue of the journal  
Journal Title The title of the journal  
Language The language of the citation  
MMS ID The MMS ID  
Number of Pages The number of pages in the article This field includes the number of pages between the Start Page and End Page fields and the Start Page 2 and End Page 2 fields
OCLC Number The OCLC number  
Pages The pages of the citation  
Publication Date The date of publication  
Publication Place The place of publication  
Publisher The publisher  
Start Page The start page of the article  
Start Page 2 An additional start page of the article  
Title The title of the citation  
Volume The volume of the citation  

Citations

The Reading List Citation table is a fact table that stores the measure relating to number of citations. This table also holds details about the citation, including citation creator, citation status, and citation type. The primary key of the table is CITATION ID.

Citations
Field Description Additional Information
Citation AlmaD Downloads The number of digital citation downloads during an active course  
Citation Attribute (1-5) The citation attribute.  
Citation Copyright Status The citation copyright status.  
Citation Covered by Library Indicates if the citation has availability in the library

Value is Yes if the citation has an MMS ID (which means it is a repository citation) or if Link & Availability has a URL (using the Alma link resolver).

Citation Creation Date The creation date of the citation  
Citation Created By The creator of the citation  
Citation Due Date The due date of the citation  
Citation File Size (KB) The size of the citation file  
Citation Has Assignment Indicates if the citation has an assignment  
Citation Has Public Note Indicates if the citation has a public note  
Citation Hidden Links Indicates if there are hidden links in the citation Possible values:
  • No hidden links
  • Hidden link/s
Citation ID The ID of the citation  
Citation Instructor Library Tags Code The code of the library tags of the citation Includes tags of type "Instructor-Library"
Citation Instructor Library Tags Description The description of the library tags of the citation Includes tags of type "Instructor-Library". 
Citation Library External Tags Code The code of the library external tags of the citation Includes tags of type "Library-External".
Citation Library External Tags Description The description of the library external tags of the citation Includes tags of type "Library-External". 
Citation Library Internal Tags Code The code of the library internal tags of the citation Includes tags of type "Library-Internal".
Citation Library Internal Tags Description The description of the library internal tags of the citation Includes tags of type "Library-Internal". 
Citation License Type The license type of the citation  
Citation Link Set First Indicates (Yes/No) if a link is set first in the citation  
Citation Locate Status The locate status of the citation  
Citation Material Type The material type of the citation  
Citation Material Type Code The material type code of the citation  
Citation Material Visibility End Date The visibility end date of the citation material  
Citation Material Visibility Start Date The visibility start date of the citation material  
Citation Modification Date The modification date of the citation  
Citation Modified By The user who modified the citation  
Citation Number of Loans The number of times the citation was loaned during the course dates  
Citation Order A number indicating the place of the citation in order  
Citation Public Note The public note of the citation  
Citation Public Tags Code The code of the public tags of the citation Includes tags of type "Public".
Citation Public Tags Description The description of the public tags of the citation Includes tags of type "Public". 
Citation Resolving Disabled Indicates if the resolving feature is disabled  
Citation Source The source URL of the citation  
Citation Status The status of the citation  
Citation Sticker Price The total price of the citations with sticker price  
Citation System Tags Code Displays the code of all tags not mapped to a tag type, including tags added from the integration with the UK Digital Content Store and possibly tags added from the Leganto Questions feature.  
Citation System Tags Description Displays the description of all tags not mapped to a tag type, including tags added from the integration with the UK Digital Content Store and possibly tags added from the Leganto Questions feature.  
Citation Thumbnail File Size (KB) The size of the citation thumbnail file  
Citation Type The citation type Possible values are:
  • Physical book
  • Physical article
  • Electronic book
  • Electronic article
Citation Uploaded File Indicates if the citation has an uploaded file  
Citation Visibility End Date The visibility end date of the citation  
Citation Visibility Start Date The visibility start date of the citation  
Course End Date The end date of the course  
Course Start Date The start date of the course  
Is Digital Citation Indicates if the citation is a digital resource  
Is Repository Citation Indicates if the citation is linked to the repository Possible values are:
  • Yes
  • No
Link to PDF The URL of the PDF of the citation The URL of the Link in Record. See Link in Record  for more information. This link displays in Leganto as GetPDF.
For this field to display data, you must activate Quicklinks in Primo. For more information, see Default Settings.
MMS ID The MMS ID of the citation  
Num of Assignments The number of assignments that are linked to a citation  
Num of Private Annotations the number of private annotations of the citation  
Num of Public Annotations the number of public annotations of the citation