Data Feeds Folder

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

Data Feeds Folder

Account Level All Scenarios

Details for all accounts in open and closed scenarios, including alternative and competitive scenarios, of opportunities.

Note: Opportunities saved prior to November 2019 may be missing data for the following fields:

Raw Interest Expense
Funded Liquidity Premium
Unfunded Liquidity Premium

To view the data on the reports, please open the opportunity and re-save it.

Account Level All Scenarios

Field Name	Data Type	Description
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 an account that can be associated with a booked account in Relationship Awareness (RA).
Product Name	string	The name of the product associated with the account.
Payment Type	string	The payment type associated with the loan
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, Competitive, or Alternative.
Relationship Id	guid	The unique precisionlender identifier for the relationship.
Relationship Name	string	The name of the relationship.
Region Id	guid	The unique precisionlender identifier for the region
Region	string	The region of the opportunity.
Owner Id	guid	The unique precisionlender identifier for the owner
Owner	string	The owner of the opportunity.
Created Date	datetime	The date the opportunity was created .
Pricing Date	date	The date the opportunity was priced.
Close Date	date	The projected close date of the opportunity.
Last Modified	datetime	The datetime the opportunity was last saved.
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 Return on Equity (ROE) for the opportunity.
Opportunity ROE	double	The actual Return on Equity (ROE) for the opportunity.
Opportunity ROA	double	The actual Return on Assets (ROA) for the opportunity.
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 pretax income for the opportunity.
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.
Target ROE	double	The target Return on Equity (ROE) for the account.
ROE	double	The actual Return on Equity (ROE) for the account.
ROA	double	The actual Return on Assets (ROA) for the account.
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.
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 institutions.
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).
Effective LTV	double	The effective loan-to-value of the loan account.
Collateral Effective Value	double	The value of the collateral considering prior liens and the recovery factor.
Deposit Amount	double	The average balance for a deposit account.
Other Amount	double	The average balance for an account of type 'other'.
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.
Maximum Rate Floor	double	The maximum contracted rate floor over the life of the loan.
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.
Origination Channel Expense	string	The total origination expense of the account.
Servicing Channel	string	The servicing channel of the account.
Servicing Channel Expense	string	The annual servicing expense of the account.
Risk Rating	string	The risk rating for a loan account.
Facility Rating	string	The facility rating on the account.
Competitors	string	Competitor listed under competitive scenario.
Officer Codes	string	The officer code of the user.
Notes	string	Users' notes on the opportunity.
Stage Status	string	The opportunity stage status: Open, ClosedWon, ClosedLost, AwaitingApproval, AwaitingClose, or Testing.
Average Regulatory Capital	double	The average regulatory capital for the account.
Average Economic Capital	double	The average economic capital for the account.
RORC	double	The return on regulatory capital for the account.
ROEC	double	The return on economic capital for the account.
Loss Given Default Method	string	The method used to calculate Loss Given Default for a given product type.
Loan To Value Percent	double	The loan-to-value ratio associated with a facility rating, under the Loss Given Default Method of Facility Ratings with LTV and Guarantor.
Relationship FTP ROE If We Win	double	Estimated FTP Return on Equity on the Relationship if the opportunity is won
Relationship Strategic ROE If We Win	double	Estimated Strategic Return on Equity on the Relationship if the opportunity is won
Relationship FTP ROE If We Lose	double	Estimated ROE on the relationship if opportunities are lost
Relationship Strategic ROE If We Lose	double	Estimated ROE on the relationship if opportunities are lost
Fixed Rate Lock	string	Description of the type of rate lock (Spread Locked, 30 Day Lock, 60 Day Lock etc...) Null if Rate Lock is NA
Rate Lock Expiration Date	date	Date of rate lock expiration = Pricing Date + Fixed Rate Lock field
Pricing Region	string	The region in which an opportunity is priced.
Raw Interest Expense	float	Raw Interest Expense is the cost associated with funding the loan (prior to any liquidity premiums).
Funded Liquidity Premium	float	The Funded Liquidity Premium is the cost associated with any Liquidity Adjustments.
Unfunded Liquidity Premium	float	The Unfunded Liquidity Premium is the cost associated with being committed to the full amount of a line of credit that isn't fully drawn.
Other Expense	double	The sum of all client configurable expenses for that account.

Active Deposit Accounts

Details for all active deposit accounts in PrecisionLender.

Active Deposit Accounts

