This article will cover the available reports in the L3 Library Catalog.

 

In this Article

 

Data Feeds Folder

 

Account Level All Scenarios

Shows information for all accounts in all open scenarios and and also for closed opportunities scenarios saved within the last 30 days.

Account Level All Scenarios
Field Name Data Type Description
Opportunity Id guid The unique PrecisionLender identifier for the opportunity.
Opportunity Name string The name of the opportunity
Scenario Id guid The unique PrecisionLender identifier for the scenario.
Scenario Name string The user input name of the scenario
Scenario Type string The type of Scenario, one of Pipeline, Competative, or Alternative
Relationship Name string The name of the relationship
Pricing Date date The date the opportunity was priced
Close Date date The date the opportunity closes
Region string The region of the opportunity
Owner string The owner of the opportunity
Stage Name string The stage of the opportunity
Stage Probability string The probability the opportunity will close given its stage
Opportunity Target ROE double The target ROE for the opportunity
Opportunity ROE double The actual ROE for the opportunity (Net Income / Average Equity)
Opportunity ROA double The actual ROA for the opportunity (Net Income / Average Balance)
Opportunity Net Income double The income on the opportunity after all non-interest income/expenses and taxes are considered.
Opportunity Net Interest Income double The calculation of Interest Income less Interest Expense.
Opportunity Pretax Income double The income on the opportunity prior to taxes
Opportunity Average Balance double The average balance over all accounts across the opportunity
Opportunity Gross Funding double The total funding on the opportunity
Opportunity Net Funding double The gross funding across all loans on the opportunity less any paid-off balances. It reflects the net amount disbursed at closing and the net asset growth of the Loan Account(s).
Opportunity Net Commitment double The commitment on the opportunity less any payoffs
Created Date datetime The datetime the opportunity was created
Last Modified datetime The datetime the opportunity was last modified
Target ROE double The target ROE for the account
ROE double The actual ROE for the account (Net Income / Average Equity)
ROA double The actual ROA for the account (Net Income / Average Balance)
Net Income double The income on the account after all non-interest income/expenses and taxes are considered
Net Interest Income double The calculation of Interest Income less Interest Expense.
Non-Interest Expense double The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
Pretax Income double The pretax income for the account
Loan Loss Reserve double The annualized expected loss for the loan
Average Equity double The effective average annualized equity (allocated capital)
Interest Income double The effective interest income for a deposit or loan account
Interest Expense double The effective interest expense for a deposit or loan account
Product Name string The name of the product associated with the account
Loan Amount double The balance of the loan at origination
Loan Average Balance double The average balance of the account
Loan Participations double The total amount of the account sold to other banks.
Loan Gross Funding double The total funding for the loan
Loan Payoff Renewals double The total amount of the account that is being paid off or renewed.
Loan Net Funding double The loan gross funding less any paid off balances
Loan Net Commitment 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).
Deposit Amount double The average balance for a deposit account
Other Amount double The average balance for a other account
Initial Rate double The interest rate on a loan at the time of origination
Rate Type string The type of rate on the loan (Fixed, Float, Adjustable)
Spread double The spread from the index rate to the current rate charged on a loan
Adjustable Rate Initial Period int The initial fixed period in months for an adjustable rate loan
Adjustable Rate Adjustment Frequency int The frequency in months at which adjustable rates are reset
Cap Floor Impact double The impact of cap and floor on the loan account
Index string The name of the index of the loan
Maturity int The maturity of the loan account in months
Amortization Period int The amortization term of the loan account in months
Annual Fee double The annual fee on a loan
Initial Fee Percent Of Amount double The initial fee as a percent of the loan amount
Initial Fee Dollar Amount double The initial fee as a dollar amount
Origination Channel string The origination channel of the account.
Servicing Channel string The servicing channel of the account.
Risk Rating string The risk rating for a loan account
Competitors string Competitor listed under competitive scenario
Officer Codes string The officer code of the user
Notes string The users notes on the opportuntiy
Facility Rating string The facility rating on the account
Account Id guid The unique precisionlender identifier for the account
Account Type string The type of the account
Short Code string A unique identifier for a commercial loan account that can be associated with a booked loan in Relationship Awareness (RA).

 

