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 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:
Figure 3-4 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. |