4.3.2.4 Loading Scenario Group Memberships

To load a Scenario Group Membership, follow these steps:

  1. Add the appropriate user record to the KDD_SCNRO_GRP_MEMBERSHIP database table. The following table shows the KDD_SCNRO_GRP_MEMBERSHIP database table attributes.

    Table 4-9 KDD_SCNRO_GRP_MEMBERSHIP Table Attributes

    Column Name Description
    SCNRO_ID Scenario Identifier
    SCNRO_GRP_ID Scenario Group Identifier
    SCNRO_GRP_NM Scenario Group Name
  2. Add more records to the table by using a SQL script similar to the following sample script:

    INSERT INTO KDD_SCNRO_GRP_MEMBERSHIP (SCNRO_ID,SCNRO_GRP_ID,SCNRO_GRP_NM) VALUES (113000016,66,'BEX') ;

    INSERT INTO KDD_SCNRO_GRP_MEMBERSHIP (SCNRO_ID,SCNRO_GRP_ID,SCNRO_GRP_NM) VALUES (113000016,77,'CST') ;