Esploro Researchers
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
Field Descriptions
The following lists the fields available in Esploro Researchers.
Esploro Researchers Field Descriptions
Researchers Measures
Researchers Measures is a fact table that stores measures relating to researchers.
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.
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 last 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.
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.
Field | Description | Additional Information |
---|---|---|
arXiv | The researcher arXiv ID | |
eRA | The researcher eRA ID | |
ISNI | The researcher ISNI ID | |
LCNAF | The researcher LCNAF ID | |
ORCID | The researcher ORCID | |
Other ID | An alternative ID of the researcher | |
Pivot | The researcher Pivot ID | |
Pubmed | The researcher Pubmed ID | |
Researcher ID | The researcher ID | |
Scopus | The researcher Scopus ID | |
VIAF | The researcher VIAF ID | |
Wikidata | The researcher Wikidata ID |
User Details
User Details is a dimension table that stores details about users.
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.
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.
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 Notes
Researcher Notes is a dimension table that stores details about the notes on the researcher.
Field | Description | Additional Information |
---|---|---|
Created By | The user who created the note | |
Created Date | The date the note was created | |
Note Text | The text of the note | |
Note Type | The note type that the user selects when adding the note. | The values of this field are configurable. The available values out-of-the-box are:
For more information, see Managing Researcher Note Types. |
Researcher ORCID Profile
Researcher ORCID Profile is a dimension table that stores details about the ORCHID of assets.
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 | 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.
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.
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.
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.
Field | Description | Additional Information |
---|---|---|
Author Affiliated/Non-Affiliated | The data indicating if the author is affiliated or not affiliated | |
Author Affiliation #1-5 (in Asset) | The author affiliations while creating or contributing to the asset, recorded in the asset | |
Author Affiliation Country #1-5 (in Asset) | The author affiliation country of the author affiliations of an asset of the corresponding Author Affiliation (in Asset) #1-5 field | |
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.
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.
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 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.
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.
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.
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 | |
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.
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 |
Author Identifiers
Author Identifiers is a dimension table that displays details about author identifiers.
Field | Description | Additional Information |
---|---|---|
Author arXiv | The arXiv ID of the author | |
Author eRA | The eRA ID of the author | |
Author ISNI | The ISNI ID of the author | |
Author LCNAF | The LCNAF ID of the author | |
Author ORCID | The ORCID of the author | |
Author Other ID | The Other ID of the author | |
Author Pivot | The Pivot ID of the author | |
Author Pubmed | The Pubmed ID of the author | |
Author Researcher ID | The Researcher ID of the author | |
Author Scopus | The Scopus ID of the author | |
Author VIAF | The VIAF ID of the author | |
Author Wikidata | The Wikidata ID of the author |
Deposit Details
Deposit Details is a dimension table that stores details about deposits.
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 |
Deposit Acceptance Policy
Deposit Acceptance Policy is a dimension table that stores details about the 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.
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.
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.
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 |