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
Field Descriptions
The following lists the fields available in Esploro Researcher Activities.
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.
| 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
Activity Associated Organization Units is a dimension table that stores details about 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.
| 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.
| 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
Activity Thesis Information is a dimension table that stores information about activity theses.
| 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.
| 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 |