3.4.2.1 Business Data

To view the current set of business data tables in the staging area, open the OFSDF Staging Area model in the erwin Data Modeler application, and click on Subject Areas as shown below. Right click and switch to the 'Staging-Data Tables' subject area.

Figure 3-3 OFSDF Staging Area Data Tables


This illustration shows the OFSDF Staging Area Data Tables in the data model.

This provides an ordered, visually grouped list of the business data tables in the current staging area model. Above each group in the diagram is the group name as a label, to categorize the tables, as follows:

The key groups of business data tables in the model are as follows.

Figure 3-4 The key groups of business data tables in the data model


This illustration shows the key groups of business data tables in the data model.

Table 3-2 Key Groups of Business Data Tables and their purpose in the Staging Data Mode

Group Name Purpose

Product Processors

Tables for Financial Instruments and Contracts. Note that these tables can accommodate nearly 80+ types of instruments and derivatives across Banking and Trading books.

Transactions

Tables to hold Transaction/Event level data from the bank's systems. These tables are available by both con- tract and channel, and there is additionally a set of Transaction Summary tables that contain transaction data in a summarized form required by the Profitability application.

Exposures

Exposures are basically contracts on the asset side of the balance sheet. The tables in this category are primarily used by Risk applications.

Mitigants

Mitigants are used to address specific types of risk posed by exposures. The tables in this category are primarily used by Risk applications.

GL

Contains tables holding information pertaining to the General Ledger.

Customer

Consists of Marketing-related Customer activity and plan data relevant to CRM analytics. Note that core customer information is in the Product Processors, and reference data about customers is elsewhere.

Rates

Economic indicators, Interest Rates and other information relevant to analytical processing for Risk and Asset Liability Management applications.