39.6 Creating New Aggregate Table
The following aggregate tables are seeded with the Application Data Model:
Table 39-2 Seeded Aggregation Tables with the Application Data Model
| # | Logical name | Physical table name |
|---|---|---|
| 1 | Annuity Contracts Aggregate | FSI_D_ANNUITY_CONTRACTS_AGGR |
| 2 | Borrowings Aggregate | FSI_D_BORROWINGS_AGGR |
| 3 | Checking And Savings Accounts Aggregate | FSI_D_CASA_AGGR |
| 4 | Credit Cards Aggregate | FSI_D_CREDIT_CARDS_AGGR |
| 5 | Credit Lines Aggregate | FSI_D_CREDIT_LINES_AGGR |
| 6 | Guarantees Aggregate | FSI_D_GUARANTEES_AGGR |
| 7 | Investments Aggregate | FSI_D_INVESTMENTS_AGGR |
| 8 | Leases Aggregate | FSI_D_LEASES_AGGR |
| 9 | Loan Contracts Aggregate | FSI_D_LOAN_CONTRACTS_AGGR |
| 10 | Money Market Contracts Aggregate | FSI_D_MM_CONTRACTS_AGGR |
| 11 | Mortgages Aggregate | FSI_D_MORTGAGES_AGGR |
| 12 | Retirement Accounts Aggregate | FSI_D_RETIREMENT_ACCOUNTS_AGGR |
| 13 | Term Deposits Aggregate | FSI_D_TERM_DEPOSITS_AGGR |
To create a new aggregate table in addition to the basic instrument and leaf columns, the following mappings must be done in the data model:
- Super-type
- INSTRUMENT_AGGREGATE
- INSTRUMENT_AGGREGATE_BASIC
- Table classification
- EPM Aggregation (701)
This may be required when you create a custom instrument table and want to use stratification for it.