This article will cover the available Portfolio Insights reports in the L3 Library Catalog.
In this Article
Portfolio Insights Folder
Note: Portfolio Insights is a premium service for clients. If you are interested in adding Portfolio Insights for your organization, please reach out to our support team at support@precisionlender.com.
Credit Migration Matrix
Matrix of credit rating transitions for all of a client's loans over the past year.
Field Name | Data Type | Description |
NULL | string | Row labels (AAA - CCC/C) for risk of default rating at beginning of 1 year period. |
AAA | float | Proportion of loans with initial rating matching row name and final rating AAA. |
AA+ | float | Proportion of loans with initial rating matching row name and final rating AA+. |
AA | float | Proportion of loans with initial rating matching row name and final rating AA. |
AA- | float | Proportion of loans with initial rating matching row name and final rating AA-. |
A+ | float | Proportion of loans with initial rating matching row name and final rating A+. |
A | float | Proportion of loans with initial rating matching row name and final rating A. |
A- | float | Proportion of loans with initial rating matching row name and final rating A-. |
BBB+ | float | Proportion of loans with initial rating matching row name and final rating BBB+. |
BBB | float | Proportion of loans with initial rating matching row name and final rating BBB. |
BBB- | float | Proportion of loans with initial rating matching row name and final rating BBB-. |
BB+ | float | Proportion of loans with initial rating matching row name and final rating BB+. |
BB | float | Proportion of loans with initial rating matching row name and final rating BB. |
BB- | float | Proportion of loans with initial rating matching row name and final rating BB-. |
B+ | float | Proportion of loans with initial rating matching row name and final rating B+. |
B | float | Proportion of loans with initial rating matching row name and final rating B. |
B- | float | Proportion of loans with initial rating matching row name and final rating B-. |
CCC/C | float | Proportion of loans with initial rating matching row name and final rating CCC/C. |
Paid | float | Proportion of loans with initial rating matching row name which were paid off within 1 year. |
Unknown | float | Proportion of loans with initial rating matching row name with unknown status after 1 year. |
Default | float | Proportion of loans with initial rating matching row name which defaulted within 1 year. |
Relationship Deposit Anomalies
Details for relationships with anomalous depletion of deposits for most recent Relationship Awareness (RA) run date.
Field Name | Data Type | Description |
Owner Id | GUID | The unique user id of the relationship manager. |
Owner Full Name | string | The full name of the relationship manager. |
Owner Email | string | The email address of the relationship manager. |
Relationship External Identifier | GUID | The unique relationship id for the account level relationship. |
Relationship Name | string | Name of the relationship. |
Current Deposit Balance | double | Current deposit balance for all accounts tied to the relationship. |
Previous Deposit Balance | double | Previous deposit balance for all accounts tied to the relationship. |
Change In Deposit Balance | double | Change in total deposit balance since last Relationship Awareness (RA) run date. |
Percent Change | integer | Percent change in total Deposit balance. |
3 Month Average Balance | double |
Average total deposit balance for all accounts 3 months prior to current Relationship Awareness (RA) run date.
|
12 Month Average Balance | double |
Average total deposit balance for all accounts 12 months prior to current Relationship Awareness (RA) run date.
|
Anomaly Score | double | Statistical indicator of anomalous activity: 0-10 (i.e. 10 being extremely unusual). |
Anomaly Ranking By Owner | integer | Anomaly Ranking for all of an owner's relationships. |
Days To Depletion | integer | Predicted number of days until total deposit balances is $0 at current draw down rate. |
Data as of Relationship Awareness run on | date | Date of Relationship Awareness run used (RA) for calculation of the anomalies. |
Relationship LOC Anomalies
Details for relationships with anomalous usage of Lines of Credit for most recent Relationship Awareness (RA) run date.
Field Name | Data Type | Description |
Owner Id | GUID | The unique user id of the relationship manager. |
Owner Full Name | string | The full name of the relationship manager. |
Owner Email | string | The email address of the relationship manager. |
Relationship External Identifier | GUID | The unique relationship id for the account level relationship. |
Relationship Name | string | Name of the relationship. |
Current Utilization | int | Current utilization over all accounts tied to the relationship. |
Previous Utilization | int | Previous utilization over all accounts tied to the relationship |
Current LOC Balance | double | Current LOC balance for all accounts tied to the relationship. |
Previous LOC Balance | double | Previous LOC balance for all accounts tied to the relationship. |
Change In LOC Balance | double | Change in total LOC balance since last Relationship Awareness (RA) run date. |
Current LOC Commitment | double | Current Commitment over all LOC accounts tied to the relationship |
Previous LOC Commitmnet | double | Previous Commitment over all LOC accounts tied to the relationship |
3 Month Average Balance | double | Average total LOC balance for all accounts 3 months prior to current Relationship Awareness (RA) run date. |
12 Month Average Balance | double |
Average total LOC open balance for all accounts 12 months prior to current Relationship Awareness (RA) run date.
|
Percent Change | integer | Percent change in total LOC open balance since last Relationship Awareness (RA) run date. |
Anomaly Score | double | Statistical indicator of anomalous activity: 0-10 (i.e. 10 being extremely unusual). |
Anomaly Ranking By Owner | integer | Anomaly Ranking for all of an owner's relationships. |
Current Date | date | Date of Relationship Awareness run used (RA) for detection of the anomalies. |
Previous Date | date | Date of Relationship Awareness run prior to detection of the anomalies |
Renewals
Renewals of Line of Credit and Letter of Credit core accounts maturing within the next 90 days.
Field Name | Data Type | Description |
DatePartition | integer | The date the dataset was generated in YYYYMMDD format. |
CoreAccountId | GUID | The unique PrecisionLender identifier for the account. |
DaysToMaturity | integer | The number of days until the account reaches maturity. |
MaturityDate | date | The date the account reaches maturity. |
Maturity | integer | The maturity of the loan account in months. |
AmortizationTerm | integer | The amortization term of the loan account in months. |
OwnerFullName | string | The name of the owner of the account. |
OwnerEmail | string | The email of the owner of the account. |
RelationshipName | string | The name of the relationship associated with the account. |
ProductName | string | The name of the product associated with the account. |
Commitment | double | The commitment of the loan account. |
Balance | dobule | The current balance of the account. |
NetIncome | double | The net income of the account. |
ROE | double | The return on equity of the account. |
Relationship_NetIncome | double | The NetIncome of the relationship associated with the account. |
Relationship_ROE | double | The ROE of the relationship associated with the account. |
RM Pipeline Leaderboard
Leaderboard ranking of relationship managers by return on equity (ROE) of closed won opportunities over the trailing 12 months.
Field Name | Data Type | Description |
Owner | string | The full name of the relationship manager. |
Owner Id | GUID | The unique user id of the relationship manager. |
Region | string | The region associated with the relationship manager. |
Region Id | GUID | The unique id of the region. |
ROE | double | The return on equity of closed won opportunities. |
Net Income | double | The net income of closed won opportunities. |
Average Equity | double | The effective average annualized equity (allocated capital) of closed won opportunities. |
Count of Closed Won Opportunities | int | The number of opportunities won by the relationship manager. |
Count of Opportunities | int | The number of opportunities priced by the relationship manager. |
Pct Opportunities Closed Won | double | The percentage of all opportunities won by the relationship manager. |
Loan Amount | double | The total loan amount of closed won opportunities. |
Deposit Amount | double | The total deposit amount of closed won opportunities. |
Other Amount | double | The total other amount of closed won opportunities. |
RM Pipeline Scorecard
Scorecard of relationship managers by various metrics of all opportunities modified in the trailing 12 months.
Field Name | Data Type | Description |
Owner | string | The full name of the relationship manager. |
Owner Id | GUID | The unique user id of the relationship manager. |
Region | string | The region associated with the relationship manager. |
Region Id | GUID | The unique id of the region. |
Count of Opportunities - Closed | int | The number of opportunities won by the relationship manager. |
Count of Opportunities - Priced | int | The number of opportunities priced by the relationship manager. |
Pct Opportunities Closed Won | double | The percentage of all opportunities won by the relationship manager. |
ROE - Closed | double | The return on equity of closed won opportunities. |
Net Income - Closed | double | The net income of closed won opportunities. |
Average Equity - Closed | double | The effective average annualized equity (allocated capital) of closed won opportunities. |
Loan Amount - Closed | double | The total loan amount of closed won opportunities. |
Deposit Amount - Closed | double | The total deposit amount of closed won opportunities. |
Other Amount - Closed | double | The total other amount of closed won opportunities. |
Count of Loan Accounts - Closed | int | The count of loan accounts in closed won opportunities. |
Count of Deposit Accounts - Closed | int | The count of deposit accounts in closed won opportunities. |
Count of Other Accounts - Closed | int | The count of other accounts in closed won opportunities. |
Count of Opportunities with Relationship - Closed | int | The count of closed won opportunities with an attached relationship. |
Count of Opportunities with Multiple Scenarios - Closed | int | The count of closed won opportunities with multiple scenarios. |
Count of Opportunities with Multiple Accounts - Closed | int | The count of closed won opportunities with multiple accounts. |
Count of Opportunities with Loan Accounts - Closed | int | The count of closed won opportunities with at least one loan account. |
Count of Opportunities with Deposit Accounts - Closed | int | The count of closed won opportunities with at least one deposit account. |
Count of Opportunities with Other Accounts - Closed | int | The count of closed won opportunities with at least one other account. |
Pct Opportunities with Relationship - Closed | double | The percentage of closed won opportunities with an attached relationship. |
Pct Opportunities with Multiple Scenarios - Closed | double | The percentage of closed won opportunities with multiple scenarios. |
Pct Opportunities with Multiple Accounts - Closed | double | The percentage of closed won opportunities with multiple accounts. |
Pct Opportunities with Loan Accounts - Closed | double | The percentage of closed won opportunities with at least one loan account. |
Pct Opportunities with Deposit Accounts - Closed | double | The percentage of closed won opportunities with at least one deposit account. |
Pct Opportunities with Other Accounts - Closed | double | The percentage of closed won opportunities with at least one other account. |
ROE - Priced | double | The return on equity of all opportunities. |
Net Income - Priced | double | The net income of all opportunities. |
Average Equity - Priced | double | The effective average annualized equity (allocated capital) of all opportunities. |
Loan Amount - Priced | double | The total loan amount of all opportunities. |
Deposit Amount - Priced | double | The total deposit amount of all opportunities. |
Other Amount - Priced | double | The total other amount of all opportunities. |
Count of Loan Accounts - Priced | int | The count of loan accounts in all opportunities. |
Count of Deposit Accounts - Priced | int | The count of deposit accounts in all opportunities. |
Count of Other Accounts - Priced | int | The count of other accounts in all opportunities. |
Count of Opportunities with Relationship - Priced | int | The count of all opportunities with an attached relationship. |
Count of Opportunities with Multiple Scenarios - Priced | int | The count of all opportunities with multiple scenarios. |
Count of Opportunities with Multiple Accounts - Priced | int | The count of all opportunities with multiple accounts. |
Count of Opportunities with Loan Accounts - Priced | int | The count of all opportunities with at least one loan account. |
Count of Opportunities with Deposit Accounts - Priced | int | The count of all opportunities with at least one deposit account. |
Count of Opportunities with Other Accounts - Priced | int | The count of all opportunities with at least one other account. |
Pct Opportunities with Relationship - Priced | double | The percentage of all opportunities with an attached relationship. |
Pct Opportunities with Multiple Scenarios - Priced | double | The percentage of all opportunities with multiple scenarios. |
Pct Opportunities with Multiple Accounts - Priced | double | The percentage of all opportunities with multiple accounts. |
Pct Opportunities with Loan Accounts - Priced | double | The percentage of all opportunities with at least one loan account. |
Pct Opportunities with Deposit Accounts - Priced | double | The percentage of all opportunities with at least one deposit account. |
Pct Opportunities with Other Accounts - Priced | double | The percentage of all opportunities with at least one other account. |
RM Portfolio Leaderboard
Leaderboard ranking of relationships managers by the return on equity (ROE) of all active core accounts in the bank's portfolio.
Field Name | Data Type | Description |
Owner | string | The full name of the relationship manager. |
Owner Id | GUID | The unique user id of the relationship manager. |
Region | string | The region associated with the relationship manager. |
Region Id | GUID | The unique id of the region. |
ROE | double | The return on equity of all accounts. |
ROA | double | The return on assets of all accounts. |
Net Income | double | The total net income of all accounts. |
Average Equity | double | The effective average annualized equity (allocated capital) of all accounts. |
Average Assets | double | The effective average annualized assets of all accounts. |
Average Loan Balance | double | The sum of the average loan balances of all loan accounts. |
Average Deposit Balance | double | The sum of the average balances of all deposit accounts. |
Current Loan Balance | double | The total of all current loan balances in the most recent run of Relationship Awareness (RA). |
Current Deposit Balance | double | The total of all current deposit balances in the most recent run of Relationship Awareness (RA). |
Other Gross Revenue | double | The sum of revenues generated by all other accounts, net of any servicing costs. |