Data Feeds Folder

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

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.

Data Feeds Folder

In this Article