Field Name	Data Type	Description
Last Refresh Date	date	The last date PrecisionLender received data for the account from the bank.
Product Name	string	The name of the product.
Product Family Id	guid	The unique identifier for the product family.
Core Account Id	guid	The unique PrecisionLender identifier for the account.
External Account Id	guid	The unique bank identifier for the account.
Masked External Account Id	guid	The masked bank identifier for the account.
Short Code	string	A unique identifier for an account that can be associated with a booked account in Relationship Awareness (RA).
Account Type	string	The type of loan account.
Relationship Id	guid	The unique precisionlender identifier for the relationship associated with the loan.
External Relationship Id	guid	The unique bank identifier for the relationship associated with the loan.
Masked External Relationship Id	guid	The masked bank identifier for the relationship associated with the loan.
Relationship Name	string	The name of the relationship associated with the loan.
Relationship Owner Full Name	string	The name of the relationship owner.
Relationship Owner Region Name	string	The region associated with the relationship owner.
Owner Full Name	string	The name of the account owner.
Owner Region Name	string	The region associated with the account owner.
CD Term	int	The length of the CD term in months if applicable.
CD Origination Date	date	The origination date of the CD if applicable.
Balance	double	The current deposit balance.
Rate	double	The interest rate on the deposit accout.
Average Balance	double	The average balance in the deposit account.
Average Rate	double	The average rate on the deposit account.
Net Deposit FTP Rate	double	The effective FTP rate for the deposit account.
Gross Deposit FTP Rate	double	The gross transfer rate used.
Product Annual Fee Income	double	The annual fee income based on the product settings.
Product Annual Fee Income Percent	double	The annual fee income for this product, expressed as a percent.
Product Annual Operating Expense Percent	double	The annual operating expense based on the product settings.
Product Deposit Type	double	The type of deposit account.
Product Duration	int	The duration of the product.
Product Float And Reserves	double	The float and reserves for this product
Product Transfer Rate	double	The transfer rate for the product.
Product Target ROE	double	The target ROE based on the product settings.
Product Capital Allocation	double	The capital allocation for the product.
Strategic Interest Income	double	The effective interest income for a deposit or loan account.
Strategic Interest Expense	double	The effective interest expense for a deposit or loan account.
Strategic Net Interest Income	double	The effective net interest income for a deposit or loan account.
Strategic Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
Strategic Pre Tax Income	double	The pretax income for the account.
Strategic Taxes	double	The effective tax amount for the account.
Strategic Net Income	double	The net income for the account.
Strategic Average Assets	double	The effective average annualized assets.
Strategic Average Equity	double	The effective average annualized equity (allocated capital).
Strategic Average Liabilities	double	The effective average annualized liabilities.
Strategic ROE	double	The return on equity of the account.
Strategic ROA	double	The return on assets of the account.
Strategic Target ROE	double	The target return on equity for the account.
Strategic Deposit Average Balance	double	The average balance of a deposit account.
Strategic Average Regulatory Capital	double	The average regulatory capital held for a loan account.
Strategic Average Economic Capital	double	The average economic capital held for a loan account.
FTP Interest Income	double	The effective interest income for a deposit or loan account.
FTP Interest Expense	double	The effective interest expense for a deposit or loan account.
FTP Net Interest Income	double	The effective net interest income for a deposit or loan account.
FTP Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
FTP Pre Tax Income	double	The pretax income for the account.
FTP Taxes	double	The effective tax amount for the account.
FTP Net Income	double	The net income for the account.
FTP Average Assets	double	The effective average annualized assets.
FTP Average Equity	double	The effective average annualized equity (allocated capital).
FTP Average Liabilities	double	The effective average annualized liabilities.
FTP ROE	double	The return on equity of the account.
FTP ROA	double	The return on assets of the account.
FTP Target ROE	double	The target return on equity for the account.
FTP Deposit Average Balance	double	The average balance of a deposit account.
FTP Average Regulatory Capital	double	The average regulatory capital held for a loan account.
FTP Average Economic Capital	double	The average economic capital held for a loan account.
TopLevelParent	guid	The highest level relationship identifier in the relationship hierarchy that contains the relationship in the RelationshipId field.

Active Commercial Loan Accounts

Details for all active commercial loan accounts in PrecisionLender.

Active Loan Accounts

