What is changing?
We are adding information to multiple Data Studio datasets to support analyses.
New Fields Added:
- TreasuryDefaultPerUnitCost
- Date - 6/4/24
- Datatype - Double
- Description - The per unit cost to service this treasury account.
- Dataset - AccountLevelOpportunitiesHistory
- Location - L3/v1.0/Derived/PL_Application/Opportunities/AccountLevelOpportunitiesHistory
- NearestMaturityDate
- Date - 1/24/24
- Datatype - Date
- Description - An RA calculated field which provides the nearest maturity date for all loans on the relationship, including all children and descendant relationships.
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- RiskRating
- Date - 1/24/24
- Datatype -String
- Description - The risk rating for the relationship.
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- RiskRatingScorecard
- Date - 1/24/24
- Datatype - String
- Description - The risk rating scorecard for the relationship.
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- FtpLoanLossReserve
- Date - 1/17/24
- Datatype - Double
- Description - The annualized expected loss for a loan account.
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- StrategicLoanLossReserve
- Date - 1/17/24
- Datatype - Double
- Description - The annualized expected loss for a loan account.
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- TreasuryAverageAppliedEarningsCredit
- Date - 6/18/24
- Datatype - Double
- Description - The amount applied to a deposit account to offset activity-based charges.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryEarningsCreditEligibleRevenue
- Date - 6/18/24
- Datatype - Double
- Description - The revenues eligible for earnings credit from treasury accounts.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryEarningsCreditIneligibleRevenue
- Date - 6/18/24
- Datatype - Double
- Description - The revenues eligible for earnings credit from treasury accounts.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryGrossRevenue
- Date - 6/18/24
- Datatype - Double
- Description - The revenues generated by a treasury account, net of any servicing costs.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryAccountRevenueEarningsCreditGenerated
- Date - 6/18/24
- Datatype - Double
- Description - The total amount from earnings credit generated by a treasury account.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryAppliedEarningsCredit
- Date - 6/18/24
- Datatype - Double
- Description - The amount applied to a deposit account to offset activity-based charges.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryNetRevenue
- Date - 6/18/24
- Datatype - Double
- Description - The revenues generated by a treasury account, net of any applied earnings credits.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- TreasuryServicingExpense
- Date - 6/18/24
- Datatype - Double
- Description - The servicing expense for the treasury account.
- Dataset - CoreAccountFinancialStatements
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreAccountFinancialStatements
- OpportunityId
- Date - 6/3/24
- Datatype - String/Guid
- Description - OpportunityId that the event occurred on.
- Dataset - AndiEngagementEvents
- Location - L3/v1.0/Derived/PL_Andi/Engagement/EngagementEvents
- EarningsCreditEligibleRevenue
- Date - 4/25/24
- Datatype - Double
- Description - The revenues eligible for earnings credit from treasury accounts.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- EarningsCreditIneligibleRevenue
- Date - 4/25/24
- Datatype - Double
- Description - The revenues eligible for earnings credit from treasury accounts.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- GrossRevenue
- Date - 4/25/24
- Datatype - Double
- Description -The revenues generated by a treasury account, net of any servicing costs.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- AccountRevenueEarningsCreditGenerated
- Date - 4/25/24
- Datatype - Double
- Description - The total amount from earnings credit generated by a treasury account.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- AppliedEarningsCredit
- Date - 4/25/24
- Datatype - Double
- Description - The amount applied to a deposit account to offset activity-based charges.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- NetRevenue
- Date - 4/25/24
- Datatype - Double
- Description - The revenues generated by a treasury account, net of any applied earnings credits.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- ServicingExpense
- Date - 4/25/24
- Datatype - Double
- Description - The servicing expense for the treasury account.
- Dataset - TreasuryFinancialStatementBreakdown
- Location - L3/v1.0/Primary/PL_RelationshipAwareness/Core/TreasuryFinancialStatementBreakdown
- EcrEligibleDepositBalance
- Date - 3/4/24
- Datatype - Double
- Description - The total Ecr Eligible Deposit Balance for the relationship
- Dataset - Relationships
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Relationships/Relationships
- EcrEligible
- Date - 2/5/24
- Datatype - Boolean
- Description - Boolean indicating if the deposit product is ECR eligible, or not.
- Dataset - CoreDepositAccounts
- Location - L3/v1.0/Derived/PL_RelationshipAwareness/Core/CoreDepositAccounts
Why is it changing?
These changes provide additional information on relationships, opportunities, Andi, deposits and treasury financials to support analyses.
How does my bank need to prepare for these changes?
The additional fields will be added to the end of the CSV files to ensure there is minimal impact to existing processes that use these feeds.
It is recommended to review downstream processes that utilize the mentioned data feeds to ensure there is no breaking impact from these changes.
When are these changes happening?
These changes went into effect March 6, 2024.