OFSAA Demystification of Instrument Tables

OFSAAs instrument tables allow the clients to capture end of the day balances from their various source systems. These tables contain columns that represent the attributes associated with a transaction type.

For example, in banking, for a house loan/mortgage product transaction with a customer, following questions can be asked for each Mortgage transaction

What is the mortgage product?

What is the customer account number?

What is the profit as of date from this mortgage account?

What is the interest accrued on this account ?

What is the term of the mortgage/house loan?

Is this tracking base rate? if so what is the tracker and current base rate?

If this is fixed price mortgage, then what is the fixed price rate and term

Is the payment received as direct debit?

Which bank branch does this account reside?

What is the call centre expense for this account, based on number of calls received from the customer for this specific mortgage account?

What is the frequency at which the interest is compounded?

In case of OFSAA, the Mortgage instrument table named FSI_D_MORTGAGES contains approx 250 attributes, each of which answers the questions listed above, as shown in the screenshot below.

Rather than each bank spending time and money on analysts to decipher the attributes related to the product, the OFSAA product comes out of the box model with these attributes.
This helps to speed up the implementation, so that the implementation teams can simply concentrate on making the data available for these product types.

Typically you will find that Oracle have created one instrument table for each product type out of the box. These tables come pre-registered with the OFSAA’s analytical engine.

Oracle keeps on adding new tables to the list of instrument tables. However, if a specific product type does not have a corresponding instrument table then implementation team can create new tables and register those with the OFSAA’s data model.

List of OFSAA Instrument tables

FSI_D_ANNUITY_CONTRACTS

FSI_D_ANNUITY_TXNS

FSI_D_BORROWINGS

FSI_D_BORROWINGS_TXNS

FSI_D_BREAK_FUNDING_CHARGES

FSI_D_CASA

FSI_D_CASA_TXNS

FSI_D_CREDIT_CARDS

FSI_D_CREDIT_CARDS_TXNS

FSI_D_CREDIT_LINES

FSI_D_CREDIT_LINES_TXNS