2021-01-19 Release Notes (L3 Library)

What is changing?

  • L3 Library datasets are being updated to use standardized, worksheet friendly (e.g. Excel) date and timestamp formats.

 

Why is it changing?

These changes improve the usefulness and usability of date and timestamp fields.

 

Which datasets are impacted?

Account Level All Scenarios

Column Name

Change

Created Date

New format yyyy-MM-dd 

Pricing Date

New format yyyy-MM-dd

Close Date

New format yyyy-MM-dd 

Last Modified

New format yyyy-MM-dd hh:mm:ss aa

 

Account Level Pipeline Scenarios

Column Name

Change

Created Date

New format yyyy-MM-dd 

Pricing Date

New format yyyy-MM-dd

Close Date

New format yyyy-MM-dd

Last Modified

New format yyyy-MM-dd hh:mm:ss aa

 

Caps and Floors Impact

Column

Change

Pricing Date

New format yyyy-MM-dd

Close Date

New format yyyy-MM-dd

Last Modified

New format yyyy-MM-dd hh:mm:ss aa

 

Login Usage

Column

Change

Last Login

New format yyyy-MM-dd

 

Active Deposit Accounts

Column

Change

Last Refresh Date

New format yyyy-MM-dd

CD Origination Date

New format yyyy-MM-dd

 

Active Loan Accounts

Column

Change

Last Refresh Date

New format yyyy-MM-dd

Origination Date

New format yyyy-MM-dd

Maturity Date

New format yyyy-MM-dd

Payoff Expected Date

New format yyyy-MM-dd

 

Active Other Accounts

Column

Change

Last Refresh Date

New format yyyy-MM-dd

 

Opportunities

Change

Change

Pricing Date

New format yyyy-MM-dd

Close Date

New format yyyy-MM-dd

Last Modified

New format yyyy-MM-dd hh:mm:ss aa

 

Relationships

Column

Change

Last Modified

New format yyyy-MM-dd hh:mm:ss aa

 

Renewals

Column

Change

Date Partition

New format yyyy-MM-dd

Maturity Date

New format yyyy-MM-dd

 

How does my bank need to prepare for these changes?

  • Any process expecting old date formats should be updated. New formats should automatically be recognized as date/time by Excel and other applications.

 

When are these changes happening?

These changes will be effective in the L3 Library tab of the PrecisionLender application as of January 18, 2021.