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

    Esploro Researcher Activities

    This subject area is available only for Esploro customers.
    You can use the fields in the Esploro Researcher Activities subject area to create reports on researcher activities by number of activities, number of organization members, and number of researcher members and answer the following types of business questions:
    • How many activities are there from each category/ type?
    • How many activities are there for each researcher (also by category/type)?
    • What is the original ID of activity X?
    • Where do most activities happen?
    • What activities are missing descriptions?
    • Activities Start and End Dates by year/month
    • How many activities were added by year/month
    • How many activities have started?
    • How many activities ended?
    • Which activities have not started yet?
    • Activities count by local fields
    esploro_researcher_activities_field_descriptions.png
    Esploro Researcher Activities – Field Descriptions

    Field Descriptions

    The following lists the fields available in Esploro Researcher Activities.
    researcher_activities_star_diagram.png
    Esploro Researchers Activities – Star Diagram
    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.

    Researcher Activity Measures

    Researcher Activity Measures is a fact table that stores measures relating to researcher activities.

    Researcher Activity Measures
    Field Description Additional Information
    Number of Activities The number of activities  
    Number of Organization Members (All) The number of all organization members  
    Number of Researcher Members (All) The number of all researcher members  
    Number of Researcher Members (Affiliated) The number of affiliated researcher members  
    Number of Researcher Members (Non-Affiliated) The number of non-affiliated researcher members  

    Activity Details

    Activity Details is a dimension table that stores details about researcher activities.

    Activity Details
    Field Description Additional Information
    Activity Category The activity category  
    Activity Input Method The activity input method  
    Activity Internal ID The activity internal ID  
    Activity Name The activity name  
    Activity Name (Language) The language of the activity name  
    Activity Public Note The activity public note  
    Activity Type The activity type  
    Event Name The event name  
    Facility The facility  
    Is Online Activity Indicates if the activity is online  
    Original ID The original ID  
    Portal Visibility Indicates if the activity is visible in the portal  
    Portal Visibility Update Date The date portal visibility was updated  
    Repository Status The repository status  

    Activity Additional Fields

    Activity Additional Fields is a dimension table that stores details about activity additional fields.

    Activity Additional Fields
    Field Description Additional Information
    Activity Additional Fields 1-15 Activity additional fields  

    Activity Associated Organization Units

    Activity Associated Organization Units is a dimension table that stores details about Activity Associated organization units.
    Activity Associated Organization Units
    Field Description Additional Information
    Activity Organization Unit Code The code of the organization unit with which the activity is associated  
    Activity Organization Unit Name The name of the organization unit with which the activity is associated  
    Activity Organization Unit Type The type of the organization unit with which the activity is associated  
    Activity Organization Unit Names List The names list of the organization unit with which the activity is associated  

    Activity Attributes

    Activity Attributes is a dimension table that stores details about activity attributes.
    Activity Attributes
    Field Description Additional Information
    Activity Attribute Code The code of the activity attribute  
    Activity Attribute Value The value of the activity attribute  
    Activity Attribute List The list of the activity attribute  

    Activity Contract Amount Information

    Activity Contract Amount Information is a dimension table that stores information about the activity contract amount.
     
    Field Description Additional Information
    Activity Contract Amount The activity contract amount  
    Activity Contract Amount Currency The activity contract amount currency  

    Activity Courses

    Activity Courses is a dimension table that stores details about activity courses.
     
    Field Description Additional Information
    Course Enrollment The course enrollment information  
    Course Hours The hours of the course  
    Course ID The ID of the course  
    Course Level The level of the course  
    Course Name The name of the course  
    Course Section The section of the course  
    Course Term The term of the course  

    Activity Creation Date

    Activity Creation Date is a dimension table that stores details about activity creation dates.
    Activity Creation Date
    Field Description Additional Information
    Activity Creation Date Stores the date that the activity was created in Esploro in the date format 2/29/2012  
    Activity Creation 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
    Activity Creation Month Stores the month of the date in month description format such as February  
    Activity Creation Full Month Stores the month and the year of the date in a display format such as Feb 12  
    Activity Creation Quarter Stores the quarter of the date in a display format such as Q1  
    Activity Creation Year Stores the year of the date in string format such as 2012  

    Activity Dates

    Activity Dates is a dimension table that stores details about activity dates.

    Activity Dates
    Field Description Additional Information
    Activity Start Date The activity start date The start date of the activity
    Activity Start Date (Calendar) The activity start date The date in format 01/01/2007 that can be used for filtering by date in the report. If the month or day are missing, 01 is used
    Activity End Date The activity end date The end date of the activity
    Activity End Date (Calendar) The activity end date The date in format 01/01/2007 that can be used for filtering by date in the report. If the month or day are missing, 01 is used

    Activity Descriptions

    Activity Descriptions is a dimension table that stores details about activity descriptions.

    Activity Descriptions
    Field Description Additional Information
    Activity Description The description of the activity  
    Activity Description (Language) The language of the description of the activity  

    Activity File Licenses

    Activity File Licenses is a dimension table that stores details about activity file licenses.

    Activity File Licenses
    Field Description Additional Information
    File License Code The code of the file license  
    File License Description The description of the file license  
    File License Name The name of the file license  
    File License URL The URL of the file license  
    Activity 

    Activity Files

    Activity Files is a dimension table that stores details about activity files.

    Activity Files
    Field Description Additional Information
    Activity File Access Rights ID The access rights ID of the activity file  
    Activity File Create Date The creation date of the activity file  
    Activity File Creator The creator of the activity file  
    Activity File Description The description of the activity file  
    Activity File Display Name The display name of the activity file  
    Activity File Extension The extension of the activity file  
    Activity File ID The ID of the activity file  
    Activity File Internal Path The internal path of the activity file  
    Activity File Mime Path The Mime path of the activity file  
    Activity File Modification Date The modification date of the activity file  
    Activity File Modified By The user who modified the activity file  
    Activity File Name The name of the activity file  
    Activity File Order The order of the activity file  
    Activity File Size (In Bytes) The size of the activity file (in bytes)  
    Activity File Type The type of the activity file  

    Activity Links

    Activity Links is a dimension table that stores details about activity links .

    Activity Links
    Field Description Additional Information
    Activity Link Create Date The creation date of the activity link  
    Activity Link Creator The creator of the activity link  
    Activity Link Description The description of the activity link  
    Activity Link License Code The license code of the activity link  
    Activity Link Modification Date The modification date of the activity link  
    Activity Link Modified By The user who last modified the activity link  
    Activity Link Order The order of the activity link  
    Activity Link Ownership The owner of the activity link  
    Activity Link Rights The rights of the activity link  
    Activity Link Title The title of the activity link  
    Activity Link Type The type of the activity link  
    Activity Link URL The URL of the activity link  

    Activity Location

    Activity Location is a dimension table that stores details about activity location.

    Activity Location
    Field Description Additional Information
    Address Line 1 The first address line  
    Address Line 2 The second address line  
    City The city  
    State Province The state or province  
    Country The country  

    Activity Publication Information

    Activity Publication Information is a dimension table that stores information about activity publications.

    Activity Research Topics
    Field Description Additional Information
    DOI The DOI  
    ISSN The ISSN  
    Journal Title The journal title  
    Publisher The publisher  

    Activity Research Topics

    Activity Research Topics is a dimension table that stores details about activity research topics.

    Activity Research Topics
    Field Description Additional Information
    Activity Research Topic Code The code of the activity research topic  
    Activity Research Topic Type The type of the activity research topic  
    Activity Research Topic Value The value of the activity research topic  
    Activity Research Topic Keyword List The keyword list of the activity research topic  
    Activity Research Topic Keywords (Language) The language set for the topic keywords of the activity research topic  
    Activity Subject List The list of the activity subject  

    Activity Researcher Members

    Activity Researcher Members is a dimension table that stores details about activity researcher members.

     
    Field Description Additional Information
    Researcher Member Affiliated Primary Identifier The primary identifier of the researcher member  
    Researcher Member Affiliated/Non-Affiliated Indicates if the researcher member is affiliated or non-affiliated  
    Researcher Member Areas of Interest The areas if interest of the researcher member  
    Researcher Member Associations The associations of the researcher member  
    Researcher Member Creation Date The creation date of the researcher member  
    Researcher Member Creator The creator of the researcher member  
    Researcher Member Current External Organization Affiliations Names List The current external organization affiliation names list of the researcher member  
    Researcher Member Current Internal Organization Affiliations Names List The current internal organization affiliation names list of the researcher member  
    Researcher Member Display in Profile Indicates if the researcher member is displayed in the profile  
    Researcher Member End Date The end date of the researcher member  
    Researcher Member First Name The first name of the researcher member  
    Researcher Member Has Proxy The last name of the researcher member  
    Researcher Member Has Public Profile Indicates if the researcher member has a public profile  
    Researcher Member Honors The honors of the researcher member  
    Researcher Member Include in Smart Harvesting Indicates if the researcher member is included in Smart Harvesting  
    Researcher Member Internal ID The internal ID of the researcher member  
    Researcher Member Is Active Indicates if the researcher member is active  
    Researcher Member Is Creator The  creator of the researcher member  
    Researcher Member Is Proxy Indicates if the researcher member is a proxy  
    Researcher Member Keywords The keywords of the researcher member  
    Researcher Member Languages The languages of the researcher member  
    Researcher Member Last Name The last name of the researcher member  
    Researcher Member Middle Name The middle name of the researcher member  
    Researcher Member Modification Date The modification date of the researcher member  
    Researcher Member Modified By The user who modified the researcher member  
    Researcher Member Name The name of the researcher member  
    Researcher Member Name Variants The name variants of the researcher member  
    Researcher Member Non-Affiliated Primary Identifier The primary identifier of the non-affiliated researcher member  
    Researcher Member Order The order of the researcher member  
    Researcher Member Position The position of the researcher member  
    Researcher Member Previously Affiliated Indicates if the researcher member was previously affiliated  
    Researcher Member Research Topics The research topics of the researcher member  
    Researcher Member Role The member role of the researcher member  
    Researcher Member Smart Harvesting Last Run The date that smart harvesting was last run for the researcher member  
    Researcher Member Start Date The start date of the researcher member  
    Researcher Member Suffix The suffix of the researcher member  
    Researcher Member Type The type of the researcher member  
    Researcher Member Web Pages URLs The Web page URLs of the researcher member  
    Researcher Members Names List The names list of the researcher member  

    Activity Students

    Activity Students is a dimension table that stores details about activity students.

    Activity Students
    Field Description Additional Information
    Department Category Code The category code of the department  
    Department Category Name The category name of the department  
    Student Name The name of the student  
    Student Note The note of the student  
    Student List The list of the student  

    Activity Thesis Information

    Activity Thesis Information is a dimension table that stores information about activity theses.
    Activity Creation Date
    Field Description Additional Information
    Degree Awarded The degree awarded  
    Thesis Level The thesis level  
    Thesis Title The thesis title  
    Thesis Title (Language) The language of the thesis title  

    Activity Update Date

    Activity Update Date is a dimension table that stores details about activity update dates.
    Activity Creation Date
    Field Description Additional Information
    Activity Update Date Stores the date that the activity was created in Esploro in the date format 2/29/2012  
    Activity Update 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
    Activity Update Month Stores the month of the date in month description format such as February  
    Activity Update Full Month Stores the month and the year of the date in a display format such as Feb 12  
    Activity Update Quarter Stores the quarter of the date in a display format such as Q1  
    Activity Update Year Stores the year of the date in string format such as 2012  

    Institution

    The shared Institution dimension 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  
    Esploro Institution Code The code of the Esploro institution  
    Esploro Institution Name The name of the Esploro institution  
    Data Available As Of When the data became available to analytics  
    Data Updated As Of When the data was taken from Esploro  
     
    • Was this article helpful?