Field Name	Data Type	Description
Last Refresh Date	date	The last date precisionlender received data for the account from the bank.
Product Name	string	The name of the product.
Product Family Id	guid	The unique identifier for the product family.
Core Account Id	guid	The unique precisionlender identifier for the account.
External Account Id	guid	The unique bank identifier for the account.
Masked External Account Id	guid	The masked bank identifier for the account.
Short Code	string	A unique identifier for an account that can be associated with a booked account in Relationship Awareness (RA).
Account Type	string	The type of loan account.
Origination Date	datetime	The origination date of the loan.
Maturity Date	datetime	The Maturity date of the loan.
Payoff Expected Date	datetime	The expected payoff date of the loan.
Relationship Id	guid	The unique precisionlender identifier for the relationship associated with the loan.
External Relationship Id	guid	The unique bank identifier for the relationship associated with the loan.
Masked External Relationship Id	guid	The masked bank identifier for the relationship associated with the loan.
Relationship Name	string	The name of the relationship associated with the loan.
Relationship Owner Full Name	string	The name of the relationship owner.
Relationship Owner Region Name	string	The region associated with the relationship owner.
Owner Full Name	string	The name of the account owner.
Owner Region Name	string	The region associated with the account owner.
Status	string	The status of the loan (Active).
Name	string	The name given to the loan.
Origination Channel	string	The origination channel of the loan.
Servicing Channel	string	Ther servicing channel of the loan.
Risk Rating	string	The risk rating of the loan.
Facility Rating	string	The facility rating of the loan.
Amount	double	The total loan amount.
Balance	double	The current loan balance.
Payment	double	The loan payment.
Rate	double	The interest rate on the loan.
Payment Type	string	The payment type associated with the loan.
Payment Frequency	string	The frequency of the loan payments.
Interest Rate Calculation	string	The method used to calculate the interest rate.
Remaining Amortization Term	int	Remaining amortization period in months.
Remaining Expected Life	int	Remaining expected loan life in months.
Remaining Maturity	int	Remaining maturity in months.
Rate Type	string	The type of interest rate on the loan.
Initial Rate	double	The initial interest rate.
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.
Remaining Adjustable Rate Fixed Period	int	The remaining period until the next rate adjustment.
Next Adjustment Date	datetime	The date if the next rate adjustment.
Adjustable Rate Index Rate	double	The rate of the base index.
Adjustable Rate Spread	double	The spread from the index rate to the current rate charged on a loan.
Fees Annual Dollars	double	The annual fees collected.
Fees Unused LOC	double	The fees on the unused portion of an LOC.
Average Balance	double	The average balance of the loan.
Average Rate	double	The average interest rate on the loan.
Tax Exemption Option	string	The tax exemption option on the loan if applicable.
FTP Cost Of Funds	double
Average FTP Over Remaining Loan Life	double
Average FTP Over Current Repricing Period	double
Average FTP Over Loan Life	double
Strategic Interest Income	double	The effective interest income for a deposit or loan account.
Strategic Interest Expense	double	The effective interest expense for a deposit or loan account.
Strategic Net Interest Income	double	The effective net interest income for a deposit or loan account.
Strategic Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
Strategic Loan Loss Reserve	double	The annualized expected loss for a loan account.
Strategic Pre Tax Income	double	The pretax income for the account.
Strategic Taxes	double	The effective tax amount for the account.
Strategic Net Income	double	The net income for the account.
Strategic Average Assets	double	The effective average annualized assets.
Strategic Average Equity	double	The effective average annualized equity (allocated capital).
Strategic Average Liabilities	double	The effective average annualized liabilities.
Strategic ROE	double	The return on equity of the account.
Strategic ROA	double	The return on assets of the account.
Strategic Target ROE	double	The target return on equity for the account.
Strategic Cap Floor Impact	double	The impact of a cap and floor on the loan account.
Strategic Loan Amount	double	The balance of a loan account at origination.
Strategic Loan Balance	double	The average loan balance calculated over the specified horizon. For most accounts, the specified horizon is the lifetime of the loan account.
Strategic Loan Commitment	double	The commitment of a loan account.
Strategic Loan Net Funding	double	The loan gross funding less any paid-off balances.
Strategic 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).
Strategic Average Regulatory Capital	double	The average regulatory capital held for a loan account.
Strategic Average Economic Capital	double	The average economic capital held for a loan account.
FTP Interest Income	double	The effective interest income for a deposit or loan account.
FTP Interest Expense	double	The effective interest expense for a deposit or loan account.
FTP Net Interest Income	double	The effective net interest income for a deposit or loan account.
FTP Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
FTP Loan Loss Reserve	double	The annualized expected loss for a loan account.
FTP Pre Tax Income	double	The pretax income for the account.
FTP Taxes	double	The effective tax amount for the account.
FTP Net Income	double	The net income for the account.
FTP Average Assets	double	The effective average annualized assets.
FTP Average Equity	double	The effective average annualized equity (allocated capital).
FTP Average Liabilities	double	The effective average annualized liabilities.
FTP ROE	double	The return on equity of the account.
FTP ROA	double	The return on assets of the account.
FTP Target ROE	double	The target return on equity for the account.
FTP Cap Floor Impact	double	The impact of a cap and floor on the loan account.
FTP Loan Amount	double	The balance of a loan account at origination.
FTP Loan Balance	double	The average loan balance calculated over the specified horizon. For most accounts, the specified horizon is the lifetime of the loan account.
FTP Loan Commitment	double	The commitment of a loan account.
FTP Loan Net Funding	double	The loan gross funding less any paid-off balances.
FTP 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).
FTP Average Regulatory Capital	double	The average regulatory capital held for a loan account.
FTP Average Economic Capital	double	The average economic capital held for a loan account.
TopLevelParent	guid	The highest level relationship identifier in the relationship hierarchy that contains the relationship in the RelationshipId field.
Strategic Annualized Origination Expenses	double	Annualized origination expenses
Strategic Annualized Origination Fees	double	Annualized origination fees
Ftp Annualized Origination Expenses	double	Annualized origination expenses
Ftp Annualized Origination Fees	double	Annualized origination fees

