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