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

    Esploro Researchers

    Analytics
    This subject area is available only for Esploro customers.new
    You can use the fields in the Esploro Researchers subject area to create reports on Researchers by assets details, affiliation organizations, and by affiliation education details and answer the following types of business questions:
    • How many researchers are there with at least one asset of type X?
    • Which researchers had the most assets in the last year, grouped by organization unit?
    • How many researchers deposited assets in the last X days/months/years/since day one?  
    • How many researchers collaborated with researchers from another institution on an asset, grouped by institution and type of asset? 
    • How often do researchers move units?
    esploro_researchers_star_diagram.png
    Esploro Researchers – Star Diagram

    Field Descriptions

    The following lists the fields available in Esploro Researchers.
    esploro_researchers_field_descriptions.png
    Esploro Researchers Field Descriptions

    Researchers Measures

    Researchers Measures is a fact table that stores measures relating to researchers.
    Researchers Measures
    Field Description Additional Information
    Number of Researchers The number of researchers  
    Number of Assets The number of assets  
    Number of Deposits The number of deposits  
    Number of Deposits (Active) The number of active deposits  
    Number of Affiliations The the total number of affiliations, current and previous. Note that only distinct instances are counted.  If the researcher has multiple entries for the same affiliation with different years or roles these are counted as distinct entries only if the year or roles are included in the report.  
    Number of Researchers Affiliated The number of researchers who are affiliated  
    Number of Previous Affiliations The number of researchers who are previously affiliated  
    Number of Current Affiliations The number of researchers who are currently affiliated   
    Number of Researchers Non-Affiliated The number of researchers who are non-affiliated  
    Number of Proxy The number of proxies  

    Researcher Details

    Researcher Details is a dimension table that stores details about researchers.
    Researcher Details
    Field Description Additional Information
    Access to Researcher Profile Indicates if the researcher has access to the researcher profile  
    Affiliated/Non-Affiliated Indicates if the researcher is affiliated  
    Areas of Interest The areas of interest of the researcher  
    Associations The associations of the researcher  
    Current External Organization Affiliations Country This field is for future use  
    Current External Organization Affiliations Names List A list of the current external organization affiliations of the researcher  
    Current Internal Organization Affiliations Names List A list of the current internal organization affiliations of the researcher If an affiliated researcher has no current internal affiliation defined, Esploro Analytics uses the researcher’s institution for this field.
    Display Title The title of the researcher that is displayed in the researcher profile  
    Has Assets Indicates if the researcher has assets  
    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 smart harvesting  
    Internal Researcher ID The internal ID of the researcher  
    Is Proxy Indicates if the researcher is a proxy  
    Is Pushed to ORCID Indicates (Yes/No) if the asset was pushed to ORCID For more information, see ORCID in Esploro.
    Keywords The keywords of the researcher  
    Languages The languages of the of the researcher  
    Name Variants The name variants of the researcher  
    Previous Internal Organization Affiliations Names List A list of the previous internal organization affiliations of the researcher  
    Previously Affiliated Indicates if the researcher was previously affiliated with the institution  
    Profile URL Identifier The URL identifier of the profile  
    Research Topics The research topics of the researcher  
    Researcher Affiliated Primary Identifier The primary identifier of affiliated researchers  
    Researcher Create Date The creation date of the researcher  
    Researcher Creator The creator 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 Modification Date The modification date of the researcher  
    Researcher Modified By The user who modified the researcher  
    Researcher Name The name of the researcher  
    Researcher Non-Affiliated Primary Identifier The primary identifier of non-affiliated researchers  
    Researcher Position The position of the researcher  
    Researcher Suffix The suffix of the researcher  
    Researcher Title The title of the researcher, such as Dr.  
    Researcher Type The type of the researcher  
    Skip Automatic Approvals in Smart Harvesting Indicates (Y/N) if Esploro is configured to skip automatic approvals in Smart Harvesting for the researcher  
    Smart Harvesting Last Running Date The last date that smart harvesting ran  
    Web Page URLs The Web page URLs of the researcher  

    Researcher Engagement Fields

    Researcher Engagement Fields is a dimension table that stores details about which researcher engagement fields are configured and their expiry date.
    Researcher Details
    Field Description Additional Information
    Researcher Engagement Field 1-10 Indicates if the researcher engagement field is configured (Y/N) For each Researcher Engagement field, the label that you configure appears for the field name. For more information, see  Configuring Researcher Engagement Types.
    Researcher Engagement Expiry Date 1-10 The expiry date for the researcher engagement field

    Researcher Identifiers

    Researcher Identifiers is a dimension table that stores details researcher identifiers.
    Researcher Identifiers
    Field Description Additional Information
    arXiv ID The researcher arXiv ID  
    eRA ID The researcher eRA ID  
    ISNI The researcher ISNI  
    LCNAF The researcher LCNAF  
    ORCID The researcher ORCID  
    Pivot ID The researcher Pivot ID  
    Pubmed The researcher Pubmed  
    Author ID The researcher Author ID  
    Researcher ID The researcher Researcher ID  
    Scopus ID The researcher Scopus ID  
    VIAF The researcher VIAF  
    Wikidata ID The researcher Wikidata ID  
    Other An alternative ID of the researcher  

    User Details

    User Details is a dimension table that stores details about users.
    User Details
    Field Description Additional Information
    User City The city of the user  
    User Country The country of the user  
    User Expiry Date The expiry date of the user  
    User Identifier 1-2 The identifiers of the user  
    User Last Activity Date The last date that a patron made a request or borrowed or returned an item  
    User Postal Code The postal code of the user  
    User Preferred Email The preferred email of the user  
    User Preferred Phone Number The preferred phone number of the user  
    User Preferred SMS The preferred SMS of the user  
    User Purge Date The purge date of the user  
    User State Province The state or province of the user  
    User Group The user group of the user  
    User Primary Identifier The primary user identifier  
    User Record Type The record type of the user  
    User Status Indicates if the user is active or not  
    User Title The title of the user  
    User Type The user type of the user  

    Researcher Education Details

    Researcher Education Details is a dimension table that stores details about researcher education.
    Researcher Education Details
    Field Description Additional Information
    Education Institution Code The education institution code  
    Education Institution Name The education institution name  
    Education Institution Country The education institution country  
    Education Studies Title The education studies title  
    Education to Year The end year of the education  
    Education From Year The start year of the education  
    Education Qualification Certificate The education qualification certificate  
    Education Additional Details Additional details of the education  

    Researchers Affiliation Details

    User Details is a dimension table that stores details about researcher affiliations.
    Researchers Affiliation Details
    Field Description Additional Information
    Affiliation Unit Code The unit code of the affiliation  
    Affiliation Unit Name The unit name of the affiliation  
    Affiliation Unit Country The unit country of the affiliation  
    Affiliation Unit Type The unit type of the affiliation  
    Affiliation Parent Unit Code The code of the parent organization with which the researcher is affiliated  
    Affiliation Parent Unit Name The name of the parent organization with which the researcher is affiliated  
    Affiliation Position The position of the affiliation  
    Affiliation Position Title The position title of the affiliation  
    Affiliation End Date The end date of the affiliation  
    Affiliation Start Date The start date of the affiliation  

    Researcher ORCID Profile

    Researcher ORCID Profile is a dimension table that stores details about the ORCHID of assets.
    Researcher ORCID Profile
    Field Description Additional Information
    Esploro Record ID The ID of the record  
    Has ORCID Trust Indicates that the researcher claimed an ORCID profile and created the connection  
    Last ORCID Update The date of the last ORCID update  
    ORCID ID The ORCID ID  
    ORCID Profile Updated Indicates if the ORCID profile was updated  

    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

    This is mainly for data sets, to describe what type.

     
    Asset Input Method The asset input method  
    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 staement 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 WOS 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 Creators and Contributors

    Asset Creators and Contributors is a dimension table that stores details about asset authors.
    Asset Authors
    Field Description Additional Information
    Author Identifiers
    Author arXiv ID The arXiv ID of the author arXiv ID
    Author eRA ID The eRA ID of the author  
    Author ISNI The ISNI of the author  
    Author LCNAF The LCNAF of the author  
    Author ORCID The ORCID of the author  
    Author Other ID The Other ID of the author  
    Author Pivot ID The  Pivot ID of the author  
    Author Pubmed Author ID The Pubmed Author ID of the author  
    Author Researcher ID The Researcher ID of the author  
    Author Scopus ID The Scopus ID of the author  
    Author VIAF The VIAF of the author  
    Author Wikidata ID The Wikidata ID of the author  
    Author Affiliated/Non-Affiliated The data indicating if the author is affiliated or not affiliated  
    Author Affiliation (in Asset) The author affiliation when creating or contributing to the asset, recorded in the asset  
    Author Affiliation Country (in Asset) The author affiliation country when creating or contributing to the asset, recorded in the asset  
    Author Current External Organization Affiliations Country This field is for future use  
    Author Current External Organization Affiliations List The author’s current external organization affiliations list  

    Author Current Internal Organization Affiliations List

    The author’s current internal organization affiliations list

    If an affiliated researcher has no current internal affiliation defined, Esploro Analytics uses the researcher’s institution for this field.
    Author Display in Public Profile Indicates if the asset should appear in the creator’s public profile  
    Author First Name The first name of the author of the asset  
    Author Group The group author or organization name that created or contributed to the asset  
    Author Is Owner Indicates if the creator or contributor of the asset is the owner of the asset  
    Author Last Name The last name of the author of the asset  
    Author Match Status The author matching status of the creator or contributor of the asset  
    Author Middle Name The middle name of the author of the asset  
    Author Name The name of the author of the asset  
    Author Non-Affiliated Primary Identifier The primary identifier of non-affiliated authors  
    Author Order (in Asset) The order of the author as listed in the asset  
    Author Preferred First Name The researcher preferred first name of the creator or contributor  
    Author Preferred Last Name The researcher preferred last name of the creator or contributor  
    Author Preferred Middle Name The researcher preferred middle name of the creator or contributor  
    Author Preferred Name Suffix The researcher preferred name suffix of the creator or contributor  
    Author Previously Affiliated Indicates if the researcher was previously affiliated with the institution  
    Author Affiliated Primary Identifier The primary identifier for the researcher  
    Author Role The author role when creating or contributing to the asset  
    Author Suffix Name The suffix of the name of the author of the asset  
    Author Type The author type: creator or contributor  

    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 asset creation in the date format 2/29/2012  
    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 View Indicates if the asset license is displayed in Researcher View  

    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 Citations Count

    Asset Citations Count is a dimension table that stores details about the number of asset citations per source.
    Asset Citations Count
    Field Description Additional Information
    Citations Count Source The source of the citation count Possible values: Web of Science, Google Scholar, and Microsoft Academics
    Total Citation Count The total citation count for the relevant source  
    Year Of Citations Count The year for which there is a count for the relevant source  
    Yearly Citations Count The citation count for the relevant year  

    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.

    Deposit Details

    Deposit Details is a dimension table that stores details about deposits.
    Deposit Details
    Field Description Additional Information
    Deposit Status The status of the deposit  
    Owner ID The ID of the owner of the deposit  
    Owner First Name The first name of the owner of the deposit  
    Owner Middle Name The middle name of the owner of the deposit  
    Owner Last Name The last name of the owner of the deposit  
    Assigned to ID The ID of the user assigned to the deposit  
    Assign to Name The name of the user assigned to the deposit  

    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  
    Spatial Point The spatial point  

    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  

    Deposit Acceptance Policy

    Deposit Acceptance Policy is a dimension table that stores details about the deposit acceptance policy.
    Deposit Acceptance Policy
    Field Description Additional Information
    Is Policy Accepted Indicates if the Policy is Accepted  
    Policy Name The name of the policy  
    Acceptance Note The policy acceptance note  
    Policy Acceptance Date The policy acceptance date  

    Deposit Acceptance Policy

    Deposit Acceptance Policy is a dimension table that stores details about the deposit acceptance policy.
    Deposit Acceptance Policy
    Field Description Additional Information
    Is Policy Accepted Indicates if the Policy is Accepted  
    Policy Name The name of the policy  
    Acceptance Note The policy acceptance note  
    Policy Acceptance Date The policy acceptance date  

    Deposit Approval Date

    Deposit Approval Date is a dimension table that stores details about the deposit approval date.
    Deposit Approval Date
    Field Description Additional Information
    Deposit Approval Date Stores the date that the deposit was approved in the date format 2/29/2012  
    Deposit Approval Full Month Stores the month and the year of the date in a display format such as Feb 12      
    Deposit Approval Month  Stores the month of the date in month description format such as February  
    Deposit Approval 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
    Deposit Approval Quarter Stores the quarter of the date in a display format such as Q1      
    Deposit Approval Year Stores the year of the date in string format such as 2012  
    Deposit Approval Year-Month Stores the year and the month in a format such as 2023-1  

    Deposit Creation Date

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

    Deposit Modification Date

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

    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?