Data Feeds Folder

This article will cover the available Data Feeds reports in the L3 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.

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 cost of the origination channel.
Servicing Channel	string	The servicing channel of the account.
Servicing Channel Expense	string	The cost of the servicing channel.
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.

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.

Active 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.

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.

Account Level Pipeline Scenarios

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

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 cost of the origination channel.
Servicing Channel	string	The servicing channel of the account.
Servicing Channel Expense	string	The cost of the servicing channel.
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.

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	Then uniqie 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.

Login Usage

Login Usage

Field Name	Data Type	Description
User Name	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-60 Days	long int	Count of logins between 31 and 60 days prior to report date.
Logins 61-90 Days	long int	Count of logins between 61 and 90 days prior to report date.
Logins 91-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 payment type associated with the loan
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 loan gross funding less any paid off balances.
Loan Only Target ROE	double	The loan gross funding less any paid off balances.
Relationship Strategic ROE	double	The name 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 annual fee on a loan.
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	The target Return on Equity (ROE) for the account.
Officer Codes	string	The officer code of the user.
Notes	string	Users' notes on the opportunity.

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).

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
Parent Relationship Id	string	The highest level relationship identifier in the relationship hierarchy.
Relationship Name	string	Name of the relationship.
Region Id	string	The unique precisionlender identifier for the region.
Region Name	string	Name of relationship manager's region.
Owner Id	string	The unique precisionlender identifier for the owner.
Owner	string	The full name of the relationship manager.
Last Modified	string	Date of last modification of parent relationship.
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 Loan Accounts Interest Expense	string	The effective interest expense for all loan accounts on the relationship.
Core Deposit Accounts Interest Income	string	Total deposit interest income.
Core Deposit Accounts Interest Expense	string	The effective interest expense for all deposit accounts on the relationship.
Core Other Accounts Income	string	Total fee based income for other accounts.
Core Other Accounts Non Interest Expense	string	Total non interest expense for other accounts.

Data Feeds Folder

In this Article