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

    Course Reserves

    Using the Course Reserves area, the Design Analytics user may create reports/dashboards for the Course Reserves area and is able to answer the following types of business questions:
    • Which courses reserved a specific title?
    • Which courses share the same titles?
    • What are the reading lists per department?
    For a video concerning Course Reserves, see the Course Reserves Subject Area video.
    Star Diagram – Course Reserves

    Field Descriptions

    The following lists the fields available in Course Reserves.
    course_reserves_description.png
    Course Reserves

    Reading List Citation

    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.
    Reading List Citation
    Field Description Additional Information
    Number of Citations The number of citations in the reading list  
    Leganto Num of Library Discussions The number of library discussions of the citation  
    Leganto Num of Likes The number of likes of the citation  
    Leganto Num of Read It The number of Read Its of the citation  
    Leganto Num of Student Comments The number of student comments of the citation  
    Citation ID The ID of the citation  
    Citation Creator The creator of the citation  
    Citation Create Date The date the citation was created  
    Citation Modified By The person who modified the citation  
    Citation Modification Date The citation modification date  
    Citation Status The status of the citation  
    Is Repository Citation Indicates if the citation is linked to the repository  
    New for May!
    Citation Copyright Status
    The status of the citation copyright  
    Citation Material Type The citation material type.  
    Citation Attribute (1-5) The citation attributes. For information on configuring the citation attribute fields, see Displaying Citation Attributes in Analytics Reports.
    Citation Type The citation type. Possible values are:
    • Electronic Article – An electronic item with Electronic Material Type=Journal
    • Physical Article – A physical item with Material Type=Journal
    • Physical Book – All other items
    Citation Locate Status Indicates if the resource is located.  
    Citation Public Tags The public tags of the citation  
    Citation Library Tags The library tags of the citation  
    New for May!
    Citation License Type
    Indicates the type of the citation license, for example: SIPX, Creative common, and DCS.  
    Citation Due Date The due date of the citation  
    Citation Public Note The public note of the citation  
    Citation Has Public Note Indicates if the citation has a public note  
    Citation Order A number indicating the place of the citation in order  
    New for May!
    Leganto Citation Visibility Start Date
    The start date of the Leganto citation visibility  
    New for May!
    Leganto Citation Visibility End Date
    The end date of the Leganto citation visibility  
    New for May!
    Leganto Citation Material Visibility Start Date
    The start date of the Leganto citation material visibility  
    New for May!
    Leganto Citation Material Visibility End Date
    The end date of the Leganto material visibility  

    Leganto 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 Create Date.
    Leganto Reading List Section
    Field Description Additional Information
    Section Name The name of the section  
    Section Description The description of the section  
    Section Order A number indicating the place of the citation in order  
    Section Public Tags The public tags of the section  
    Section Library Tags The library tags of the section  
    Section Creation Date The creation date of the section  
    Section Modification Date The modification date of the section  
    Section Modified By Who modified the section last  
    Section Start Date The start date of the section  
    Section End Date The end date of the section  
    Section Creator The creator of the section  
    New for May!
    Section Visibility
    Indicates whether the section is hidden from students outside of the section dates  

    Reading List

    The Reading List 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 List
    Field Description Additional Information
    Reading List Code The code of the reading list  
    Reading List Name The name of the reading list  
    Reading List Owner The owner of the reading list  
    Reading List Status The status of the reading list  
    Reading List Due Back Date The due back date of the reading list  
    Reading List Creator The creator of the reading list  
    Reading List Create Date The date that the reading list was created  
    Reading List Modified By The person who modified the reading list  
    Reading List Modification Date The date that the reading list was modified  
    Leganto Publication Status The publication status of the reading list Possible values are:
    • Draft
    • Published
    Leganto 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
    Reading List Owner Primary Identifier The primary identifier of the reading list owner  
    Reading List Owner With Primary Identifier The primary identifier of the reading list owner with the primary identifier  

    Course

    The Course 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.
    Course
    Field Description Additional Information
    Course Code The code of the course  
    Course Name The name of the course  
    Course Status The status of the course  
    Course Year The year of the course  
    Course Term The term of the course  
    Academic Department The academic department of the course  
    Processing Department The processing department of the course  
    Number of Participants The number of participants in the course  
    Weekly Hours The weekly hours of the course  
    Searchable ID 1-3 Searchable ID 1-3 of the course  
    Course Creator The creator of the course  
    Course Modified By The person who modified the course  
    Course Modification Date The date that the course was modified  
    Course Section The section of the course  
    Course Create Date The date that the course was created  
    Course Instructor The name of the course instructor If there is more than one instructor, the names are separated by a semicolon.
    Course Instructor Primary Identifier The primary identifier 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 primary identifiers.

    Bibliographic Details

    The Bibliographic Details table is a dimension table that stores the bibliographic details of the course reserves. The primary key of the table is BIB_ID.
    The field descriptions can be found in the Bibliographic Details shared dimension.
    Bibliographic Details
    Field Source in Alma (for Internal Reference) Mapping from MARC
    Title Taken from display.title in the display section of the operational record MARC 245 subfields a,b
    Author Taken from display.author in the display section of the operational record List values, delimiter is (;)
    • MARC 100 excluding Numeric subfields
    • MARC 110 excluding numeric subfields
    • MARC 111 excluding numeric subfields
    ISBN Taken from search.isbn in the search section of the operational record List values, delimiter is ;
    MARC 020 a,e,z
    ISSN Taken from search.issn in the search section of the operational record List values, delimiter is ;
    MARC 022 a,y,e,z
    Publisher Taken from display.publisher_const_b in the display section of the operational record MARC 260 b
    MARC 264 b
    Remove special characters and replace spaces.
    Publication Date Taken from display.date_of_publication in the display section of the operational record MARC 260 c
    Publication Place Taken from display.place_of_pu blication in the display section of the operational record MARC 260 a
    Place Code Taken from display.place_code in the display section of the operational record For MARC21 this is taken from 008 pos. 15-17
    Material Type Taken from search. material_type in the search section of the operational record MARC control LDR Material Type
    Begin Publication Date Taken from display.begin_pub_date in the search section of the operation For MARC21 this is taken from 008 pos. 7-10
    End Publication Date Taken from display.end_pub_date in the search section of the operation For MARC21 this is taken from 008 pos. 11-14
    Category of Material Taken from display. category_of_material in the display section of the operational record Position 0 of the 007 field of the bibliographic record
    Bibliographic Level Taken from display.bib_level in the display section of the operational record Position 7 of the LDR field of the bibliographic record
    Bibliographic ID Taken from display.bib_id in the display section in the operational record MARC 010 excluding numeric subfields
    Network Number Taken from search. other_system_number in the search section of the operational record This field is called "other system number" in Alma List values. The delimiter is ;
    MARC 035 excluding numeric subfields
    Edition Taken from display.complete_edition in the display section of the operational record MARC 250 subfields a,b
    Language Code Taken from display.language in the display section in the operational record For MARC21 this is taken from 008 pos. 35-37
    Series Taken from display.series_small in the display section in the operational record List values, delimiter is ;
    • MARC 830 subfields a,x,v
    • MARC 800 excluding numeric subfields
    • MARC 810 excluding numeric subfields
    Subjects Taken from display.subjects in the display section of the operational record List values, delimiter is ;
    MARC 6XX excluding numeric
    Type of Date Taken from display. type_of_date in the search section of the operational record For MARC21 this is taken from 008 pos. 6
    Uniform Title Taken from display.uniform_title in the display section of the operational record MARC 240 excluding numeric subfields
    MARC 130 subfields a,p
    Resource Type Constructed based on existing bibliographic fields such as the LDR and 008. For more information, see Working with the Resource Type Field.  
    The following table describes other fields in the shared dimension (taken from Alma and not MARC):
    Bibliographic Details
    Field Source in Alma (for Internal Reference)
    Active Course Code The code of an active course.
    Active Course Name The name of an active course.
    MMS ID Stores the MMS ID of the item
    LC Classification Top Line Stores the combined LC code and classification numbers until the first period followed by a letter such as NB933 when the lc_class_number is NB933.F44
    Dewey Classification Stores the Dewey Classification
    Dewey Classification Top Line Stores the first 3 digits of the Dewey Classification
    Local Param1 This field allows you to enrich the bibliographic information exported to Analytics with additional information stored in MARC 9XX local fields in Alma.
    In order to make use of this field, you must contact Ex Libris Support and supply them with a three-digit MARC field code (for example, 901). Following configuration of this field by Ex Libris Support, its value will be available in analytics.
    Local Param2 See the description above.
    Local Param3 See the description above.
    Local Param4 See the description above
    Local Param5 See the description above
    Creator Stores the name of the user that created the record
    Creation Date Stores the creation date
    Modified By Stores the user name that modified the record
    Modification Date Stores the modification date
    Suppressed from Discovery Indicates whether the record is suppressed from external discovery systems
    Bibliographic Lifecycle The Lifecycle of the item. Possible values are Deleted and In Repository. This allows you to filter reports by In Repository/Deleted items.
    Network ID This field is used by institutions implementing a Network Zone. It is the same as the MMS ID of the bibliographic record in the Network Zone and can be used to create reports that show the MMS ID in the member institution (using the existing MMS ID), as well as the corresponding MMS ID in the Network Zone.
    Title (Normalized) The normalized Title. This field is useful when you want to use the normalized title from one subject area to compare with a report with fields from a different subject area.
    ISSN (Normalized) The normalized ISSN. This field is useful when you want to use the normalized ISBN from one subject area to compare with a report with fields from a different subject area.
    ISBN (Normalized)
    The ISBN. Created for uniformity with Title (Normalized) and ISSN (Normalized).
    Title and other bibliographic details of non-repository citations are not displayed in analytics reports, although the title is displayed in Alma.

    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
    Article End Page The end page of the article  
    Article Number of Pages The number of pages in the article  
    Article Start Page The start page of the article  
    Author The author of the article  
    Book Call Number The call number of the book  
    Book Chapter The chapter of the book  
    Book Edition The edition of the book  
    DOI The digital object identifier  
    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  
    Note The note  
    OCLC Number The OCLC number  
    Pages The pages of the citation  
    Part The part  
    Publication Place The place of publication  
    Publication Date The date of publication  
    Publisher The publisher  
    Title The title of the citation  
    Volume The volume of the citation  

    Citation Copyright

    The Citation Copyright table is a dimension table that stores the citation copyright information of the course reserves.
    Citation Copyright
    Field Description Additional Information
    Approval Reason The reason the copyright was approved. The list of approval reasons (see Approving/Rejecting a Request for Digitization)
    Author The author of the citation  
    Available From Date The date from which the copyright is available  
    Available To Date The date until which the copyright is available  
    CC Approval Date The citation copyright approval date  
    CC Number The citation copyright number  
    CC Order Date The citation copyright order date  
    Copyright Status The status of the copyright  
    Course Code The course code  
    Course Name The course name  
    Course Section The section of the course  
    Digitization Date The digitization date  
    Digitization Type The digitization type  
    Fulfillment Date The fulfillment date  
    Is Full Chapter Indicates if the copyright is for a full chapter  
    ISBN-ISSN The ISBN-ISSN  
    Issue The issue of the journal  
    LCCN The LCCN  
    New for May!
    Leganto Image Included
    Indicates if an image was included in a Leganto digitization request.  
    Note 1-3 Notes 1-3  
    Number of Copies for Staff The number of copies for staff  
    Number of Copies for Students The number of copies for students  
    Number of Students The number of students  
    OCLC Number The OCLC number  
    Reject Note The rejection note  
    Reject Reason The rejection reason  
    Required Chapters The required chapters  
    Required Digitization Indicates if the citation requires digitization  
    Required Pages From 1 The first page from which the copyright is required  
    Required Pages From 2 The second page from which the copyright is required  
    Required Pages To 1 The first page to which the copyright is required  
    Required Pages To 2 The second page to which the copyright is required  
    Resource Total Pages The total number of pages in the resource  
    Send For Manual Approval Indicates if the citation is sent for manual approval  
    Source for Copyright The source of the citation  
    Title The title of the citation  
    Total Chapters Count The total number of chapters  
    Total Required Pages The total number of required pages  
    Volume The volume of the journal  
    New for May!
    Copyright Status
    The status of the copyright  

    Librarian

    The Librarian table is a dimension table that stores details about the librarian, including User ID, campus code, and job title. The primary key of the table is USER_ID.
    The field descriptions can be found in the User Details shared dimension.
    User Details
    Field Description Additional information
    User ID Stores the unique ID of the user  
    Primary identifier Stores the primary identifier that the user uses in order to log on to Alma See the field location in Alma in Alma User Details Page – General Information.
    User Type Stores the values Internal and External.
    • Internal - An internal user is one whose core user details are managed within the system such as user name, password, contact information, and so forth.
    • External - An external user is one whose core user details are managed by a student information system.
    See the field location in Alma in Alma User Details Page – General Information.
    User Group Stores the group with which the user is associated such as Faculty, Graduate, or Student See the field location in Alma in Alma User Details Page – General Information.
    User Record Type Indicates if the user is a Public User or a Staff User See the field location in Alma in Alma User Details Page – General Information.
    First Name Stores the user’s first name See the field location in Alma in Alma User Details Page – General Information.
    Last Name Stores the user’s last name See the field location in Alma in Alma User Details Page – General Information.
    Middle Name Stores the middle name of the user See the field location in Alma in Alma User Details Page – General Information.
    Job Description Stores free-form text that describes the function of the user in the library See the field location in Alma in Alma User Details Page – General Information.
    Job Title Stores the job category definition to which the user belongs based on the Job Categories code table See the field location in Alma in Alma User Details Page – General Information.
    Gender Stores male or female See the field location in Alma in Alma User Details Page – General Information.
    Birth Date Stores the birth date of the user See the field location in Alma in Alma User Details Page – General Information.
    Campus Code Stores the campus code of the user See the field location in Alma in Alma User Details Page – General Information.
    Status Date Stores the date on which the patron was registered in the university See the field location in Alma in Alma User Details Page – General Information.
    Status Indicates if the user is active See the field location in Alma in Alma User Details Page – General Information.
    Creation Date Stores the date that the user was created in the system See the field location in Alma in Alma User Details Page – General Information.
    Modified By Stores the name of the user that modified the user record See the field location in Alma in Alma User Details Page – General Information.
    Modification Date Stores the date of the modification of the user record See the field location in Alma in Alma User Details Page – General Information.
    Expiry Date Stores the date on which the user is to expire and no longer be able to get service from the system See the field location in Alma in Alma User Details Page – General Information.
    Changing the user expiry date is one way to control item due dates that extend beyond the end of a semester and must be shortened to the end of the semester. For more information, see How to Make Items Have Due Dates at the End of the Semester.
    Locked Out Date Indicates the date on which the user is locked out. A user is locked out if he tries to access the Alma system several times with incorrect credentials.  
    Purge Date Stores the date on which the user record is to be deleted from Alma See the field location in Alma in Alma User Details Page – General Information.
    Default Language Stores the default language of the user See the field location in Alma in Alma User Details Page – General Information.
    Failed Authentication Stores the number of times that the user tried to access Alma with an incorrect password  
    Creator Stores the user name of the user that created the user in the system See the field location in Alma in Alma User Details Page – General Information.
    External ID Stores the ID of the user in the originating system  
    Identifier 1 Stores identifier 1. The identifier field allows you to enrich the user details exported to Analytics with additional identifiers. Choosing a specific identifier to be included in the user details is done in Alma (in a table that is currently restricted to Ex Libris staff). For assistance in defining this field, contact Ex Libris Support.  
    Identifier 2 Stores identifier 2. See details in "identifier 1" above.  
    Statistical Categories 1-5 These fields allow you to map five statistical categories. This allows you to filter reports based on advanced user information typically stored in the statistical category fields.  
    Resource Sharing Library Code The code of the resource sharing library assigned to the user.  
    Resource Sharing Library The resource sharing library assigned to the user.  
    Alma User Details Page – General Information
    Alma User Details Page – General Information

    Current Course Start Date

    The Current Course Start Date is a dimension table that stores details about the current course start date. The primary key of the table is COURSE_START_DATE.
    Current Course Start Date
    Field Description Additional Information
    Current Course Start Date Stores the transaction date in a date format such as 2/29/2014.  
    Current Course Start Date 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.
    Current Course Start Date Month Stores the month of the date in month description format such as February  
    Current Course Start Date 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.
    Current Course Start Date Quarter Stores the quarter of the date in a display format such as Q1  
    Current Course Start Date Year Stores the year of the date in number format such as 2012  
    Current Course Start Date 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.
    Current Course Start Date Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific current course start date. This column provides the user the option to view the cumulative measures in each level of the hierarchy. This corresponds to the Start date in Fulfillment > Course Reserves > Courses.

    Current Course End Date

    The Current Course End Date is a dimension table that stores details about the current course end date. The primary key of the table is COURSE_END_DATE.
    Current Course Start Date
    Field Description Additional Information
    Current Course End Date Stores the transaction date in a date format such as 2/29/2014.  
    Current Course End Date 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.
    Current Course End Date Month Stores the month of the date in month description format such as February  
    Current Course End Date Full Month Stores the month of the date in month description format such as February This field is useful when comparing data on a month basis between years.
    Current Course End Date Quarter Stores the quarter of the date in a display format such as Q1  
    Current Course End Date Year Stores the year of the date in number format such as 2012  
    Current Course End Date 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.
    Current Course End Date Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific current course start date. This column provides the user the option to view the cumulative measures in each level of the hierarchy. This corresponds to the Start date in Fulfillment > Course Reserves > Courses.

    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.

    Shared Dimensions with Other Subject Areas

    For information concerning shared dimensions with other subject areas, see Shared Dimensions.
    • Was this article helpful?