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

 

In this Article

 

Data Feeds Folder

Reports

____________________________________________________

Active Deposit Accounts

Shows information for all active deposit accounts in PrecisionLender.

Field Names

  • Account Id
  • Masked Account Id
  • Account Last Modified
  • Account Created Account Notes
  • Account Status
  • Account CD Term
  • Account CD Origination Date
  • Account Balance
  • Account Rate
  • Account Average Balance
  • Account Average Rate
  • Account Net Deposit FTP Rate
  • Account Gross Deposit FTP Rate
  • Product Annual Fee Income
  • Product Annual Fee Income Percent
  • Product Annual Operating Expense Percent
  • Product Average Rate Window
  • Product Deposit Type
  • Product Duration
  • Product Float And Reserves
  • Product Transfer Rate
  • Product Target ROE
  • Product Average Balance Window
  • Product Capital Allocation
  • Product Generation Name
  • Product Generation Effective Date
    • Product Family Id
    • Relationship Id
    • Masked Relationship Id
    • Relationship Name
    • Strategic Interest Income
    • Strategic Interest Expense
    • Strategic Net Interest Income
    • Strategic Non Interest Expense
    • Strategic Loan Loss Reserve
    • Strategic Other Income
    • Strategic Pre Tax Income
    • Strategic Taxes
    • Strategic Net Income
    • Strategic Average Assets
    • Strategic Average Equity
    • Strategic Average Liabilities
    • Strategic ROE
    • Strategic ROA
    • Strategic Target ROE
    • Strategic Cap Floor Impact
    • Strategic Loan Amount
    • Strategic Loan Balance
    • Strategic Loan Commitment
    • Strategic Loan Net Funding
  • Strategic Deposit Average Balance
  • Strategic Loan Net Commitment
  • FTP Interest Income
  • FTP Interest Expense
  • FTP Net Interest Income
  • FTP Non Interest Expense
  • FTP Loan Loss Reserve
  • FTP Other Income
  • FTP Pre Tax Income
  • FTP Taxes
  • FTP Net Income
  • FTP Average Assets
  • FTP Average Equity
  • FTP Average Liabilities
  • FTP ROE
  • FTP ROA
  • FTP Target ROE
  • FTP Cap Floor Impact
  • FTP Loan Amount
  • FTP Loan Balance
  • FTP Loan Commitment
  • FTP Loan Net Funding
  • FTP Deposit Average Balance
  • FTP Loan Net Commitment

Back to Top

 

Active Loan Accounts

Shows information for all active commercial loan accounts in PrecisionLender.

Field Names

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

Back to Top

 

Active Other Accounts

Shows information for all active other accounts in PrecisionLender.

Field Names

  • Account Id Masked
  • Account Id
  • Account Last Modified
  • Account Created
  • Account Notes Account Status
  • Account Balance
  • Account Pre Tax Income
  • Account Average Balance
  • Average Pre Tax Income
  • Product Target ROE
  • Product Average Balance Window
  • Product Capital Allocation
  • Product Average Pre Tax Income Window
  • Product Generation Name
  • Product Family Id
  • Product Generation Effective Date
  • Relationship Id
  • Masked Relationship Id
  • Relationship Name
  • Strategic Interest Income
  • Strategic Interest Expense
  • Strategic Net Interest Income
  • Strategic Non Interest Expense
  • Strategic Loan Loss Reserve
  • Strategic Other Income
  • Strategic Pre Tax Income
  • Strategic Taxes
  • Strategic Net Income
  • Strategic Average Assets
  • Strategic Average Equity
  • Strategic Average Liabilities
  • Strategic ROE
  • Strategic ROA
  • Strategic Target ROE
  • Strategic Cap Floor Impact
  • Strategic Loan Amount
  • Strategic Loan Balance
  • Strategic Loan Commitment
  • Strategic Loan Net Funding
  • Strategic Deposit Average Balance
  • Strategic Loan Net Commitment

Back to Top

 

All Opportunities - Account Level

Shows each account in the pipeline as well as each account in production or closed lost since the selected From Date.

Field Names

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

Back to Top 

 

Caps and Floors Impact

Shows the impact of the cap or floor on each Account in PrecisionLender. This can be useful if you would like to feed this information back into your core system.

Field Names

  • Opportunity Name
  • Owner Name
  • Loan Name
  • Close Date
  • Pricing Date
  • Impact
  • Short Code

Back to Top

 

Opportunities

Shows information for all open and closed opportunities in PrecisionLender.

Field Names

  • Opportunity Id
  • Opportunity
  • Relationship
  • Pricing Date
  • Close Date
  • Stage
  • Status
  • Owner
  • Loan Amount
  • Average Equity
  • Loan Balance
  • Deposit Balance
  • Average Assets
  • Active Scenario
  • Net Income
  • Net Income Target
  • Net Income Delta
  • ROE
  • Target ROE
  • Roe Delta
  • Loan Only ROE
  • Loan Only Target ROE
  • ROA
  • Interest Income
  • Interest Expense
  • Net Interest Income
  • Non Interest Expense
  • Loan Loss Reserve
  • Pre Tax Income
  • Other Income
  • Taxes
  • Loan Products
  • Region
  • Last Modified
  • Notes
  • Short Code

Back to Top