Portfolio Insights Folder

This article will cover the available Portfolio Insights reports in the Data Library Catalog.

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

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.
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.

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 180 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.

Portfolio Insights Folder

In this Article