25.1 Overview of the Fiduciary Services Investment Summary Tables

Fiduciary Services Investment Summary table is loaded from the staging product processor table using the Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework.

A fiduciary is responsible for managing the assets of another person, or of a group of people. The fiduciary is expected to manage the assets for the benefit of the customer. The customer can open a trust account that would have the different investments that the person would do. The customer would have different assets under the trust such as Investments, Mututal Funds, CASA, Term Deposit etc. So, in these T2Ts the target table is loaded only with those records which are of fiduciary service type which is identified using Parent Account Number in each Product Processor table.

The Fact Fiduciary Services Investment Summary stores records from the Stage CASA, Stage Custodial Accounts, Stage Investments, Stage Managed Inv Adv, Stage Mutual Funds, Stage Retirement Accounts, Stage TD Contracts and Stage Trusts, that has valid Parent Account Number for further operation and regulatory reporting.