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.