Active Consumer Loan Accounts

Shows information for all active consumer loan accounts in PrecisionLender.

Active Consumer Loan Accounts

Field Name	Data Type	Description
Last Refresh Date	date	The last date precisionlender received data for the account from the bank.
Product Name	string	The name of the product.
Product Family Id	guid	The unique identifier for the product family.
Core Account Id	guid	The unique precisionlender identifier for the account.
External Account Id	guid	The unique bank identifier for the account.
Masked External Account Id	guid	The masked bank identifier for the account.
Short Code	string	A unique identifier for an account that can be associated with a booked account in Relationship Awareness (RA).
Account Type	string	The type of loan account.
Origination Date	datetime	The origination date of the loan.
Maturity Date	datetime	The Maturity date of the loan.
Payoff Expected Date	datetime	The expected payoff date of the loan.
Relationship Id	guid	The unique precisionlender identifier for the relationship associated with the loan.
External Relationship Id	guid	The unique bank identifier for the relationship associated with the loan.
Masked External Relationship Id	guid	The masked bank identifier for the relationship associated with the loan.
Relationship Name	string	The name of the relationship associated with the loan.
Relationship Owner Full Name	string	The name of the relationship owner.
Relationship Owner Region Name	string	The region associated with the relationship owner.
Owner Full Name	string	The name of the account owner.
Owner Region Name	string	The region associated with the account owner.
Status	string	The status of the loan (Active).
Name	string	The name given to the loan.
Origination Channel	string	The origination channel of the loan.
Servicing Channel	string	Ther servicing channel of the loan.
Risk Rating	string	The risk rating of the loan.
Facility Rating	string	The facility rating of the loan.
Amount	double	The total loan amount.
Balance	double	The current loan balance.
Payment	double	The loan payment.
Rate	double	The interest rate on the loan.
Payment Type	string	The payment type associated with the loan.
Payment Frequency	string	The frequency of the loan payments.
Interest Rate Calculation	string	The method used to calculate the interest rate.
Remaining Amortization Term	int	Remaining amortization period in months.
Remaining Expected Life	int	Remaining expected loan life in months.
Remaining Maturity	int	Remaining maturity in months.
Rate Type	string	The type of interest rate on the loan.
Initial Rate	double	The initial interest rate.
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.
Remaining Adjustable Rate Fixed Period	int	The remaining period until the next rate adjustment.
Next Adjustment Date	datetime	The date if the next rate adjustment.
Adjustable Rate Index Rate	double	The rate of the base index.
Adjustable Rate Spread	double	The spread from the index rate to the current rate charged on a loan.
Fees Annual Dollars	double	The annual fees collected.
Fees Unused LOC	double	The fees on the unused portion of an LOC.
Average Balance	double	The average balance of the loan.
Average Rate	double	The average interest rate on the loan.
Tax Exemption Option	string	The tax exemption option on the loan if applicable.
FTP Cost Of Funds	double
Average FTP Over Remaining Loan Life	double
Average FTP Over Current Repricing Period	double
Average FTP Over Loan Life	double
Strategic Interest Income	double	The effective interest income for a deposit or loan account.
Strategic Interest Expense	double	The effective interest expense for a deposit or loan account.
Strategic Net Interest Income	double	The effective net interest income for a deposit or loan account.
Strategic Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
Strategic Loan Loss Reserve	double	The annualized expected loss for a loan account.
Strategic Pre Tax Income	double	The pretax income for the account.
Strategic Taxes	double	The effective tax amount for the account.
Strategic Net Income	double	The net income for the account.
Strategic Average Assets	double	The effective average annualized assets.
Strategic Average Equity	double	The effective average annualized equity (allocated capital).
Strategic Average Liabilities	double	The effective average annualized liabilities.
Strategic ROE	double	The return on equity of the account.
Strategic ROA	double	The return on assets of the account.
Strategic Target ROE	double	The target return on equity for the account.
Strategic Cap Floor Impact	double	The impact of a cap and floor on the loan account.
Strategic Loan Amount	double	The balance of a loan account at origination.
Strategic Loan Balance	double	The average loan balance calculated over the specified horizon. For most accounts, the specified horizon is the lifetime of the loan account.
Strategic Loan Commitment	double	The commitment of a loan account.
Strategic Loan Net Funding	double	The loan gross funding less any paid-off balances.
Strategic 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).
Strategic Average Regulatory Capital	double	The average regulatory capital held for a loan account.
Strategic Average Economic Capital	double	The average economic capital held for a loan account.
FTP Interest Income	double	The effective interest income for a deposit or loan account.
FTP Interest Expense	double	The effective interest expense for a deposit or loan account.
FTP Net Interest Income	double	The effective net interest income for a deposit or loan account.
FTP Non Interest Expense	double	The effective non-interest expense or, if negative, the non-interest income for a deposit or loan account.
FTP Loan Loss Reserve	double	The annualized expected loss for a loan account.
FTP Pre Tax Income	double	The pretax income for the account.
FTP Taxes	double	The effective tax amount for the account.
FTP Net Income	double	The net income for the account.
FTP Average Assets	double	The effective average annualized assets.
FTP Average Equity	double	The effective average annualized equity (allocated capital).
FTP Average Liabilities	double	The effective average annualized liabilities.
FTP ROE	double	The return on equity of the account.
FTP ROA	double	The return on assets of the account.
FTP Target ROE	double	The target return on equity for the account.
FTP Cap Floor Impact	double	The impact of a cap and floor on the loan account.
FTP Loan Amount	double	The balance of a loan account at origination.
FTP Loan Balance	double	The average loan balance calculated over the specified horizon. For most accounts, the specified horizon is the lifetime of the loan account.
FTP Loan Commitment	double	The commitment of a loan account.
FTP Loan Net Funding	double	The loan gross funding less any paid-off balances.
FTP 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).
FTP Average Regulatory Capital	double	The average regulatory capital held for a loan account.
FTP Average Economic Capital	double	The average economic capital held for a loan account.
TopLevelParent	guid	The highest level relationship identifier in the relationship hierarchy that contains the relationship in the RelationshipId field.
Strategic Annualized Origination Expenses	double	Annualized origination expenses
Strategic Annualized Origination Fees	double	Annualized origination fees
Ftp Annualized Origination Expenses	double	Annualized origination expenses
Ftp Annualized Origination Fees	double	Annualized origination fees

