Siebel Finance Guide > Managing Product Group Visibility > Process for Establishing Confidential Mode Visibility >

Changing the Data Model for Confidential Mode Visibility

This step is part of Process for Establishing Confidential Mode Visibility.

To change the data model for Confidential mode visibility

1. Let MyApplet be the applet that requires product group visibility. Let MyObject be the business component of MyApplet. Please note that if you are following intersection table mode, then MyObject has to be a clone of the original business component of the applet, and you will change the value of 'Table' property of the business component in the next topic.

   For example, for applet 'FINS CI Opportunity List Applet', the business component is 'FINS CI Opportunity' which is a clone of the 'Opportunity' business component.

2. Find the base table of MyObject, for example, S_OPTY for Opportunity.
3. Add the following column to the base table:

   PGROUP_PUBLIC_FLG Character(1)

4. Create a new intersection table in between the base table and S_PGROUP.
5. Add the following foreign key columns to the new intersection table:

   PGROUP_ID Varchar(15) references S_PGROUP

   <SomeName> Varchar(15) references <BaseTable>