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.
Credit Migration Matrix
| 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.
Relationship Deposit Anomalies
| 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.
Relationship LOC Anomalies
| 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.
Renewals
| 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.
RM Pipeline Leaderboard
| 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.
RM Pipeline Scorecard
| 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.
RM Portfolio Leaderboard
| 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. |
