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
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 |
FSI_D_DERIVATIVES |
FSI_D_FORWARD_RATE_AGMTS |
FSI_D_FUTURES |
FSI_D_FX_CONTRACTS |
FSI_D_GUARANTEES |
FSI_D_GUARANTEES_TXNS |
FSI_D_INVESTMENTS |
FSI_D_INVESTMENTS_TXNS |
FSI_D_LEASES |
FSI_D_LEASES_TXNS |
FSI_D_LEDGER_STAT_INSTRUMENT |
FSI_D_LOAN_CONTRACTS |
FSI_D_LOAN_CONTRACTS_TXNS |
FSI_D_MERCHANT_CARDS |
FSI_D_MM_CONTRACTS |
FSI_D_MM_CONTRACTS_TXNS |
FSI_D_MORTGAGE_BACK_SEC |
FSI_D_MORTGAGE_BACK_SEC_TXNS |
FSI_D_MORTGAGES |
FSI_D_MORTGAGES_TXNS |
FSI_D_MUTUAL_FUNDS |
FSI_D_OPTIONS |
FSI_D_OTHER_SERVICES |
FSI_D_PAYMENT_SCHEDULE |
FSI_D_RETIREMENT_ACCOUNTS |
FSI_D_RETIREMENT_ACCTS_TXNS |
FSI_D_SWAPS |
FSI_D_TERM_DEPOSITS |
FSI_D_TRUSTS |
FSI_D_TRUSTS_TXNS |