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

 

Data Feeds Folder

Reports

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

 

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

 

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