4.9.2.1 Create Data Stratification Rule

This section provides the details on creating the data Stratification.

To create data Stratification rule, follow these steps:

  1. Navigate to Data Stratification Definition page.
  2. Follow the steps mentioned in below sections:
    1. Step 1: Definitions
    2. Step 2: Defaults
    3. Step 3: Aggregation
    4. Step 4: Stratification

Step 1: Definitions section

  1. From Definitions tab, click Start. The Definitions page is displayed.

    Figure 4-67 Definitions section


    Definitions section

  2. Enter the following details:
    • Name: Name of Data Stratification rule
    • Description: Description of Data Stratification rule
    • Folder: Folder where Data Stratification rule needs to be saved
    • Source Table: Select a Source Instrument Table (Asset and Liability). The list of values will include all seeded and properly registered instrument tables that contain account-level data records.
    • Target Table: Auto populated based on source table: Asset Aggregate, Liability Aggregate. You cannot modify this field.
    • Data Filter: Select Data filter. Displays data filters defined on Source Table
    • Catch All Buckets: Specify whether or not to include a catch-all bucket in the process. If this is selected, then all records from the source table must be accounted for in the target table.
    • Apply Column mapping for Non Aggregated Accounts:For accounts in the Source Table, which does not satisfy the filter condition will not be aggregated and will be moved to the destination table as is. But whether column mappings which are defined in aggregation tab and under defaults will be applicable or not for non-aggregated records, will be dependent on this switch. If switch is ON, then the aggregated records column mappings will be applicable to the non-aggregated records. Else the non-aggregated records will be moved to the destination aggregated table without using the column mappings.
  3. Click Continue.

Step 2: Defaults section

  1. Navigate to the Defaults section.

    Figure 4-68 Defaults section


    Defaults section

  2. Select the Amount default. Possible selections are MAX, MIN, SUM, AVG. The recommended selection is SUM.
  3. Select the Date default. Possible selections are MAX, MIN, MEDIAN. The recommended selection is MEDIAN.
  4. Select the Alpha Numeric default. Possible selections are MAX, MIN. The recommended selection is MAX.
  5. Select the Rate default. Possible selections are MAX, MIN, SUM, AVG, and Weighted Average. Recommended selection is Weighted Average. If Weighted Average is selected, then additionally select the balance column to use for weighting.
  6. Select the Integer default. Possible selections are MAX, MIN. The recommended selection is MAX
  7. Click Continue.

Step 3: Aggregation

  1. Navigate to the Aggregation section.

    Figure 4-69 Aggregation section


    Aggregation section

  2. Select the specific row you want to define from the bottom half of the page. You have the option to use the default values previously input on the Defaults tab or you can input a different Aggregation Action at the top of the page.
  3. Use the pagination selections at the bottom of the page to address/review all columns or type the column name or a portion of the column name to navigate directly to a specific column.
  4. Click Continue.

Step 4: Stratification section

  1. Navigate to Stratification section.

    Figure 4-70 Stratification section


    Stratification section

  2. Select the Column(s) and Stratification Action that you want to use for grouping the detailed records into aggregate/pooled records. Typical columns used for grouping will be dimension columns, balance or rate columns, or any other meaningful columns that you want to be unique for each pool record.
  3. For each Stratification column, select the Stratification Action. Options are Tier, Discrete, and Group by. Both the Tier and Discrete options require an additional Stratification Tier definition to be selected.
  4. Select Submit to save your inputs and close the rule