2022-01-19 Release Notes (Data Studio)

What is changing?

New columns are being added to multiple PL_RelationshipAwareness datasets. All new columns will be added to the end of the datasets.

 

Why is it changing?

To better support reporting and modeling using PL_RelationshipAwareness datasets.

 

Which datasets are impacted?

CoreCommercialLoanAccounts

Current version: v2.0

New version: v2.1

New Column Names

New Column Types

AnnualGrossRevenues

float

DunsNumber

string

ParticipationsFlag

string

RateIndex

string

RenewalFlag

string

 

CoreConsumerLoanAccounts

Current version: v1.0

New version: v1.1

New Column Names

New Column Types

AnnualGrossRevenues

float

DunsNumber

string

ParticipationsFlag

string

RateIndex

string

RenewalFlag

string

 

CoreDepositAccounts

Current version: v2.0

New version: v2.1

New Column Names

New Column Types

AnnualGrossRevenues

float

DunsNumber

string

RateIndex

string

 

CoreOtherAccounts

Current version: v2.0

New version: v2.1

New Column Names

New Column Types

AnnualGrossRevenues

float

DunsNumber

string

RateIndex

string

 

CoreMasterCommitmentLoanAccounts

Current version: v1.0

New version: v1.1

New Column Names

New Column Types

AnnualGrossRevenues

float

DunsNumber

string

RateIndex

string

 

CoreLoanAmortizationTables

Current version: v1.0

New version: v1.1

New Column Names

New Column Types

RaRunId

string

 

CoreAccountFinancialStatements

Current version: v2.0

New version: v2.1

New Column Names

New Column Types

AnnualizedOriginationExpenses

float

AnnualizedOriginationFees

float

 

Relationships

Current version: v1.0

New version: v1.1

New Column Names

New Column Types

CustomerSinceDate

string

 

RelationshipFinancialStatements

Current version: v1.1

New version: v1.2

New Column Names

New Column Types

AnnualizedOriginationExpenses

float

AnnualizedOriginationFees

float

 

How does my bank need to prepare for these changes?

If your bank is using any of the impacted datasets and explicitly referencing the major and minor version numbers, then please update the minor version number according to the changes listed above.

 

When are these changes happening?

These changes will be effective in Data Studio as of January 20th, 2022.