This article will cover the available Data Feeds reports in the Data Library Catalog.
In this Article
Data Feeds Folder
Account Level All Scenarios
Details for all accounts in open and closed scenarios, including alternative and competitive scenarios, of opportunities.
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. |
Active Deposit Accounts
Details for all active deposit accounts in PrecisionLender.
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 Commercial Loan Accounts
Details for all active commercial loan accounts in PrecisionLender.
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 Consumer Loan Accounts
Shows information for all active consumer loan accounts in PrecisionLender.
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.
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.
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. |
Caps and Floors Impact
Details on the impact of caps and floors for every account associated with a PrecisionLender pipeline scenario of an opportunity.
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. |
Login Usage
Login history and security profile for all PrecisionLender users.
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.
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. |
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. |
Opportunity Save History
History of every time an opportunity was saved within the PrecisionLender Application.
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.
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.
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. |