2023-09-28 Release Notes (Data Library)

What is changing?

We are adding information to the below reports.

  • Account Level All Scenario
  • Account Level Pipeline Scenarios

LocationData Library ->  Data Feeds

New Fields

Field Name Change Type Data Type Description
Pipeline Scenario Type Added String Determines if a pipeline scenario is an alternative or competitive scenario
Relationship Owner Region Id Added String The unique PrecisionLender ID associated with the region the relationship owner is assigned to
COF % Added  Float Cost of Funds calculated as 
 (Interest Expense / Loan Average Balance) loan accounts & 
(Interest Expense / Deposit Amount) For Deposits 
Funding Package Added  String Name of the funding package (also named funding source) applied to the account.
Prepayment Selection Added  String  The prepayment option selected on the account
Base Loan only COF % Added  float Calculated only for Loan accounts. Calculated as (Raw Interest Expense / Loan Average Balance)
AverageCreditCapital  Added float The average credit capital for the loan record which is a function of several administrative configurations including:  Capital Strategy, Loss Given Default Method and Probability of Default settings
AverageOperationalRiskCapital Added float Projected monthly Operational and Market Risk Capital allocation based on the Projected Average Balance

 

Report: Opportunities

LocationData Library -> Data Feeds

New Fields

Field Name Change Type Data Type Description
Pipeline Scenario Type Added String Determines if a pipeline scenario is an alternative or competitive scenario

 

Why is it changing?

These changes provide additional information on the accounts or opportunities to support analyses.

 

Which datasets are impacted?

The below datasets are impacted.

Change Dataset Type Report name
Updated Data Library Account Level All Scenarios
Updated Data Library Account Level Pipeline Scenarios
Updated Data Library Opportunities

 

How does my bank need to prepare for these changes?

The additional fields will be added to the end of the CSV files to ensure there is minimal impact to existing processes that use these feeds.

It is recommended to review downstream processes that utilize the mentioned data feeds to ensure there is no breaking impact from these changes.

 

When are these changes happening?

These changes went into effect on Thursday, 28th of September, 2023.