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

    Esploro Research Grants

    Analytics
    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_grants_star_diagram.png
    Esploro Research Grants – Star Diagram

    Field Descriptions

    The following lists the fields available in Esploro Research Grants.
    esploro_research_grants_field_descriptions.png
    Esploro Research Grants Field Descriptions

    Grant Measures

    Grant Measures is a fact table that stores measures relating to grants.
    Grant Measures
    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.
    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:
    • From the loader
    • Manually added to Esploro
    • Added during an asset deposit
    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.
    Grant Creation Date
    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.
    Grant Modification Date
    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.
    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.
    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.
    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.
    Grant Funder Agency
    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.

    Grant Related Organizations
    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.
    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.
    Asset Details
    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:
    • Mediated deposit
    • Direct deposit
    • Import profile
    • Smart Harvesting
    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.
    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.
    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.
    Asset Creation Date
    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.
    Asset Modification Date
    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.
    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.
    Asset License
    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.
    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.
    Asset Conference
    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.

    Asset Relations
    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.
    Asset ETD 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.
    Asset Local Fields
    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.
    Asset Spatial Details
    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.
    Asset 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  

    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?