2022-05-20 Release Notes (Data Library)

What is changing?

The below changes are being made to the Delivery to Promise data set which is accessed through the Data Library.

 

Delivery to Promise Data Set:

Renamed Fields:

Old Field Name New Field Name Data Type Description
Avg Balance 6 Average Balance 6 double Average relationship deposit balance for this Deposit Type during the 6-month Delivery Window
Avg Balance 12 Average Balance 12 double Average relationship deposit balance for this Deposit Type during the 12-month Delivery Window
Avg Balance 24 Average Balance 24 double Average relationship deposit balance for this Deposit Type during the 24-month Delivery Window
Avg Balance 36 Average Balance 36 double Average relationship deposit balance for this Deposit Type during the 36-month Delivery Window
Opp Loan Commitment Opportunity Loan Commitment double The total loan commitment on the opportunity
Opp Deposits Promised Opportunity Deposits Promised double The total deposit value on this opportunity for this deposit type
Opp Other Income Promised Opportunity Other Income Promised double The total other income promised on this opportunity
Opp Deposits Promised All Types Opportunity Deposits Promised All Types double The total deposit value on this opportunity across all deposit types

 

Date Formats Changed:

Field Name Data Type Old Format New Format
Opportunity Last Modified date YYYY-MM-DDTHH:MM:SS YYYY-MM-DD HH:MM:SS AM/PM
Last RA Run Date date YYYYMMDD YYYY-MM-DD

 

Why is it changing?

The changes are being made to support column names being consistent with their definitions and in supporting better readability. Additional data elements are also being added to support deeper analysis and richer data for insights.

 

Which datasets are impacted?

  • Delivery to Promise

 

How does my bank need to prepare for these changes?

Any downstream processes that utilize the names of the columns need to be changed to support the new names. Additional columns will also need to be handled in case downstream processes require their definition. The specific format of the Last Modified date on the CSV, needs to be changed to support the changes.

 

When are these changes happening?

These changes will go into effect on Friday, May 20, 2022.