Active Other Accounts

Details for all active other accounts in PrecisionLender.

Active Other Accounts

Field Name	Data Type	Description
Last Refresh Date	date	The last date precisionlender received data for the account from the bank.
Product Name	string	The name of the product.
Product Family Id	guid	The unique identifier for the product family.
Core Account Id	guid	The unique precisionlender identifier for the account.
External Account Id	guid	The unique bank identifier for the account
Masked External Account Id	guid	The masked bank identifier for the account
Short Code	string	A unique identifier for an account that can be associated with a booked account in Relationship Awareness (RA).
Account Type	string	The type of account
Relationship Id	guid	The unique precisionlender identifier for the relationship associated with the loan.
External Relationship Id	guid	The unique bank identifier for the relationship associated with the loan.
Masked External Relationship Id	guid	The masked bank identifier for the relationship associated with the loan.
Relationship Name	string	The name of the relationship associated with the loan.
Relationship Owner Full Name	string	The name of the relationship owner.
Relationship Owner Region Name	string	The region associated with the relationship owner.
Owner Full Name	string	The name of the account owner.
Owner Region Name	string	The region associated with the account owner.
Balance	double	The current loan balance.
Average Balance	double	The average balance of the loan.
Pre Tax Income	double	The income on the account prior to taxes.
Average Pre Tax Income	double	The average income on the account prior to taxes.
Product Target ROE	double	The target ROE for a particular account, based on the product configuration.
Product Capital Allocation	double	The capital allocation settings for the product.
Strategic Other Income	double	The income generated from other fee-based accounts.
Strategic Other Earnings Credit Eligible Revenue	double	The revenueseligible for earnings credit from a other fee-based accounts.
Strategic Other Earnings Credit Ineligible Revenue	double	The revenues ineligible for earnings credit from other fee-based accounts.
Strategic Other Gross Revenue	double	The revenues generated by an other account, net of any servicing costs.
Strategic Other Account Revenue Earnings Credit Generated	double	The total amount from earnings credit generated by an other fee-based account.
Strategic Other Applied Earnings Credit	double	The amount applied to a deposit account to offset activity-based charges.
Strategic Other Net Revenue	double	The revenues generated by an other account, net of any applied earnings credits.
Strategic Other Servicing Expense	double	The additional servicing expenses associated with a loan account.
Strategic Pre Tax Income	double	The pretax income for the account.
Strategic Taxes	double	The effective tax amount for the account.
Strategic Net Income	double	The net income for the account.
Strategic Average Assets	double	The effective average annualized assets.
Strategic Average Equity	double	The effective average annualized equity (allocated capital).
Strategic Average Liabilities	double	The effective average annualized liabilities.
Strategic ROE	double	The return on equity of the account.
Strategic ROA	double	The return on assets of the account.
Strategic Target ROE	double	The target return on equity for the account.
Strategic Average Regulatory Capital	double	The average regulatory capital held for a loan account.
Strategic Average Economic Capital	double	The average economic capital held for a loan account.
TopLevelParent	guid	The highest level relationship identifier in the relationship hierarchy that contains the relationship in the RelationshipId field.

