Esploro Research Grants
This subject area is available only for Esploro customers.
You can use the fields in the Esploro Research Grants subject area to create reports to get insights on the grants used by the researchers in the institution and to answer business questions such as:
- What are the highest awarded grants received at the institution and who received them?
- Who are the researchers that received the greatest numbers of grants?
- Which funders provided funding for the institution’s research and in what amount?
Esploro Research Grants – Star Diagram
Field Descriptions
The following lists the fields available in Esploro Research Grants.
Esploro Research Grants Field Descriptions
Grant Measures
Grant Measures is a fact table that stores measures relating to grants.
| Field | Description | Additional Information |
|---|---|---|
| Number of Grants | The number of grants | |
| Number of Assets | The number of assets | |
| Number of Grants with Assets | The number of grants with assets | |
| Number of Investigators | The number of investigators | |
| Number of Investigators (Affiliated researchers) | The number of investigators that are affiliated researchers | |
| Number of Investigators (Non-affiliated Researchers) | The number of investigators that are non-affiliated researchers | |
| Grant Amount | The amount of the grant |
Grant Details
Grant Details is a dimension table that stores details about grant details.
| Field | Description | Additional Information |
|---|---|---|
| Grant Acronym | The acronym of the grant | |
| Grant ID | The ID of the grant | |
| Grant Internal ID | The internal ID of the grant | |
| Grant Name | The name of the grant | |
| Grant Description | The description of the grant | |
| Grant Category | The category of the grant | |
| Grant Currency | The currency of the grant | |
| Grant Status | The status of the grant | |
| Grant Created By | The user who created the grant | |
| Grant Modified By | The user who modified the grant | |
| Grant Source | The source of the grant | Possible Values:
|
| Funder Abbreviation | The abbreviation of the funder | |
| Grant Keywords | The keywords of the grant | |
| Grant Research topics | The research topics of the grant | |
| Grant Expected Start Date | The expected start date of the grant | |
| Grant Expected End Date | The expected end date of the grant | |
| Grant Type | The grant type | For more information, see Configuring Grants. |
| Grants URL | The URL of the grant |
Grant Creation Date
Grant Creation Date is a dimension table that stores details about the creation date of the grant.
| Field | Description | Additional Information |
|---|---|---|
| Grant Creation Date | Stores the date that the grant was created in Esploro in the date format 2/29/2012 | |
| Grant 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 |
| Grant Creation Month | Stores the month of the date in month description format such as February | |
| Grant Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Grant Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Grant Creation Year | Stores the year of the date in string format such as 2012 | |
| Grant Creation Year-Month | Stores the year and the month in a format such as 2023-1 |
Grant Modification Date
Grant Modification Date is a dimension table that stores details about the modification date of the grant.
| Field | Description | Additional Information |
|---|---|---|
| Grant Modification Date | Stores the grant modification date in the date format 2/29/2012 | |
| Grant Modification 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 |
| Grant Modification Month | Stores the month of the date in month description format such as February | |
| Grant Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Grant Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Grant Modification Year | Stores the year of the date in string format such as 2012 | |
| Grant Modification Year-Month | Stores the year and the month in a format such as 2023-1 |
Grant Start Date
Grant Start Date is a dimension table that stores details about the grant start date.
| Field | Description | Additional Information |
|---|---|---|
| Grant Start Date | Stores the date that the grant was created in Esploro in the date format 2/29/2012 | |
| Grant Start 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 |
| Grant Start Month | Stores the month of the date in month description format such as February | |
| Grant Start Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Grant Start Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Grant Start Year | Stores the year of the date in string format such as 2012 | |
| Grant Start Year-Month | Stores the year and the month in a format such as 2023-1 |
Grant End Date
Grant End Date is a dimension table that stores details about the grant end date.
| Field | Description | Additional Information |
|---|---|---|
| Grant End Date | Stores the date that the grant was created in Esploro in the date format 2/29/2012 | |
| Grant End 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 |
| Grant End Month | Stores the month of the date in month description format such as February | |
| Grant End Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Grant End Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Grant End Year | Stores the year of the date in string format such as 2012 | |
| Grant End Year-Month | Stores the year and the month in a format such as 2023-1 |
Grant Funder
Grant Funder is a dimension table that stores details about the grant funder.
| Field | Description | Additional Information |
|---|---|---|
| Funder Unit Code | The organization unit code of the funder | |
| Funder Unit Country | The organization unit country of the funder | |
| Funder Unit Name | The organization unit name of the funder | |
| Funder Parent Unit Code | The funder's parent organization unit code | |
| Funder Parent Unit Name | The funder's parent organization unit name | |
| Funder Parent Unit Country | The funder's parent organization unit country | |
| Funder Unit Status | The status of the funder organization unit | |
| Funder Unit Type | The type of the funder organization unit | Grant Funder Agency |
Grant Funder Agency
Grant Funder Agency is a dimension table that stores details about the agency of the grant funder.
| Field | Description | Additional Information |
|---|---|---|
| Funder Agency Unit Code | The organization unit code of the funder agency | |
| Funder Agency Unit Country | The organization unit country of the funder agency | |
| Funder Agency Unit Name | The organization unit name of the funder agency | |
| Funder Agency Parent Unit Code | The funder agency's parent organization unit code | |
| Funder Agency Parent Unit Country | The funder agency's parent organization unit country | |
| Funder Agency Parent Unit Name | The funder agency's parent organization unit name | |
| Funder Agency Unit Status | The organization unit status of the funder agency | |
| Funder Agency Unit Type | The organization unit type of the funder agency |
Grant Related Organizations
Grant Related Organizations is a dimension table that stores details about organizations related to the grant.
| Field | Description | Additional Information |
|---|---|---|
| Unit Organization Code | ||
| Unit Organization Country | ||
| Unit Organization Name | ||
| Unit Organization Relation Type | ||
| Unit Organization Status | ||
| Unit Organization Type | ||
| Parent Organization Code | ||
| Parent Organization Country | ||
| Parent Organization Name | ||
| Is Internal Organization |
Grant Investigators
Grant Investigators is a dimension table that stores details about grant investigators.
| Field | Description | Additional Information |
|---|---|---|
| Investigator Identifiers | The identifiers of the investigator | |
| Affiliated | Indicates if the investigator is an affiliated researcher | |
| Areas of Interest | The areas of interest of the researcher | |
| Associations | The associations of the researcher | |
| Access to Researcher Profile | Indicates if the researcher has access to the researcher profile | |
| Current External Organization Affiliations Country | This field is for future use | |
| Current External Organization Affiliations Names List | The list of the names of the current external affiliations of the researcher | |
| Current Internal Organization Affiliations Names List | The list of the names of the current internal affiliations of the researcher | |
| Has Current External Organizations | Indicates if the researcher has current external organizations | |
| Has Current Internal Organizations | Indicates if the researcher has current internal organizations | |
| Has Proxy | Indicates if the researcher has a proxy | |
| Has Public Profile | Indicates if the researcher has a public profile | |
| Honors | The honors of the researcher | |
| Include in Smart Harvesting | Indicates if the researcher is included in the Smart Harvesting process | |
| Internal Researcher ID | The internal ID of the researcher | |
| Investigator Role | The role of the investigator | |
| Is Proxy | Indicates if the researcher is a proxy | |
| Keywords | The keywords of the researcher | |
| Languages | The languages of the researcher | |
| Research Topics | The research topics of the researcher | |
| Researcher Name | The full name of the researcher | |
| Researcher First Name | The first name of the researcher | |
| Researcher Last Name | The last name of the researcher | |
| Researcher Middle Name | The middle name of the researcher | |
| Researcher Suffix | The name suffix of the researcher | |
| Researcher Type | The type of the researcher | |
| Researcher Position | The position of the researcher | |
| Researcher Create Date | The creation date of the researcher | |
| Researcher Creator | The user who created the researcher | |
| Researcher Modification Date | The modification date of the researcher | |
| Researcher Modified By | The user who modified the researcher | |
| Profile URL Identifier | The URL identifier of the profile | |
| Web Page URLs | The Web page URLs of the researcher |
Asset Details
Asset Details is a dimension table that stores details about assets.
| Field | Description | Additional Information |
|---|---|---|
| Asset Category | The asset category | |
| Asset Type | The asset type | |
|
Asset Subtype |
The asset subtype
|
|
| Asset Input Method | The asset input method | Example Values:
|
| Asset Created By | The user who created the asset | |
| Asset Modified By | The user who modified the asset | |
| Asset Input Status | The asset's status (for example: approved or draft) | |
| Audience | The audience of the asset | |
| Bibliography | Indicates if the asset has a bibliography | |
| Display in Portal | Indicates if the asset is displayed in the Research Portal | |
| Display in Profile | Indicates if the asset is displayed in the Researcher Profile | |
| Duration | The duration of the asset | |
| Edition | The edition of the asset | For example, book edition. |
| Handle Identifier Status | The handle identifier status of the asset | Possible values: registered / not registered |
| Is Deposit | Indicates if the asset was manually deposited by a researcher or staff member | |
| Journal Title | The title of the journal | |
| Keywords | The keywords of the asset | |
| Languages | The languages of the asset | |
| Open Access Indicator | Indicates if the asset is open access | |
| Pages | The pages of the asset | |
| Peer Reviewed | Indicates if the asset was peer reviewed | |
|
Provenance |
The origin of the asset, where the record came from |
|
| Publication Details | The publication details of the asset | |
| Publisher | The publisher of the asset | |
| Research Topics | The research topics of the asset | |
| Title | The title of the asset | |
| Asset Organizations List | A list of the asset organizations | |
| Asset Authors List | A list of the asset authors | |
| Asset Authors List with Primary Identifier | A list of the asset authors with their primary identifier | |
| Has Attachment | Indicates if the asset has an attachment | |
| Has Files | Indicates if the asset has files | |
| Has Inventory | Indicates if the asset has inventory | |
| Has Links | Indicates if the asset has links | |
| Has Relations | Indicates if the asset has relationships with other assets | |
| Volume | The volume number of the asset | |
| Issue | The issue number of the asset | |
| End Page | The end page of the asset | |
| Start Page | The start page of the asset | |
| Article Number | The article number of the asset | |
| Sub Title | The subtitle of the asset | |
| Publication Place | The publication place of the asset | |
| Format | The format of the asset | |
| Size | The size of the asset | |
| Translated Title | The translated title of the asset | |
| Alternative Title | The alternative title of the asset | |
| Publication Title | The publication title of the asset | |
| NLM Abbreviation | The NLM abbreviation of the asset | |
| Series | The series of the asset | |
| Series Number | The series number of the asset | |
| Comment | Comments of the asset | |
| Copyright Statement | The copyright statement of the asset | |
| Illustrations | The illustrations of the asset | |
| Unpaginated Pages | The unpaginated pages of the asset |
Asset Identifiers
Asset Identifiers is a dimension table that stores details about asset identifiers.
| Field | Description | Additional Information |
|---|---|---|
| Asset ID | The ID of the asset | |
| ARK ID | The ARK ID of the asset | |
| arXiv ID | The arXiv ID of the asset | |
| DOI | The DOI of the asset | |
| Government Document Number | The government document number of the asset | |
| ISBN | The ISBN of the asset | |
| ISMN | The ISMN of the asset | |
| ISSN | The ISSN of the asset | |
| Publication DOI | The Publication DOI of the asset | |
| PMID | The PMID of the asset | |
| PMCID | The PMCID of the asset | |
| Originating System ID | The originating system ID of the asset | |
| Handle Identifier | The handle identifier of the asset | |
| Report Number | The report number of the asset | |
| SICI | The SICI of the asset | |
| WOS ID | The Web of Science ID of the asset | |
| Scopus ID | The Scopus ID of the asset | |
| Additional Identifier 1-9 | Additional Identifiers of the asset 1-9 |
Asset Descriptions
Asset Descriptions is a dimension table that stores details about asset descriptions.
| Field | Description | Additional Information |
|---|---|---|
| Has Abstract | Indicates if the asset has an abstract | |
| Has Audience | Indicates if the asset has an audience description | |
| Has Coverage | Indicates if the asset has coverage metadata | |
| Has Education Level | Indicates if the asset has an educational level description | |
| Has Instructional Method | Indicates if the asset has an instructional method description | |
| Has Methods | Indicates if the asset has method metadata | |
| Has Other Description | Indicates if the asset has other descriptions | |
| Has Spacial Information | Indicates if the asset has spatial information | |
| Has Technical Information | Indicates if the asset has technical information |
Asset Creation Date
Asset Creation Date is a dimension table that stores details about asset creation dates.
| Field | Description | Additional Information |
|---|---|---|
| Asset Creation Date | Stores the date that the asset was created in Esploro in the date format 2/29/2012 | For the date that the asset was created in its original source, use Asset Dates > Asset Created Date |
| Asset 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 |
| Asset Creation Month | Stores the month of the date in month description format such as February | |
| Asset Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Asset Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Asset Creation Year | Stores the year of the date in string format such as 2012 | |
| Asset Creation Year-Month | Stores the year and the month in a format such as 2023-1 |
Asset Modification Date
Asset Modification Date is a dimension table that stores details about asset modification dates.
| Field | Description | Additional Information |
|---|---|---|
| Asset Modification Date | Stores the asset modification date in the date format 2/29/2012 | |
| Asset Modification 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 |
| Asset Modification Month | Stores the month of the date in month description format such as February | |
| Asset Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Asset Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Asset Modification Year | Stores the year of the date in string format such as 2012 | |
| Asset Modification Year-Month | Stores the year and the month in a format such as 2023-1 |
Asset Dates
Asset Dates is a dimension table that stores details about asset dates.
| Field | Description | Additional Information |
|---|---|---|
| Asset Accepted Date | The date on which the asset was accepted | The date as a string and can be partial, such as just the year or just the year and month |
| Asset Accepted Date (Calendar) | The date on which the asset was accepted | 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 |
| Asset Accepted Year | The year in which the asset was accepted | |
| Asset Application Date | The application date for the patent of the asset | |
| Asset Application Year | The application year for the patent of the asset | |
| Asset Approval Date | The date on which the asset was approved | |
| Asset Approval Year | The year in which the asset was approved | |
| Asset Available Date | The date on which the asset was made available | The date as a string and can be partial, such as just the year or just the year and month |
| Asset Available Date (Calendar) | The date on which the asset was made available | 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 |
| Asset Available Year | The year in which the asset was made available | |
| Asset Collected Date | The date on which the asset was collected | |
| Asset Collected Year | The year in which the asset was collected | |
| Asset Copyrighted Date | The copyright date of the asset | |
| Asset Copyrighted Year | The copyright year of the asset | |
| Asset Created Date | The date on which the asset was created in its original source. | For the date that the asset was created in Esploro, use Asset Creation Date > Asset Creation Date |
| Asset Created Year | The year in which the asset was created | |
| Asset Defense Date | The date the asset was defended | |
| Asset Defense Year | The year the asset was defended | |
| Asset Degree Date | The date of the degree of the asset | The date as a string and can be partial, such as just the year or just the year and month |
| Asset Degree Date (Calendar) | The date of the degree of the asset | 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 |
| Asset Degree Season | The season of the asset degree | |
| Asset Degree Season Code | The season code of the asset degree | |
| Asset Degree Year | The year of the asset degree | |
| Asset Epublished Date | The date on which the asset was epublished | The date as a string and can be partial, such as just the year or just the year and month |
| Asset Epublished Date (Calendar) | The date on which the asset was epublished | 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 |
| Asset Epublished Year | The year in which the asset was epublished | |
| Asset Issued Date | The date on which the asset was issued | |
| Asset Issued Year | The year in which the asset was issued | |
| Asset Opening Date | The date on which the asset was opened | |
| Asset Opening Year | The year in which the asset was opened | |
| Asset Performance Date | The performance date of the asset | |
| Asset Performance Year | The performance year of the asset | |
| Asset Posted Date | The date on which the asset was posted | |
| Asset Posted Year | The year in which the asset was posted | |
| Asset Presented Date | The date on which the asset was presented | |
| Asset Presented Year | The year the asset was presented | |
| Asset Published Date | The date on which the asset was published | The date as a string and can be partial, such as just the year or just the year and month |
| Asset Published Date (Calendar) | The date on which the asset was published | 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 |
| Asset Published Season | The season in which the asset was published | |
| Asset Published Season Code | The code of the season in which the asset was published | |
| Asset Published Year | The year the asset was published | |
| Asset Renewed Date | The date on which the asset was renewed | |
| Asset Renewed Year | The year the asset was renewed | |
| Asset Submitted Date | The date the asset was submitted | |
| Asset Submitted Year | The year the asset was submitted | |
| Asset Updated Date | The date on which the asset was updated | |
| Asset Updated Year | The year in which the asset was updated | |
| Asset Valid Date | The valid date of the asset | |
| Asset Valid Year | The valid year of the asset |
Asset License
Asset License is a dimension table that stores details about asset licenses.
| Field | Description | Additional Information |
|---|---|---|
| Asset License Name | The name of the license associated with the asset | |
| Asset License Code | The code of the license associated with the asset | |
| Asset License Description | The description of the license associated with the asset | |
| Asset License URL | The URL of the license associated with the asset | |
| Asset Categories | The categories of the license associated with the asset | |
| Display in Researcher Profile | Indicates if the asset license is displayed in Researcher Profile |
Asset Access Rights
Asset Access Rights is a dimension table that stores details about asset access rights.
| Field | Description | Additional Information |
|---|---|---|
| Asset Policy Name | The name of the access right policy associated with the asset | |
| Asset Policy Description | The description of the access right policy associated with the asset | |
| Asset Policy Creation Date | The creation date of the access right policy associated with the asset | |
| Asset Policy Created By | The user who created the access right policy associated with the asset | |
| Asset Policy Modification Date | The date the access right policy associated with the asset was modified | |
| Asset Policy Modified By | The user who modified the access right policy associated with the asset | |
| Asset Policy Denied Note | The denied note of the access right policy associated with the asset | |
| Asset Embargo Expiry Date | The date the embargo on the asset expires |
Asset Conference/Event
Asset Conference/Event is a dimension table that stores details about conferences and events with which the asset is associated.
| Field | Description | Additional Information |
|---|---|---|
|
Conference/Event Date |
The conference or event date |
|
|
Conference/Event Location |
The conference or event location |
|
|
Conference/Event Name |
The conference or event name |
|
|
Conference Event Number |
The conference or event number |
|
|
Event Type |
The type of event |
Asset Patent
Asset Patent is a dimension table that stores details that are specific to the patents of the assets.
| Field | Description | Additional Information |
|---|---|---|
| Patent Status | The status of the patent | |
|
Patent Number |
The patent's number |
|
| Patent Number Abbreviation | The abbreviation number for the patent | |
| Patent Kind Code | The kind of patent code | |
| Patent Application Code | The patent application code | |
| Patent Application Number | The patent application number | |
| Patent Agency | The agency that issued the patent | |
| Government Documents Number | The number of the government document for the patent |
Asset ETD Details
Asset ETD Details is a dimension table that stores details related to electronic thesis dissertation details.
| Field | Description | Additional Information |
|---|---|---|
| Awarding Academic Unit | The awarding academic unit | |
| Degree Awarded | The degree awarded | |
| ETD Author Degree Grantor | The ETD author degree grantor | |
| Primary Thesis Topic | The primary thesis topic | |
| Degree In | What the degree is in | |
| Secondary Thesis Topic | The secondary thesis topic | |
| ETD Author Email | The ETD author email | |
| Project Type | The project type |
Asset Local Fields
Asset Local Fields is a dimension table that stores details related to the local fields of the asset.
| Field | Description | Additional Information |
|---|---|---|
| Local Field 01-15 | The local fields of the asset | For each local field, the label that you configure appears for the field name. For more information, see Configuring Local Asset Fields. |
Asset Spatial Details
Asset Spatial Details is a dimension table that stores details related to the spatial location of the asset.
| Field | Description | Additional Information |
|---|---|---|
| Spatial Address | The spatial address | |
| Spatial Box | The spatial box information | |
| Spatial Point | The spatial point information |
Asset Teaching and Learning
Asset Teaching and Learning is a dimension table that stores details related to assets used for teaching and learning.
| Field | Description | Additional Information |
|---|---|---|
| Mobile Compatibility | Indicates if the asset is mobile compatible | |
| Source code availability | Indicates if the asset source code is available | |
| Typical learning time | The typical learning time expected for the teaching material’s audience | |
| Course name | The course name to which the asset relates | |
| Course number | The course number to which the asset relates |