Esploro Researcher Activities
- 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](https://knowledge.exlibrisgroup.com/@api/deki/files/132710/esploro_researcher_activities_field_descriptions.png?revision=1)
Field Descriptions
![researcher_activities_star_diagram.png](https://knowledge.exlibrisgroup.com/@api/deki/files/132711/researcher_activities_star_diagram.png?revision=1)
Researcher Activity Measures
Researcher Activity Measures is a fact table that stores measures relating to researcher activities.
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.
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.
Field | Description | Additional Information |
---|---|---|
Activity Additional Fields 1-15 | Activity additional fields | For each Activity Additional field, the label that you configure appears for the field name. |
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
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
Field | Description | Additional Information |
---|---|---|
Activity Contract Amount | The activity contract amount | |
Activity Contract Amount Currency | The activity contract amount currency |
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
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 Creation Year-Month | Stores the year and the month in a format such as 2023-1 |
Activity Dates
Activity Dates is a dimension table that stores details about 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.
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.
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 Files
Activity Files is a dimension table that stores details about 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 .
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.
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.
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.
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 Country | This field is for future use | |
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.
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
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
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 | |
Activity Update Year-Month | Stores the year and the month in a format such as 2023-1 |