39.4.1 Dynamic Sourcing of the Amount and Balance Columns in the Product Processors Independent of OFSDF

The listed tables are used to source the Amount and Balance attributes at the account level that are not available currently in the Product Processors (PP) tables.

Table 39-2 Account Balances Tables

Table Name	Logical Table Name	Table Type
STG_ACCOUNT_BALANCES	Stage Account Balances	Stage
FCT_ACCOUNT_BALANCES	Fact Account Balances	Result
STG_BALANCE_TYPE_MASTER	Stage Balance Type Master	Stage Master
DIM_BALANCE_TYPE	Balance Type Dimension	Dimension
DIM_STD_BALANCE_TYPE	Standard Balance Type Dimension	Seeded table for reclassification

When you need to add a new Amount and Balance related columns in the Stage tables and they are not available in the Stage PP tables, then you can add those Amount and Balance related columns in the Stage Account Balances table for dynamic sourcing. In the Account Balances tables, the Balance attributes are added in the form of row-level entries.