Account Level Pipeline Scenarios

Details for all accounts in open and closed pipeline scenarios of opportunities.

Note: Opportunities saved prior to November 2019 may be missing data for the following fields:

Raw Interest Expense
Funded Liquidity Premium
Unfunded Liquidity Premium

To view the data on the reports, please open the opportunity and re-save it.

Account Level Pipeline Scenarios

Field Name	Data Type	Description
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 an account that can be associated with a booked account in Relationship Awareness (RA).
Product Name	string	The name of the product associated with the account.
Payment Type	string	The payment type associated with the loan
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, Competitive, or Alternative.
Relationship Id	guid	The unique precisionlender identifier for the relationship.
Relationship Name	string	The name of the relationship.
Region Id	guid	The unique precisionlender identifier for the region
Region	string	The region of the opportunity.
Owner Id	guid	The unique precisionlender identifier for the owner
Owner	string	The owner of the opportunity.
Created Date	datetime	The date the opportunity was created .
Pricing Date	date	The date the opportunity was priced.
Close Date	date	The projected close date of the opportunity.
Last Modified	datetime	The datetime the opportunity was last saved.
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 Return on Equity (ROE) for the opportunity.
Opportunity ROE	double	The actual Return on Equity (ROE) for the opportunity.
Opportunity ROA	double	The actual Return on Assets (ROA) for the opportunity.
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 pretax income for the opportunity.
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.
Target ROE	double	The target Return on Equity (ROE) for the account.
ROE	double	The actual Return on Equity (ROE) for the account.
ROA	double	The actual Return on Assets (ROA) for the account.
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.
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 institutions.
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).
Effective LTV	double	The effective loan-to-value of the loan account.
Collateral Effective Value	double	The value of the collateral considering prior liens and the recovery factor.
Deposit Amount	double	The average balance for a deposit account.
Other Amount	double	The average balance for an account of type 'other'.
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.
Maximum Rate Floor	double	The maximum contracted rate floor over the life of the loan.
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.
Origination Channel Expense	string	The total origination expense of the account.
Servicing Channel	string	The servicing channel of the account.
Servicing Channel Expense	string	The annual servicing expense of the account.
Risk Rating	string	The risk rating for a loan account.
Facility Rating	string	The facility rating on the account.
Competitors	string	Competitor listed under competitive scenario.
Officer Codes	string	The officer code of the user.
Notes	string	Users' notes on the opportunity.
Stage Status	string	The opportunity stage status: Open, ClosedWon, ClosedLost, AwaitingApproval, AwaitingClose, or Testing.
Average Regulatory Capital	double	The average regulatory capital for the account.
Average Economic Capital	double	The average economic capital for the account.
RORC	double	The return on regulatory capital for the account.
ROEC	double	The return on economic capital for the account.
Loss Given Default Method	string	The method used to calculate Loss Given Default for a given product type.
Loan To Value Percent	double	The loan-to-value ratio associated with a facility rating, under the Loss Given Default Method of Facility Ratings with LTV and Guarantor.
Relationship FTP ROE If We Win	double	Estimated ROE on the relationship if opportunities are won
Relationship Strategic ROE If We Win	double	Estimated ROE on the relationship if opportunities are won
Relationship FTP ROE If We Lose	double	Estimated ROE on the relationship if opportunities are lost
Relationship Strategic ROE If We Lose	double	Estimated ROE on the relationship if opportunities are lost
Fixed Rate Lock	string	Description of the type of rate lock (Spread Locked, 30 Day Lock, 60 Day Lock etc...) Null if Rate Lock is NA
Rate Lock Expiration Date	date	Date of rate lock expiration = Pricing Date + Fixed Rate Lock field
Pricing Region	string	The region in which an opportunity is priced.
Raw Interest Expense	float	Raw Interest Expense is the cost associated with funding the loan (prior to any liquidity premiums).
Funded Liquidity Premium	float	The Funded Liquidity Premium is the cost associated with any Liquidity Adjustments.
Unfunded Liquidity Premium	float	The Unfunded Liquidity Premium is the cost associated with being committed to the full amount of a line of credit that isn't fully drawn
Other Expense	double	The sum of all client configurable expenses for that account.