Active Deposit Accounts

Shows information for all active deposit accounts in PrecisionLender.

Field Names
Account Id Product Family Id Strategic Deposit Average Balance
Masked Account Id Relationship Id  
Account Last Modified Masked Relationship Id FTP Interest Income
Account Notes Relationship Name FTP Interest Expense
Account Status Relationship Owner Full Name FTP Net Interest Income
Account CD Term Relationship Owner Region Name FTP Non Interest Expense
Account CD Origination Date Strategic Interest Income FTP Loan Loss Reserve
Account Balance Strategic Interest Income FTP Other Income
Account Rate Strategic Net Interest Expense FTP Pre Tax Income
Account Average Balance Strategic Non Interest Expense FTP Taxes
Account Average Rate Strategic Other Income FTP Net Income
Account Net Deposit FTP Rate Strategic Pre-Tax Income FTP Average Assets
Account Gross Deposit FTP Rate Strategic Taxes FTP Average Equity
Account Owner Full Name Strategic Net Income FTP Average Liabilities
Account Owner Region Name Strategic Average Assets FTP ROE
Product Annual Fee Income Strategic Average Equity FTP ROA
Product Annual Fee Income Percent Strategic Average Liabilities FTP Target ROE
Product Annual Operating Expense Percent Strategic ROE FTP Cap Floor Impact
Product Deposit Type Strategic ROA FTP Average Economic Capital
Product Duration

Strategic Target ROE

FTP Average Regulatory Capital
Product Float And Reserves Strategic Average Economic Capital FTP Deposit Average Balance
Product Transfer Rate Strategic Average Regulatory Capital  
Product Target ROE    
Product Capital Allocation Product Generation Effective Date  
Last Refresh Date    

 

Active Loan Accounts

Shows information for all active commercial loan accounts in PrecisionLender.

Field Names
Account Id Account Next Adjustment Date Strategic Loan Commitment
Masked Account Id Account Avg FTP Over Remaining Loan Life Strategic Loan Net Funding
Account Owner Full Name Account Avg FTP Over Current Repricing Period  
Account Owner Region Name Account Avg FTP Over Loan Life Strategic Loan Net Commitment
Account Notes Account Initial Rate
Strategic Average Regulatory Capital
Account Status Origination Channel
Strategic Average Economic Capital
Account Name Servicing Channel FTP Interest Income
Account Type Risk Rating  
Account Amount Product Name FTP Interest Expense
Account Balance Product Family ID FTP Net Interest Income
Account Payment Product Generation Effective Date FTP Non Interest Expense
Account Rate Relationship Id FTP Loan Loss Reserve
Account Payment Type Masked Relationship Id FTP Other Income
Account Payment Frequency Relationship Owner Full Name FTP Pre Tax Income
Account Interest Rate Calculation Relationship Owner Region Name FTP Taxes
Account Remaining Amortization Term Strategic Interest Income FTP Net Income
Account Remaining Expected Life Strategic Interest Expense FTP Average Assets
Account Remaining Maturity Strategic Net Interest Income FTP Average Equity
Account Rate Type Strategic Non Interest Expense FTP Average Liabilities
Account Adjustable Rate Initial Period Strategic Loan Loss Reserve FTP ROE
Account Adjustable Rate Adjustment Frequency Strategic Other Income FTP ROA
Account Adjustable Rate Index Rate Strategic Pre Tax Income FTP Target ROE
Account Adjustable Rate Spread Strategic Taxes FTP Cap Floor Impact
Account Fees Annual Dollars Strategic Net Income FTP Loan Amount
Account Origination Date Strategic Average Assets FTP Loan Balance
Account Fees Unused LOC Strategic Average Equity FTP Loan Commitment
Account Average Balance Strategic Average Liabilities FTP Loan Net Funding
Account Average Rate Strategic ROE FTP Loan Net Commitment
Account Payoff Expected Date Strategic ROA FTP Average Regulatory Capital
Account Tax Exemption Option Strategic Target ROE FTP Average Economic Capital
Account FTP Cost Of Funds Strategic Cap Floor Impact Facility Rating
Account Maturity Date Strategic Loan Amount Short Code
Account Remaining Adjustable Rate Fixed Period Strategic Loan Balance Last Refresh Date

 

