OFSAA Data Model - High Level

The data model in OFSAA is divided in multiple layers; however two key areas are Ledger Stat and Instrument tables.
The purpose of these is as described below This e-mail address is being protected from spambots. You need JavaScript enabled to view it

Ledger Stat	Ledger Stat captures ending balances, average balances, income & expense
	Ledger Stat in OFSAA is one of the sources for the transfer pricing and profitability process, for example the amount of expenses incurred in running a bank branch can be derived from the ledger stat.
	Ledger Stat contains balance sheet and capital allocations
Notes on Ledger Stat	Only one ledger stat table exists in each OFSAA instance
@apps2fusion (Copyright)	New columns cannot be added
	Custom ledger stat tables cannot be registered
	General Ledger or FAH balances can feed into Ledger Stat. The decision between FAH or GL feeding into Ledger Stat depends upon the level of granularity desired in Ledger Stat.

Instrument tables	Instrument tables contain the end of day balances at extremely granular level from the source systems
@apps2fusion (Copyright)	ALM and FTP engine use the information in these tables to calculate NII or Liquidity gaps.
	ALM and FTP engine also write back into these tables with processed results
	Output of these is fed into a result table
Notes on Instrument Tables	Various instrument tables are delivered by Oracle out of the box
	New columns can be added to the existing instrument tables.
	After the new tables and new columns are registered, these become available to the OFSAA engine.
	New instrument tables can be added and registered within OFSAA provided they adhere to the standards. This process is straightforward.

Set as favorite

Bookmark

Email This

Comments (6)

Subscribe to this comment's feed

coach outlet store
written by coach outlet store online , March 15, 2012

I have read many articles about this subject but only your point has been deeply absorbed my attention and I hope you can write more.

report abuse

vote down

vote up

Votes: +2

http://www.idolreplicas.me.uk/
written by idol replicas , April 12, 2012

I couldn't believe how blase http://www.watchrex.info/ Tesco was when a customer contacted it to say http://www.topgunreplicawatches.co.uk/Rolex watches sale

report abuse

vote down

vote up

Votes: +1

vfds
written by Lexia 3 , May 07, 2012

These include an identical band estimable newspaper web site, and immediately, because the age of electronic networks, they are difficult to verify that you're gay and web log so clever. Your book journal web alone are identical, the bay and fat emotion inches. xyj

report abuse

vote down

vote up

Votes: +0

http://www.tradebeatsbydre.com
written by new beats by dre , June 22, 2012

You completed certain good points there. I did a search on the theme and found mainly people will agree with your blog.

report abuse

vote down

vote up

Votes: +0

Miu Miu h******s
written by Miu Miu , September 05, 2012

Being an emigrant from St. Petersburg, Russia, Clara's past inspiration was derived from the imperial jeweled Faberge eggs that are historically connected to Russian Tzars. This year, Clara was inspired by the Year Miu miu outlet of the Dragon. She wished to evoke the spirit of Shanghai by creating a color pallet of red, black, and gold. Luxurious lace detailing, rose-like fabric manipulations, and jeweled clasps are only some of the magnificent elements in Clara's "red trend" clutches.

report abuse

vote down

vote up

Votes: +0

breitling navitimer cosmonaute replica
written by breitling navitimer cosmonaute replica , September 19, 2012

breitling navitimer cosmonaute replica
You know you haven't moved on when they're still showing up in your dreams.?

report abuse

vote down

vote up

Votes: +0

Write comment

Name