Caps and Floors Impact

Details on the impact of caps and floors for every account associated with a PrecisionLender pipeline scenario of an opportunity.

Caps and Floors Impact

Field Name	Data Type	Description
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 an account that can be associated with a booked account in Relationship Awareness (RA).
Product Name	string	The name of the product associated with the account.
Opportunity Id	guid	The unique PrecisionLender identifier for the opportunity.
Opportunity Name	string	The name of the opportunity.
Owner Id	guid	The unique Precisionlender identifier for the owner.
Owner	string	The owner of the opportunity.
Pricing Date	date	The date the opportunity was priced.
Last Modified	datetime	The datetime the opportunity was last saved.
Close Date	date	The projected close date of the opportunity.
Cap Floor Impact	double	The impact of cap and floor on the loan account.
Maximum Rate Floor	double	The maximum contracted rate floor over the life of the loan.
Stage Name	string	The stage of the opportunity.
Stage Status	string	The opportunity stage status: Open, ClosedWon, ClosedLost, AwaitingApproval, AwaitingClose, or Testing.
Pricing Region	string	The region in which an opportunity is priced.

Delivery to Promise

Connects Opportunities with Promised Deposits to their Relationship's deposit changes during the time following the Opportunity Close Date

For more information on the Delivery to Promise data set, see this article.

Delivery to Promise

Field Name	Data Type	Description
Relationship Name	string	The name of the relationship.
Relationship Owner	string	The full name of the relationship owner
Relationship Owner Region	string	The region of the relationship owner
Deposit Type	string	The deposit product type: one of ZeroInterestDemand, InterestBearingDemand, or TimedDeposit
Last RA Run Date	date	The most recent RA Run Date for this combination of Relationship and Deposit Type
Last Core Balance Per Deposit Type	double	The total deposit value on this relationship for this Deposit Type, as of the Last RA Run Date
Last Core Balance All Deposits	double	The total deposit value on this relationship across all Deposit Types, as of the Last RA Run Date
Opportunity Name	string	The name of the opportunity
Opportunity Owner	string	The full name of the opportunity owner
Opportunity Owner Region	string	The region of the opportunity owner
Opportunity Last Modified	date	The date that the opportunity was last modified in PrecisionLender
Opportunity Close Date	date	The close date of the opportunity
Opp Loan Commitment	double	The total loan commitment on the opportunity
Opp Deposits Promised	double	The total deposit value on this opportunity for this deposit type
Opp Other Income Promised	double	The total other income promised on this opportunity
Opp Deposits Promised All Types	double	The total deposit value on this opportunity across all deposit types
Opportunity ROE	double	The return on equity for the full opportunity
Opportunity Target ROE	double	The target ROE for the full opportunity
Opportunity Average Equity	double	The average equity for the full opportunity
Opportunity Loan Only ROE	double	The ROE for the all the loans on the opportunity
Opportunity Loan Only Target ROE	double	TheTarget ROE across all loans on the opportunity
Opportunity Loan Only Average Equity	double	The average equity across all loans on the opportunity
Relationship Id	guid	The unique PrecisionLender identifier for the relationship.
Opportunity Id	guid	The unique PrecisionLender identifier for the opportunity
Delivery Window Start	date	The date of the first RA Run following the Opportunity Close Date
Starting Balance	double	The relationship deposit balance for this Deposit Type as of the Delivery Window Start
Avg Balance 6	double	Average relationship deposit balance for this Deposit Type during the 6-month Delivery Window
Max Balance 6	double	Maximum relationship deposit balance for this Deposit Type during the 6-month Delivery Window
Ending Balance 6	double	The relationship deposit balance for this Deposit Type as of the Delivery Window End 6
Delivery Window End 6	date	The date of the RA Run closest in time to (but not after) the Opportunity Close Date plus 6 months
Avg Balance 12	double	Average relationship deposit balance for this Deposit Type during the 12-month Delivery Window
Max Balance 12	double	Maximum relationship deposit balance for this Deposit Type during the 12-month Delivery Window
Ending Balance 12	double	The relationship deposit balance for this Deposit Type as of the Delivery Window End 12
Delivery Window End 12	date	The date of the RA Run closest in time to (but not after) the Opportunity Close Date plus 12 months
Avg Balance 24	double	Average relationship deposit balance for this Deposit Type during the 24-month Delivery Window
Max Balance 24	double	Maximum relationship deposit balance for this Deposit Type during the 24-month Delivery Window
Ending Balance 24	double	The relationship deposit balance for this Deposit Type as of the Delivery Window End 24
Delivery Window End 24	date	The date of the RA Run closest in time to (but not after) the Opportunity Close Date plus 24 months
Avg Balance 36	double	Average relationship deposit balance for this Deposit Type during the 36-month Delivery Window
Max Balance 36	double	Maximum relationship deposit balance for this Deposit Type during the 36-month Delivery Window
Ending Balance 36	double	The relationship deposit balance for this Deposit Type as of the Delivery Window End 36
Delivery Window End 36	date	The date of the RA Run closest in time to (but not after) the Opportunity Close Date plus 36 months

