Overview
Data Studio is a highly scalable and managed data lake with a large volume and wide variety of PrecisionLender generated historical, time series data. The data lake is a data storage repository that enables analytics and coaching insights. The datasets can be accessed via the Data Studio API.
Provider
Refers to the source provider of the data.
- PL_Analytics: Refers to datasets sourced from Market Insights in the PrecisionLender Application.
- PL_Andi: Refers to raw datasets sourced from Andi in the PrecisionLender Application.
- PL_Application: Refers to raw datasets sourced from the PrecisionLender Application.
- PL_RelationshipAwareness: Refers to raw datasets sourced from Relationship Awareness (RA).
Dataset Group
Each Dataset Group represents a set of datasets related to a common, shared entity. Select a dataset group below to view its respective datasets and providers.
Dataset Name
Refers to the name of the dataset.
Time Series Type
There are two categories for the time series nature of the data in PrecisionLender Data Studio:
-
Snapshot: Datasets contain the state of all relevant records as of the date and time corresponding to the time-based partition.
- Snapshot datasets are well suited for pulling state information at a given point in time.
- Snapshot datasets will have duplicate records per distinct keys over the time-based partition.
-
Incremental: Datasets contain records that were added or modified on the date and time corresponding to the time-based partition.
- Incremental datasets are well suited for pulling changes over time.
- Incremental datasets do not have duplicate records per distinct keys over time-based partition.
Note: Please refer to this article for best practices on using the dataset versions.
Core
This group contains datasets related to the accounts from your bank's core system.
Provider: PL_RelationshipAwareness
Description
This dataset contains details associated with every core account over time. Each core account is associated with both FTP and strategic financial statements for every valid run of Relationship Awareness (RA).
Time Series Type
- Snapshot
Primary Key
A unique record for the dataset can be generated with the following combination of fields:
- RaRunId
- CoreAccountId
- FinancialStatementTypeEnum
Time-based Partition
- DatePartition
Schema
| Field Name | Data Type | Description |
| RaRunId | GUID | The unique identifier for the Relationship Awareness (RA) run. |
| CoreAccountId | GUID | The unique PrecisionLender identifier for the account. |
| ExternalIdentifier | string | The hashed representation of the unique record identifier provided in RA data files. |
| AccountType | string | The type of account. |
| FinancialStatementTypeEnum | int | The enumerator for the financial statement used in calculations. |
| FinancialStatementType | string | The type of financial statement corresponding with the enumerator used in calculations. |
| ProductFamilyId | GUID | The unique identifier for the family of the product associated with the account. |
| ProductName | string | The name of the product associated with the account. |
| PaymentTypeEnum | int | The enumerator for the payment type associated with a loan account. |
| PaymentType | string | The payment type corresponding with the enumerator associated with a loan account. |
| RateTypeEnum | int | The enumerator for the rate type associated with a loan account. |
| RateType | string | The rate type corresponding with the enumerator associated with a loan account. |
| RiskRatingId | GUID | The unique identifier of the risk rating for a loan account. |
| RiskRating | string | The risk rating for a loan account. |
| NaicsCode | string | The industry classification of the borrower associated with the account. |
| PostalCode | string | The zip code of the borrower associated with the account. |
| CountryCode | string | The code indicating the country of account origination. |
| Percentile | long | The percentile of the relationship based on the strategic profitability within the bank. |
| OwnerPercentile | long | The percentile of the relationship based on the strategic profitability within the banker's portfolio. |
| RegionalPercentile | long | The percentile of the relationship based on the strategic profitability within the banker's home region. |
| OwnerId | GUID | The owner of the account. |
| TopLevelParent | GUID | The highest level relationship identifier for the account. |
| RelationshipId | GUID | The unique identifier for the relationship associated with the account. |
| RelationshipExternalIdentifier | string | The hashed representation of the unique record relationship identifier provided in RA data files. |
| CoreRelationshipName | string | The name of the relationship associated with the account. |
| InterestIncome | double | The effective interest income for a deposit or loan account. |
| InterestExpense | double | The effective interest expense for a deposit or loan account. |
| NetInterestIncome | double | The effective net interest income for a deposit or loan account. |
| NonInterestExpense | double | The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account. |
| LoanLossReserve | double | The annualized expected loss for a loan account. |
| OtherIncome | double | The income generated from other fee-based accounts. |
| PreTaxIncome | double | The pretax income for the account. |
| Taxes | double | The effective tax amount for the account. |
| NetIncome | double | The net income for the account. |
| AverageAssets | double | The effective average annualized assets. |
| AverageEquity | double | The effective average annualized equity (allocated capital). |
| AverageLiabilities | double | The effective average annualized liabilities. |
| ROE | double | The return on equity of the account. |
| ROA | double | The return on assets of the account. |
| TargetROE | double | The target return on equity for the account. |
| CapFloorImpact | double | The impact of a cap and floor on the loan account. |
| LoanAmount | double | The balance of a loan account at origination. |
| LoanBalance | double | The average loan balance calculated over the specified horizon. For most accounts, the specified horizon is the lifetime of the loan account. |
| LoanCommitment | double | The commitment of a loan account. |
| LoanNetFunding | double | The loan gross funding less any paid-off balances. |
| DepositAverageBalance | double | The average balance of a deposit account. |
| LoanNetCommitment | double | The total commitment of a loan, minus any previous commitments made to this relationship that are being paid off with a new loan (if present). |
| OtherEarningsCreditEligibleRevenue | double | The revenues eligible for earnings credit from a other fee-based accounts. |
| OtherEarningsCreditIneligibleRevenue | double | The revenues ineligible for earnings credit from other fee-based accounts. |
| OtherGrossRevenue | double | The revenues generated by an other account, net of any servicing costs. |
|
OtherAccountRevenueEarnings... ...CreditGenerated |
double | The total amount from earnings credit generated by an other fee-based account. |
| OtherAppliedEarningsCredit | double | The amount applied to a deposit account to offset activity-based charges. |
| OtherNetRevenue | double | The revenues generated by an other account, net of any applied earnings credits. |
| OtherServicingExpense | double | The additional servicing expenses associated with a loan account. |
| AverageRegulatoryCapital | double | The average regulatory capital held for a loan account. |
| AverageEconomicCapital | double | The average economic capital held for a loan account. |
| RORC | double | The return on regulatory capital. |
| ROEC | double | The return on economic capital. |
|
AverageMaximumOfRegulatory... ...AndEconomic |
double | The average maximum of the regulatory and economic capital held for a loan account. |
| ROMCE | double | The return on the average maximum of regulatory and economic capital. |
| EarningsOnCapital | double | The earnings on the capital held for a loan account. |
| Revenue | double | The reported revenue for the account. |
| ActualLife | int | The projected actual life of a loan account based on the term of the loan adjusted for any prepayments. |
| TopLevelParent_ROA | double | The ROA for the TopLevelParent of the relationship associated with the account. |
| TopLevelParent_ROE | double | The ROE for the TopLevelParent of the relationship associated with the account. |
Description
This dataset contains all core deposit accounts that were active for a given run of Relationship Awareness (RA). There is only one observation recorded per calendar month (on the last day). The selected RA run will be the RA run on or most recently prior to the 5th day of the following month. For example, for the date 2023-01-01 (Jan 1, 2023), the last RA run prior to Feb 5, 2023 will be used for that observation.
Time Series Type
- Snapshot Monthly
Primary Key
- CoreAccountId
- DatePartition
Time-based Partition
- DatePartition
Description
This dataset contains all core loan accounts that were active for a given run of Relationship Awareness (RA). There is only one observation recorded per calendar month (on the last day). The selected RA run will be the RA run on or most recently prior to the 5th day of the following month. For example, for the date 2023-01-01 (Jan 1, 2023), the last RA run prior to Feb 5, 2023 will be used for that observation.
Time Series Type
- Snapshot Monthly
Primary Key
- CoreAccountId
- DatePartition
Time-based Partition
- DatePartition
Description
This dataset contains all core other accounts that were active for a given run of Relationship Awareness (RA). There is only one observation recorded per calendar month (on the last day). The selected RA run will be the RA run on or most recently prior to the 5th day of the following month. For example, for the date 2023-01-01 (Jan 1, 2023), the last RA run prior to Feb 5, 2023 will be used for that observation.
Time Series Type
- Snapshot Monthly
Primary Key
- CoreAccountId
- DatePartition
Time-based Partition
- DatePartition
Description
This dataset contains all core treasury accounts that were active for a given run of Relationship Awareness (RA). There is only one observation recorded per calendar month (on the last day). The selected RA run will be the RA run on or most recently prior to the 5th day of the following month. For example, for the date 2023-01-01 (Jan 1, 2023), the last RA run prior to Feb 5, 2023 will be used for that observation.
Note: Data will only be available to clients who are subscribed to Premium Treasury Pricing.
Time Series Type
- Snapshot Monthly
Primary Key
- CoreAccountId
- DatePartition
Time-based Partition
- DatePartition
Opportunities
This group contains datasets related to opportunities priced in the PrecisionLender application.
Provider: PL_Application
Description
Details for all accounts in open and closed scenarios, including alternative and competitive scenarios, of opportunities.
Time Series Type
- Incremental
Primary Key
- OpportunityId
- ScenarioId
- AccountId
- DatePartition
Time-based Partition
- DatePartition
Relationships
The group contains datasets related to the relationships from your bank's core system.
Provider: PL_RelationshipAwareness
Description
This dataset contains all relationships that were active for a given run of Relationship Awareness (RA). Every record in the dataset represents a single, unique relationship. There is only one observation recorded per calendar month (on the last day). The selected RA run will be the RA run on or most recently prior to the 5th day of the following month. For example, for the date 2023-01-01 (Jan 1, 2023), the last RA run prior to Feb 5, 2023 will be used for that observation.
Time Series Type
- Snapshot Monthly
Primary Key
A unique record for the dataset can be generated with the following combination of fields:
- RelationshipId
- DatePartition
Time-based Partition
- DatePartition
Telemetry
This group contains datasets related to user interactions with Andi skills during opportunity pricing.
Provider: PL_Andi
Description
This dataset is an aggregation of the Engagement Events Derived Dataset at the skill level to give a month-to-date view of what skills were loaded, viewed, clicked, etc. and by how many many users, and distinct users. The dataset stored on the last day of the month will be the totals for the whole month, the dataset stored every day leading up to the last day will be the "month to date" totals.
Time Series Type
- Month to date snapshot
Primary Key
The unique identifier for this dataset:
- SkillPackageId
Time-based Partition
- DatePartition
Users
This group contains datasets related to the users of the PrecisionLender application at your bank.
Provider: PL_Application
Description
This dataset contains a record of every unique login to the PrecisionLender Application.
Time Series Type
- Incremental
Primary Key
A unique record for the dataset can be generated with the following combination of fields:
- LoginId
Time-based Partition
- DatePartition