Active Other Accounts

Shows information for all active other accounts in PrecisionLender.

Field Names
Account Id Product Family Id Strategic Average Assets
Masked Account Id Product Generation Effective Date Strategic Average Equity
Account Owner Full Name Relationship Id Strategic Average Liabilities
Account Owner Region Name Masked Relationship Id Strategic ROE
Account Notes Relationship Name Strategic ROA
Account Balance Strategic Average Economic Capital Strategic Target ROE
Account Average Pre Tax Income Strategic Average Regulatory Capital  
Account Average Balance Strategic Other Income  
Last Refresh Date Strategic Pre Tax Income  
Product Target ROE Strategic Taxes  
Product Capital Allocation Strategic Net Income  
Product Name    
Relationship Owner Full Name    
Relationship Owner Region Name    

 

All Opportunities - Account Level

Shows information for all accounts in open opportunities and also for closed opportunities saved within the last 30 days.

Field Names
Opportunity Id   Initial Rate
Opportunity Name Target ROE Rate Type
Active Scenario ROE Spread
Relationship Name ROA Adjustable Rate Initial Period
Pricing Date Net Income
Adjustable Rate Adjustment Frequency
Close Date Net Interest Income Index
Region Non Interest Expense Maturity
Owner PreTax Income Amortization Period
Stage Name Loan Loss Reserve Annual Fee
Stage Probability Average Equity Initial Fee Percent Of Amount
Opportunity Target ROE Interest Income Initial Fee Dollar Amount
Opportunity ROE Interest Expense Origination Channel
Opportunity ROA Product Name Servicing Channel
Opportunity Net Income Loan Amount Risk Rating
Opportunity Net Interest Income Loan Average Balance Competitors
Opportunity PreTax Income Loan Participations Officer Codes
Opportunity Average Balance Loan Gross Funding Notes
Opportunity Gross Funding Loan Payoff Renewals Facility Rating
Opportunity Net Funding Loan Net Funding Account Id
Opportunity Net Commitment Loan Net Commitment Short Code
Created Date Deposit Amount Other Amount
Last Modified Cap Floor Impact Account Type

 

Caps and Floors Impact

Shows the impact of caps and floors for each account associated with a PrecisionLender opportunity saved in the past 30 days.

Field Names
Opportunity Name Product Name Pricing Date
Owner Close Date Cap Floor Impact
Short Code    

 

Login Usage

Shows the login history and security profile of each user.

Field Names
User Name Last Login Logins 31-60 days
Full Name Exempt from IP filter Logins 61-90 days
Region Name Logins Total  Logins YTD 
Security Profile Logins 30 Days  

 

Opportunities

Shows information for all open and closed opportunities in PrecisionLender.

Field Names
Opportunity Id Pipeline Scenario Non Interest Expense
Opportunity Net Income Loan Loss Reserve
Relationship Net Income Target Pre-Tax Income
Pricing Date Net Income Delta Other Income
Close Date ROE Taxes
Stage Target ROE Region
Status ROE Delta Last Modified
Owner Loan Only ROE Notes
Loan Amount Loan Only Target ROE Short Code
Average Equity ROA Officer Codes
Loan Balance Interest Income Relationship Strategic ROE
Deposit Balance Interest Expense  
Average Assets Net Interest Income  

 

Opportunity Save History

Shows the history of saves for each Opportunity Id.

Opportunity Save History
Field Name Data Type Description
Opportunity Id guid The unique PrecisionLender identifier for the opportunity.
Opportunity Name string The name of the opportunity.
Opportunity Created timestamp The date this opportunity was created.
Owner Name string The full name of the owner of the account.
Owner Username string The email address of the owner of the account.
Stage Name string The stage of the opportunity.
Region Name string The name of the Bank region for the loan.
Days Since Last Save int Number of days since that Opportunity Id has been edited.
Opportunity Status string The status of the prior opportunity stage.
Current Stage Name string The current stage of the opportunity.
Current Status string The current status of the opportunity stage.
Current Close Date string The close date of this opportunity in the current stage.
Prior Close Date timestamp The close date of this opportunity in the prior stage.
Stage Changed By Username string The email address of the user that made the change.
Stage Changed By User string The full name of the user that made the change.
Last Modified timestamp The date this opportunity was last modified.
Short Code timestamp
A unique identifier for a commercial loan account that can be associated with a booked loan in Relationship Awareness (RA).

 