Login Usage

Login Usage

Field Name	Data Type	Description
Username	string	The email address of the user.
Full Name	string	The full name of the user.
Region Name	string	The name of the user's region.
Security Profile	string	The name of the security profile.
Last Login	date	The date of the user's last login.
Exempt From IP Filter	string	Indicates if the user is exempt from the IP filter.
Logins Total	long int	Count of total logins between inception and report date.
Logins 30 Days	long int	Count of logins within 30 days of the run date.
Logins 31 to 60 Days	long int	Count of logins between 31 and 60 days prior to report date.
Logins 61 to 90 Days	long int	Count of logins between 61 and 90 days prior to report date.
Logins 91 to 180 Days	long int	Count of logins between 91 and 180 days prior to report date.
Logins YTD	long int	Count of logins since beginning of the year of report date.

Opportunities

Details for all open and closed opportunities in PrecisionLender.

Opportunities

Field Name	Data Type	Description
Opportunity Id	guid	The unique PrecisionLender identifier for the opportunity.
Opportunity Name	string	The name of the opportunity.
Short Code	string	A unique identifier for an account that can be associated with a booked account in Relationship Awareness (RA).
Status	string	The probability the opportunity will close given its stage.
Stage Name	string	The stage of the opportunity.
Pipeline Scenario	string	The name of the pipeline scenario.
Relationship Id	guid	The unique precisionlender identifier for the relationship.
Relationship Name	string	The name of the relationship.
Region Id	guid	The unique precisionlender identifier for the region
Region	string	The region of the opportunity.
Owner Id	guid	The unique precisionlender identifier for the owner
Owner	string	The owner of the opportunity.
Pricing Date	date	The date the opportunity was priced.
Close Date	date	The projected close date of the opportunity.
Last Modified	datetime	The datetime the opportunity was last saved.
Target ROE	double	The target Return on Equity (ROE) for the account.
ROE	double	The actual Return on Equity (ROE) for the account.
ROA	double	The actual Return on Assets (ROA) for the account.
ROE Delta	double	The actual Return on Equity (ROE) for the account.
Loan Only ROE	double	The combined Return On Equity (ROE) of all the loans in the opportunity pipeline scenario
Loan Only Target ROE	double	The combined target Return On Equity (ROE) of all loans in the pipeline scenario of the opportunity
Relationship Strategic ROE	double	The strategic Return on Equity (ROE) of the relationship.
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.
Loan Products	double	The total amount of the account that is being paid off or renewed.
Loan Amount	double	The balance of the loan at origination.
Loan Balance	double	The average balance of the account.
Average Assets	double	The combined average assets of all accounts in the pipeline scenario of the opportunity.
Net Income	double	The income on the account after all non-interest income/expenses and taxes are considered.
Net Income Target	double	The income on the account after all non-interest income/expenses and taxes are considered.
Net Income Delta	double	The income on the account after all non-interest income/expenses and taxes are considered.
Deposit Balance	double	The average balance for a deposit account.
Other Income	double	The average balance for an account of type 'other'.
Taxes	double	Taxes collected on the pre-tax income of all accounts in the pipeline scenario of the opportunity
Officer Codes	string	The officer code of the user.
Notes	string	Users' notes on the opportunity.
Average Regulatory Capital	double	The average regulatory capital for the opportunity.
Average Economic Capital	double	The average economic capital for the opportunity.
RORC	double	The return on regulatory capital for the opportunity.
ROEC	double	The return on economic capital for the opportunity.
Pricing Region	string	The region in which an opportunity is priced.

Opportunity Save History

History of every time an opportunity was saved within the PrecisionLender Application.

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).
Pricing Region	string	The region in which an opportunity is priced.

Relationship Owner Match Audit

Shows instances where the owner of a relationship in the bank's system does not match the owner of an account in PrecisionLender. Also indicates if this is caused by the relationship being merged or not.

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

Aggregated financial information for top level parent relationships.

Relationships

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

Data Feeds Folder

In this Article