Skip to main content
ExLibris
  • Subscribe by RSS
  • Ex Libris Knowledge Center

    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
    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.

    Reading List Citation

    A reading list citation is a set of attributes that are associated with a citation in a list. It is not the metadata of the citation, but additional attributes that are not metadata, such as due dates, public notes, etc.
    The Reading List Citation table is a fact table that stores the measures 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 Citation 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  
    Leganto Citation Sticker Price The shelf price of the citation  
    Citation Alerts The alerts of the citation  
    Citation ID The ID of the citation  
    Citation Covered by Library Indicates if the citation is available through the library, either as part of the library's holdings or as a resource that is subscribed to by the library  
    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  
    Citation Digital File Name The digital file name of the citation  
    Citation Digital File Date Added The date the digital file of the citation was added  
    New for November
    Citation File Size (KB)
    The size of the citation file  
    New for November
    Citation Thumbnail File Size (KB)
    The size of the citation thumbnail file  
    Citation Additional Person Name (to be deprecated) The additional person name of the citation  
    Citation Representation URL The URL of the digital representation of the citation  
    Is Repository Citation Indicates if the citation is linked to the repository  
    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. Possible values are:
    • Information Incomplete – Not enough information was entered to perform a resource locate
    • Locate Failed – A locate was attempted but failed to complete for some reason.
    • Locate Not Run – A locate was not attempted.
    • Multiple Resources Located – A locate was attempted and multiple resources were found.
    • No Resource Located – A locate was attempted but no resource was found.
    • Not Complete – A locate attempt is in process.
    • Resource Located – A locate was attempted and a single resource was found.
    Citation Public Tags The public tags of the citation  
    Citation Library Tags The library tags of the citation  
    Citation Library Internal Tags The library internal tags of the citation  
    Citation License Type Indicates the type of the citation license, for example: Creative commons 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 Uploaded File The file name that was uploaded to the citation  
    Citation Order A number indicating the place of the citation in order  
    Citation Origin Where the citation originated. Possible values are the following. Values such as Digital/Physical/Electronic indicate that the citation's origin is the Alma repository and the available formats of the resource:
    • CiteIt
    • Digital
    • Digital/Electronic
    • Digital/Physical
    • Digital/Physical/Electronic
    • Electronic
    • External URL
    • File
    • Manually Added
    • Mendeley
    • Physical
    • Physical/Digital
    • Primo Central
    • Refworks
    • Zotero
    • None
    Citation Source The source of the citation  
    Citation Source 1-10 The sources of the citation  
    Leganto Citation Library Discussion Last Update The last day the citation was discussed.  
    Leganto Citation Library Discussions The library discussions of the Leganto citation  
    Leganto Citation Visibility Start Date The start date of the Leganto citation visibility  
    Leganto Citation Visibility End Date The end date of the Leganto citation visibility  
    Leganto Citation Material Visibility Start Date The start date of the Leganto citation material visibility  
    Leganto Citation Material Visibility End Date The end date of the Leganto material visibility  
    CDA/DCS Link The link to the full-text content at the DCS for UK customers.  

    Reading List Citation Create Date

    The Reading List Citation Create Date table is a dimension table that stores details relating to the creation date of the reading list.
    Reading List Citation Create Date
    Field Description Additional Information
    Citation Create Date Stores the transaction date in a date format such as 2/29/2014.  
    Citation Create Start of Week The date of the first business day of the week  
    Citation Create Week Number The number of the week of the year  
    Citation Create 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.
    Citation Create Month Stores the month of the date in month description format such as February  
    Citation Create 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.
    Citation Create Quarter Stores the quarter of the date in a display format such as Q1  
    Citation Create Year Stores the year of the date in number format such as 2012  
    Citation Create Fiscal Month Key Stores the fiscal month of the date in number format such as 2 for February If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.
    Citation Create 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.
    Citation Create Filter Used to filter report results by date.  

    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 Creation Date The creation date of the section  
    Section Creator The creator of the section  
    Section Description The description of the section  
    Section End Date The end date of the section  
    Section Library Internal Tags The library tags of the section  
    Section Library Tags The library tags of the section  
    New for November
    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 Order A number indicating the place of the citation in order  
    Section Public Tags The public tags of the section  
    Section Start Date The start date of the section  
    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 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 Create Date The date that the reading list was created  
    Reading List Creator 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 Order The order of the reading list in the course  
    Reading List Owner The owner of the reading list  
    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  
    Reading List Status The status of the reading list  
    Leganto Publication Date The publication date of the reading list  
    Leganto Reading List Description The description of the reading list  
    Leganto List Num of Library Discussions The number of discussions of the reading list  
    Leganto List Library Discussions The library discussions of the Leganto reading list  
    Leganto List Num of Student Suggestions The number of student suggestions for the reading list  
    Leganto List Library Discussion Last Update The last time the discussions of the reading list was updated  
    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
    • Archived
    Leganto Date Sent for Library Review The date that the reading list was sent for review  
    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  

    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.
    (Leganto only) 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).
    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  
    Academic Department Description The description of the academic department of the course  
    Processing Department The processing department of the course  
    Rolled Over From Code The code of the course from which the course was rolled over  
    Number of Participants The number of participants in the course  
    Weekly Hours The weekly hours 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.
    In addition to the above fields, the Course dimension of the Course Reserves subject area also has the following fields:
    Field Description Additional Information
    Course Submit List By The date by which all reading lists for the course should be submitted  
    New for November
    Course ID
    The ID of the course  
    Searchable ID 1-10 Searchable ID 1-10 of the course  
    Campus Name and Participants The campus where the course is available and the participants of the course at each campus.  
    Campus Name and Participants The campus name and the participants in the course  
    Leganto Course Instructor Instructors that are configured to appear to patrons in Leganto.  

    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 MARC21 Mapping from UNIMARC
    Title Taken from display.title in the display section of the operational record MARC 245 subfields a,b 249 a,b,c,v 200 a,c,d,e,h,i
    Title (Filing) The title with common words such as "The" and "An" removed to help with sorting the title.
    For a video describing the use of this field, see Sort Analytics Reports by Filing Title - Ignoring "The", "A", and "An".
    240 245   200 a,e 500
    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. This field is built in the following manner:
    Alma does the following to the 245 field (except subfields c,h,6 and 8) in the following order:
    1. Removes non filing text.
    2. Removes <<>> and anything between them.
    3. Removes these characters: []|,.;:"
    4. Changes these characters to a space: !@#$%^&*()_+-={}\<>?/~'
    5. Changes characters to lowercase.
    6. Packs spaces (replace all sequences of more than one space with a single space).

    245 a,b

    249 a,b,c,v

    200 a,c,d,e,h,i
    Title Author Combined and Normalized 100 characters of the normalized title and the first four letters of the author in lowercase letters, with spaces removed See Author and Title Fields See Author and Title Fields
    Title (Complete) The information from MARC field 245, subfields $p, $n, $s, $k, $f, $g. 245 a,n,p,h,b,c,f,g,k,s 200 a-i
    Author Taken from display.author in the display section of the operational record 100,110,111 700,701,710,711
    Author (Contributor) An additional Author field

    711 a,c-e,i,j,n,q,u and its 880

    700 a-e,j,q,u and its 880

    710 a-e,i,n,u and its 880

    700 a-d,f,p

    701 a-d,f,p 

    710 a-h,p

    711 a-h,p

    720 a,f"

    721 a,f

    702 a-d,f,g 

    712 a-h,p

    722 a,f

    Collection Name The name of the collection    
    Bibliographic Source of Acquisition Note The name of the people or organization that is the source of the material (from MARC field 541 $a) 541 a  
    Bibliographic Acquisition Accession Number Note The identification code assigned to materials acquired in a single and separate transfer of custody (from MARC field 541 $e). 541 e  
    Collection ID The ID of the collection    
    ISBN Taken from search.isbn in the search section of the operational record MARC 020 a MARC 776 z 010 a
    ISSN Taken from the MMS Display Table in the search section of the operational record 022 l,a 776 x 011 a f
    Original Cataloging Agency The MARC code or the name of the organization that created the original record 040 a 081 b
    Publisher Taken from display.publisher_const_b in the display section of the operational record

    260 b

    264 b

    210 c

    214 c

    Publication Date Taken from display.date_of_publication in the display section of the operational record
    The publication date is determined as follows:
    • the bibliographic details publication date comes from 264 subfield c
    • if there is no 264 subfield c, then the publication date comes from 260 subfield c
    • if there is no 264 subfield c and also no 260 subfield c, then the publication date comes from 008 pos. 7-10
    The publication date is determined as follows:
    • the bibliographic details publication date comes from 210 subfield d
    • If there is no 210 subfield d, then the publication date comes from field 214 subfield d.
    • if both fields do not exist, then the publication date comes from field 100 subfield a pos. 9-12 
    Publication Place Taken from display.place_of_pu blication in the display section of the operational record 260 a 264 a 210 a 214 a
    Place Code Taken from display.place_code in the display section of the operational record 008 pos. 15-17  
    Place of Publication - Country The country of publication    
    Place of Publication - State The state of publication    
    Place of Publication - City The city of publication    
    Material Type See the table, Fields that Identify the Bibliographic Material Type, in the Material Types in Search Results section for a description of material type. MARC control LDR Material Type  
    Material Type Code Code of the material type described above (in Material Type). MARC control LDR Material Type  
    Begin Publication Date Taken from display.begin_pub_date in the search section of the operation 008 pos. 07-10 100.Date1
    End Publication Date Taken from display.end_pub_date in the search section of the operation 008 pos. 11-14 100.Date2
    Category of Material Taken from display. category_of_material in the display section of the operational record Position 0 of the 007 field  200 b
    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 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 010 excluding numeric subfields 020 a
    Network Number Taken from search. other_system_number in the search section of the operational record 035 a z 053 a z
    OCLC Control Number (019) The OCLC control number 019 a  
    OCLC Control Number (035a) The OCLC control number 035 a 035 a
    OCLC Control Number (035a+z) The OCLC control number 035a+z 035a+z
    OCLC Control Number (035z) The OCLC control number 035 z 035 z
    BIB 008 MARC The contents of the MARC 008 bibliographic field 008  
    BIB LDR MARC The contents of the MARC LDR bibliographic field LDR  
    Open Access Indicates if the article is open access Based on 506 f 506 2  
    Edition Taken from display.complete_edition in the display section of the operational record MARC 250 subfields a,b 205 a,b,f,g
    Form of Item The form of the item MARC 008 pos. 23  
    Government Publication The government publication type MARC 008 pos. 28  
    Language Code Taken from display.language in the display section in the operational record 008 pos. 35-37 101 a
    Series Taken from display.series_small in the display section in the operational record

    800 t

    801 t

    811 t

    830 a,n,p,v

    410 a,h,i,o,t,x
    Subjects Taken from display.subjects in the display section of the operational record 69X,630,689 600 a,b 602 603-8 610 616 617
    Type of Date Taken from display. type_of_date in the search section of the operational record 008 pos. 6 100 pos 8
    Uniform Title Taken from display.uniform_title in the display section of the operational record 240 130 500
    Uniform Resource Identifier The uniform resource identifier 856 u 856 u
    Resource Type Constructed based on existing bibliographic fields such as the LDR and 008. For more information, see 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. This is the MMS ID of the portfolios associated with the electronic collection. It is not the MMS ID of the electronic collection or of the MMS ID of the descriptive bibliographic record added in the Additional tab of the electronic collection editor. If there are no portfolios, the value of this field is empty.
    LC Classification Top Line Stores the combined LC code and classification numbers until the first period which is followed by a letter. If there are no periods then the entire string is taken until there is a space. The length is limited to 50 characters.
    For example:
    • if the LC Classification is | a HB3821.I8 |b R3 then the LC Classification Top Line will be HB3821
    • if the LC Classification is | a DF506.5 |b .G27 then the LC Classification Top Line will be DF506.5
    • if the LC Classification is | a N 7353 |b .K513 1965 then the LC Classification Top Line will be N
    • if the LC Classification is | a NOT YET ORDERED then the LC Classification Top Line will be NOT
    The LC Classification Top Line will contain one value. For MARC21, if the bibliographic record has:
    • both 090 and 050 then the LC Classification Top Line will come from 090
    • 050 and not 090 then the LC Classification Top Line will come from 050
    • 090 and not 050 then the LC Classification Top Line will come from 090
    Dewey Classification Stores the Dewey Classification
    Dewey Classification Top Line Stores the first 3 digits of the Dewey Classification
    Chinese Classifications Stores the Chinese Classification
    Local Param 1-10 This field allows you to enrich the bibliographic and holdings information exported to Analytics with additional information from MARC 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). (The field does not need to include a 9.)
    The fields can be number and code fields but not control fields. Therefore, the field must be greater than or equal to 010, because 00X are Control Fields and 01X-09X are Numbers and Code Fields.
    Following configuration of this field by Ex Libris Support, its value will be available in analytics.
    Subfields can be maintained in the Analytics fields identified for Local Param. When this capability is implemented, fields/subfields appear in Alma Analytics with the Alma subfield delimiter (either $$ or ‡) used to delineate the subfield content. Contact Support to enable this feature. Note that reindexing is required to fully implement this capability.
    Note that the local param fields are not related to the MARC type of the record. For example, if field 913 is defined to be in local param 1 then field 913 will always be in local param 1. This is the case if the record is of the type KORMARC, CNMARC, UNIMARC, MARC21, and so forth. It is not possible to have different sets of Local Param 1-10 for different types of MARC.
    Link ID The link ID
    Linked to CZ Indicates if the record is linked to the Community Zone
    Linked to NZ Indicates if the record is linked to the Network Zone
    Creator Stores the name of the user that created the record
    Creation Date Stores the creation date
    Managed by Provider Indicates if the electronic resource is managed by the provider
    Modified By Stores the user name that modified the record
    Modification Date Stores the modification date
    Peer Reviewed Indicates if the article was peer reviewed
    Provider Name The name of the provider
    Record Format The format of the bibliographic record. Possible values:
    • MARC 21
    • DC
    • KORMARC
    • CNMARK
    • UNIMARC
    • None
    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.
    ISSN (Normalized) The normalized ISSN. This field is useful when you want to use the normalized ISSN 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).
    Brief Level The level of the brief record
    Originating System The system where the bibliographic record originated
    Originating System ID The ID of the system where the bibliographic record originated
    Originating System Version The version of the originating system
    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
    Additional Person Name The additional person name  
    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 Author The author of the book chapter This field is relevant only for citations created after March 2018.
    Book Chapter Editor The editor of the book chapter This field is relevant only for citations created after March 2018.
    Book Chapter Number The chapter number of the book  
    Book Chapter Title The title of the book chapter This field is relevant only for citations created after March 2018.
    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 Date The date of publication  
    Publication Place The place of publication  
    Publisher The publisher  
    Title The title of the citation  
    Volume The volume of the citation  

    Citation Copyright

    The citation copyright dimension includes all of the attributes related to the copyright record that were created for a citation. This includes date, approval status, notes, etc.
    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 If the citation form is for a book, the ISBN is used. If the citation form is for an article, the ISSN is used.  
    Issue The issue of the journal  
    LCCN The LCCN  
    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 chapters for which a copyright is required  
    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 book or journal title of the citation  
    Total Chapters Count The total number of chapters in the item for which a copyright is requested  
    Total Required Pages The total number of required pages  
    Volume The volume of the journal  
    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.
    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 the image below.
    User Title The title of the user  
    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 the image below.
    User Group Stores the group with which the user is associated such as Faculty, Graduate, or Student See the field location in Alma in the image below.
    User Record Type Indicates if the user is a Public User or a Staff User See the field location in Alma in the image below.
    First Name Stores the user’s first name See the field location in Alma in the image below.
    Last Name Stores the user’s last name See the field location in Alma in the image below.
    Middle Name Stores the middle name of the user See the field location in Alma in the image below.
    Preferred First Name Stores the user’s preferred first name See the field location in Alma in the image below.
    Preferred Last Name Stores the user’s preferred last name See the field location in Alma in the image below.
    Preferred Middle Name Stores the user's preferred middle name See the field location in Alma in the image below.
    Job Description Stores free-form text that describes the function of the user in the library See the field location in Alma in the image below.
    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 the image below.
    Gender Possible values: male, female, none, other See the field location in Alma in the image below.
    Birth Date Stores the birth date of the user See the field location in Alma in the image below.
    Campus Code Stores the campus code of the user See the field location in Alma in the image below.
    Status Date Stores the date on which the patron was registered in the university See the field location in Alma in the image below..
    Status Indicates if the user is active See the field location in Alma in the image below.
    Creation Date Stores the date that the user was created in the system See the field location in Alma in the image below.
    Last Activity Date The last date that a patron made a request or borrowed or returned an item  
    Modified By Stores the name of the user that modified the user record See the field location in Alma in the image below.
    Modification Date Stores the date of the modification of the user record See the field location in Alma in the image below.
    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 the image below..
    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 the image below..
    Default Language Stores the default language of the user See the field location in Alma in the image below..
    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 the image below..
    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.
    Only one value per identifier is supported.
    Identifier 2 Stores identifier 2. See details in "identifier 1" above.  
    IdP Service in Use Indicates if an identity provider service is in use  
    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. For more information, see Configuring Statistical Categories for Analytics.  
    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.  
    user_details_page_new.png

    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 Start of Week The date of the first business day of the week  
    Current Course Start Date Week Number The number of the week of the year  
    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 Month Key Stores the fiscal month of the date in number format such as 2 for February If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.
    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 Filter Used to filter report results by date.  

    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 Start of Week The date of the first business day of the week  
    Current Course End Date Week Number The number of the week of the year  
    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 Month Key Stores the fiscal month of the date in number format such as 2 for February If the fiscal year description is stored in the institution fiscal period configuration table, this value is taken from there.
    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 Filter Used to filter report results by date.  

    Institution

    The shared Institution dimension allows the Network Zone 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.  
    Institution Timezone The timezone of the institution  
    Data Available As Of When the data became available to analytics  
    Data Updated As Of When the data was taken from Alma  
    If an analytics report is run from the Network Zone 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.