Relationship Owner Match Audit

Reports what Relationships have mismatched owners in the bank's system versus the PL system.

Relationship Owner Match Audit
Field Name Data Type Description
Relationship Name string Name of the top level parent relationship.
Core Relationship Name string Name of the child relationship. If relationship is not a child, this field will match Relationship Name.
Owner Name string The full name of the relationship manager in PL's system.
Core Owner Name string The full name of the relationship manager in the bank's system.
Merged Relationship string
Whether or not a relationship has been merged with other relationships. A relationship that is a parent, or has parents, is considered merged.
Masked External Identifier string The unique relationship id for the account level relationship, masked for security and privacy.

 

Relationships

Shows aggregated financial data for top level parent relationships.

Relationships
Field Name Data Type Description
Parent Relationship Id string The highest level relationship identifier in the relationship hierarchy.
Relationship Name string Name of the relationship.
Owner string The full name of the relationship manager.
Bank Percentile string The percentile of the relationship based on the strategic profitability within the bank.
Owner Percentile string
The percentile of the relationship based on the strategic profitability within the banker's portfolio.
Region Percentile string
The percentile of the relationship based on the strategic profitability within the banker's home region.
Total Strategic Net Income string The stategic value of the net income of the relationship.
Total Strategic ROE string The strategic value of the return on equity of the relationship.
Total FTP Net Income string The FTP value of the net income of the relationship.
Total FTP ROE string The FTP value of the return on equity of the relationship.
Loan Commitment string The sum of the loan commitments of the relationship.
Average Loan Balance string The current balance of the loan account.
Average Deposit Balance string The average balance of the deposit balance of the relationship.
Current Commercial Loan Balance double Sum of the current commercial loan balances for all accounts belonging to a child relationship
Current Deposit Balance double Sum of the current deposit balances for all accounts belonging to a child relationship
Current Other Fee Income string Only applicable to Other Fee-based Accounts, otherwise zero.
Core Loan Accounts Interest Income string Total loan interest income.
Core Deposit Accounts Interest Income string Total deposit interest income.
Core Other Accounts Interest Income string Total other interest income.
Region Name string Name of relationship manager's region.
Last Modified string Date of last modification of parent relationship.

Back to Top

 

Market Insights Folder

Note: Market Insights is a premium service for clients. If you are interested in adding Market Insights for your organization, please reach out to our support team at support@precisionlender.com.

Opportunity Market Report

Shows market quartiles and loan percentiles for eligible loan accounts in active pipeline scenarios of opportunities.

Opportunity Market Report
Field Name Data Type Description
Opportunity Id guid The unique PrecisionLender identifier for the opportunity.
Account Id guid The unique PrecisionLender identifier for the account.
Last Modified date The date the opportunity containing the account was last saved.
Opportunity Stage Name string The name of the bank assigned stage.
Relationship string The name of the associated business relationship.
Region Name string The name of the Bank region for the loan.
Product Name string The name of the product associated with the loan.
Owner Full Name string The full name of the account owner.
Owner Email string The Email of the account owner
Tax Exemption Option string The tax exemption option on an account, if applicable.
Risk Rating string The risk rating for a loan account.
Amount float The balance of a loan account at origination.
Rate Type string The rate type associated with the loan.
Rate float The total Interest rate on the loan at the time of pricing.
Spread Over Index float The spread from the index rate to the total interest rate charged on a loan at pricing.
Index Rate float The rate of the index used as of the pricing date.
Index Name string The name of the index used.
Performance Band string The regional performance grouping for a particular type of loan.
Market Available string The Indicator for whether a market of comparable loans exists for a given loan.
Market Availability Reason string If a market does not exist, the reason why no comparable market exists for a given loan.
Market Percentile Of Loan float The market percentile of the loan
Market Rate 25th Percentile float The interest rate at the 25th percentile of the market for a given loan
Market Rate 50th Percentile float The interest rate at the 50th percentile of the market for a given loan
Market Rate 75th Percentile float The interest rate at the 75th percentile of the market for a given loan
Available Recommendations int The number of unique recommendations Market Insights had for the loan.
Viewed Recommendations int The number of unique Market Insights recommendations viewed by the user on the loan.
Executed Recommendations int
The sum of executedRecommendationsManualEntry and executedRecommendationsSkillClick.
Executed Recommendations Manual Entry int
The number of unique recommendations viewed by the user and then acted upon by changing the rate within 33% of the recommended amount.
Executed Recommendations Skill Click int
The number of unique recommendations viewed by the user and then acted upon by clicking the Andi skill.

 

 

