13.2 Overview of Account Dimension Population
These are the SCD seeded definitions for loading data into the target table Account Dimension (DIM_ACCOUNT).
Table 13-1 Table to Table Seeded Definitions
| Map Reference Number | Source View Name |
|---|---|
| 188 | STG_ANNUITY_CONTRACTS_V |
| 189 | STG_BILLS_CONTRACTS_V |
| 190 | STG_BORROWING_V |
| 191 | STG_CARDS_V |
| 192 | STG_CASA_V |
| 193 | STG_COMMITMENT_CONTRACTS_V |
| 194 | STG_CREDIT_DERIVATIVES_V |
| 195 | STG_FUTURES_V |
| 196 | STG_FX_CONTRACTS_V |
| 197 | STG_GUARANTEES_V |
| 198 | STG_INVESTMENTS_V |
| 199 | STG_LC_CONTRACTS_V |
| 200 | STG_LEASES_CONTRACTS_V |
| 201 | STG_LOAN_CONTRACTS_V |
| 202 | STG_MM_CONTRACTS_V |
| 203 | STG_MUTUAL_FUNDS_V |
| 204 | STG_OD_ACCOUNTS_V |
| 205 | STG_OPTION_CONTRACTS_V |
| 206 | STG_REPO_CONTRACTS_V |
| 207 | STG_RETIREMENT_ACCOUNTS_V |
| 208 | STG_SWAPS_CONTRACTS_V |
| 209 | STG_TD_CONTRACTS_V |
| 210 | STG_TRUSTS_V |
| 211 | STG_ISTISNA_V |
| 212 | STG_IJARAH_V |
| 213 | STG_MUDARABAH_V |
| 214 | STG_MURABAHAH_V |
| 215 | STG_MUSHARAKAH_V |
| 216 | STG_SALAM_V |
| 217 | STG_SUKUK_V |
| 262 | STG_BORROWING_COMMITMENTS_V |
| 263 | STG_CORRESPONDENT_ACCOUNT_V |
| 264 | STG_TRADING_ACCOUNT_V |
| 341 | STG_PAYMENT_SETTLEMENT_ACCT_V |
| 349 | STG_COMMODITIES_V |
| 350 | STG_CUSTODIAL_ACCOUNTS_V |
| 351 | STG_MANAGED_INV_ADV_V |
| 352 | STG_MERCHANT_BANKING_V |
| 353 | STG_PREPAID_CARDS_V |
| 354 | STG_SPEND_OBLIGATIONS_V |
| 400 | STG_MERCHANT_CARDS_V |
| 465 | STG_FORWARDS_V |
| 467 | STG_ASSETS_SOLD_V |
| 494 | STG_CREDIT_PARTCPN_DETAILS_V |
| 188 | STG_ANNUITY_CONTRACTS_V |
All the above-mentioned Product Processor tables are mutually exclusive in terms of functionality. Therefore, V_ACCOUNT_NUMBER or V_CONTRACT_CODE (Primary Key of each Product Processor) must also have mutually exclusive values across all the 40 tables. The same account number cannot be part of multiple Product Processor tables.