What is changing?

  • For some customers, the date format in some of your L3 Workbench datasets is changing from short string format (ex: 9/13/2020 4:01:54 PM) to ISO format (ex: 2020-09-13T16:01:54.9930000Z).
  • Unnecessary fields, which have no value to L3 Workbench users, will be removed.
  • The version of the affected datasets will increase to v2.0.
  • The affected datasets will be backfilled for version v2.0. That means historical data before 11/15/2020 will exist in version v1.x and v2.0.

 

Why is it changing?

These changes improve the usability of the datasets from the PL_RelationshipAwareness source provider within L3 Workbench. The ISO date format will now be the standard date format for all date fields contained within L3 datasets from the PL_RelationshipAwareness source provider. The removal of unnecessary fields further simplifies these datasets by reducing their size and dimensionality.

 

Which datasets are impacted?

CoreAccountFinancialStatements

Current version: v1.1
New version: v2.0

Column Name Column Type
Last Calculated  Date format changed to ISO

 

CoreCommercialLoanAccounts

Current version: v1.0
New version: v2.0

Column Name Column Type
OriginationDate Date format changed to ISO
PayoffExpectedDate Date format changed to ISO
PLFTPCalculationDate Date format changed to ISO
MaturityDate Date format changed to ISO
NextAdjustmentDate Date format changed to ISO
FTPOverRemaingLifeCalcDate Date format changed to ISO
FTPOverCurrentPeriodCalcDate Date format changed to ISO
FTPOverLoanLifeCalcDate Date format changed to ISO
RunDate Date format changed to ISO
Date format changed to ISO Date format changed to ISO
Notes removed
RowValues removed
Comments removed
FTPValueLog removed
FTPOverCurrentPeriodLog removed
FTPOverLoanLifeLog removed
FTPOverRemainingLifeLog removed
DepositFTPLog removed

 

CoreDepositAccounts

Current version: v1.0
New version: v2.0

Column Name Change Type
CDOriginationDate Date format changed to ISO
DepositFTPRateCalculationDate Date format changed to ISO
RunDate Date format changed to ISO
Notes removed
RowValues removed
Comments removed
FTPValueLog removed
FTPOverCurrentPeriodLog removed
FTPOverLoanLifeLog removed
FTPOverRemainingLifeLog removed
DepositFTPLog removed

 

CoreOtherAccounts

Current version: v1.0
New version: v2.0

Column Name Changed Type
HorizonProjectionAsOfDate Date format changed to ISO
RunDate Date format changed to ISO
Notes removed
RowValues  removed
Comments removed
FTPValueLog removed
FTPOverCurrentPeriodLog removed
FTPOverLoanLifeLog removed
FTPOverRemainingLifeLog removed
DepositFTPLog removed

 

How does my bank need to prepare for these changes?

  • Any process that uses any of the removed columns need to be updated to no longer reference these columns.
  • Any process that uses the impacted datasets will need to be limited to only use the most recent major version partition. When reading a given dataset, the major dataset version (i.e. v1.x) must be specified to prevent duplication of records (i.e. having a dataset with the same record from v1.x and v2.x).

 

Before the change, dataset reads must specify v1.x as the major dataset version.

Example:
datamart/L3/v1.0/Primary/PL_RelationshipAwareness/Core/ CoreAccountFinancialStatements/InstancePartition=[YourclientIdhere]/VersionPartition=v1.*/

 

After the change, dataset reads must specify v2.x as their major dataset version.

Example:
datamart/L3/v1.0/Primary/PL_RelationshipAwareness/Core/ CoreAccountFinancialStatements/InstancePartition=[YourclientIdhere]/VersionPartition=v2.*/

 

When are these changes happening?

  • 10/15/2020: Emails to L3 Workbench clients notifying them of pending changes in 1 month.
  • 11/15/2020: New major dataset version starts being populated (v2.0 for impacted datasets) and is backfilled.
  • 12/15/2020: Prior major dataset versions will not be populated with new data.