Portfolio Market Report

Captures the number of unique Market Insights skill engagements for each account on a single day. This report uses Relationship Awareness (RA) data.

Portfolio Market Report
Field Name Data Type Description
Account Id GUID The unique PrecisionLender identifier for the account.
Owner Full Name string The full name of the account owner.
Owner Email string The Email of the account owner
Relationship string The name of the associated business relationship.
Region Name string The name of the Bank region for the loan.
Product Name string The name of the product associated with the loan.
Origination Date date The date of loan origination
Tax Exemption Option string The tax exemption option on an account, if applicable.
Risk Rating string The risk rating for a loan account.
Maturity Date date The date of loan maturity
Amount float The balance of a loan account at origination.
Balance float The current balance of the loan
Average Balance float The average balance of the loan over the life of the loan
Rate Type string The rate type associated with the loan.
Rate float The total Interest rate on the loan at the time of pricing.
Adjustable Rate Spread float The spread from the index rate to the current rate charged on a loan.
Adjustable Rate Index Rate float The current value of the underlying index rate of the loan.
Performance Band string The regional performance grouping for a particular type of loan.
Market Available string The Indicator for whether a market of comparable loans exists for a given loan.
Market Availability Reason string
If a market does not exist, the reason why no comparable market exists for a given loan.
Market Percentile Of Loan float The market percentile of the loan
Market Rate 25th Percentile float The interest rate at the 25th percentile of the market for a given loan
Market Rate 50th Percentile float The interest rate at the 50th percentile of the market for a given loan
Market Rate 75th Percentile float The interest rate at the 75th percentile of the market for a given loan

Back to Top

 

Portfolio Insights Folder

 

Credit Migration Matrix

Matrix of transition in credit ratings for all client loans over 1 year period.

Credit Migration Matrix
Field Name Data Type Description
NULL string Row labels (AAA - CCC/C) for risk of default rating at beginning of 1 year period.
AAA float Proportion of loans with initial rating matching row name and final rating AAA.
AA+ float Proportion of loans with initial rating matching row name and final rating AA+.
AA float Proportion of loans with initial rating matching row name and final rating AA.
AA- float Proportion of loans with initial rating matching row name and final rating AA-.
A+ float Proportion of loans with initial rating matching row name and final rating A+.
A float Proportion of loans with initial rating matching row name and final rating A.
A- float Proportion of loans with initial rating matching row name and final rating A-.
BBB+ float Proportion of loans with initial rating matching row name and final rating BBB+.
BBB float Proportion of loans with initial rating matching row name and final rating BBB.
BBB- float Proportion of loans with initial rating matching row name and final rating BBB-.
BB+ float Proportion of loans with initial rating matching row name and final rating BB+.
BB float Proportion of loans with initial rating matching row name and final rating BB.
BB- float Proportion of loans with initial rating matching row name and final rating BB-.
B+ float Proportion of loans with initial rating matching row name and final rating B+.
B float Proportion of loans with initial rating matching row name and final rating B.
B- float Proportion of loans with initial rating matching row name and final rating B-.
CCC/C float Proportion of loans with initial rating matching row name and final rating CCC/C.
Paid float Proportion of loans with initial rating matching row name which were paid off within 1 year.
Unknown float Proportion of loans with initial rating matching row name with unknown status after 1 year.
Default float Proportion of loans with initial rating matching row name which defaulted within 1 year.

 

