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 transition in credit ratings for all client loans over 1 year period.
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
Highlights anomalous depletion of deposits for most recent Relationship Awareness (RA) run date at the relationship level.
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
Highlights anomalous usage of Lines of Credit for most recent Relationship Awareness (RA) run date at the relationship level.
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. |