Relationship Deposit Anomalies

Highlights anomalous depletion of deposits for most recent Relationship Awareness (RA) run date at the relationship level.

Relationship Deposit Anomalies
Field Name Data Type Description
Owner Id GUID The unique user id of the relationship manager.
Owner Full Name string The full name of the relationship manager.
Owner Email string The email address of the relationship manager.
Relationship External Identifier GUID The unique relationship id for the account level relationship.
Relationship Name string Name of the relationship.
Current Deposit Balance double Current deposit balance for all accounts tied to the relationship.
Previous Deposit Balance double Previous deposit balance for all accounts tied to the relationship.
Change In Deposit Balance double Change in total deposit balance since last Relationship Awareness (RA) run date.
Percent Change integer Percent change in total Deposit balance.
3 Month Average Balance double
Average total deposit balance for all accounts 3 months prior to current Relationship Awareness (RA) run date.
12 Month Average Balance double
Average total deposit balance for all accounts 12 months prior to current Relationship Awareness (RA) run date.
Anomaly Score double Statistical indicator of anomalous activity: 0-10 (i.e. 10 being extremely unusual).
Anomaly Ranking By Owner integer Anomaly Ranking for all of an owner's relationships.
Days To Depletion integer Predicted number of days until total deposit balances is $0 at current draw down rate.
Data as of Relationship Awareness run on date Date of Relationship Awareness run used (RA) for calculation of the anomalies.

 

Relationship LOC Anomalies

Highlights anomalous usage of Lines of Credit for most recent Relationship Awareness (RA) run date at the relationship level.

Relationship LOC Anomalies
Field Name Data Type Description
Owner Id GUID The unique user id of the relationship manager.
Owner Full Name string The full name of the relationship manager.
Owner Email string The email address of the relationship manager.
Relationship External Identifier GUID The unique relationship id for the account level relationship.
Relationship Name string Name of the relationship.
Current Utilization int Current utilization over all accounts tied to the relationship.
Previous Utilization int Previous utilization over all accounts tied to the relationship
Current LOC Balance double Current LOC balance for all accounts tied to the relationship.
Previous LOC Balance double Previous LOC balance for all accounts tied to the relationship.
Change In LOC Balance double Change in total LOC balance since last Relationship Awareness (RA) run date.
Current LOC Commitment double Current Commitment over all LOC accounts tied to the relationship
Previous LOC Commitmnet double Previous Commitment over all LOC accounts tied to the relationship
3 Month Average Balance double Average total LOC balance for all accounts 3 months prior to current Relationship Awareness (RA) run date.
12 Month Average Balance double
Average total LOC open balance for all accounts 12 months prior to current Relationship Awareness (RA) run date.
Percent Change integer Percent change in total LOC open balance since last Relationship Awareness (RA) run date.
Anomaly Score double Statistical indicator of anomalous activity: 0-10 (i.e. 10 being extremely unusual).
Anomaly Ranking By Owner integer Anomaly Ranking for all of an owner's relationships.
Current Date date Date of Relationship Awareness run used (RA) for detection of the anomalies.
Previous Date date Date of Relationship Awareness run prior to detection of the anomalies

 

 

Renewals

Renewals of Line of Credit and Letter of Credit core accounts maturing within the next 90 days.

Renewals
Field Name Data Type Description
DatePartition integer The date the dataset was generated in YYYYMMDD format.
CoreAccountId GUID The unique PrecisionLender identifier for the account.
DaysToMaturity integer The number of days until the account reaches maturity.
MaturityDate date The date the account reaches maturity.
Maturity integer The maturity of the loan account in months.
AmortizationTerm integer The amortization term of the loan account in months.
OwnerFullName string The name of the owner of the account.
OwnerEmail string The email of the owner of the account.
RelationshipName string The name of the relationship associated with the account.
ProductName string The name of the product associated with the account.
Commitment double The commitment of the loan account.
Balance dobule The current balance of the account.
NetIncome double The net income of the account.
ROE double The return on equity of the account.
Relationship_NetIncome double The NetIncome of the relationship associated with the account.
Relationship_ROE double The ROE of the relationship associated with the account.

Back to Top