Extending the Opportunity Assignment Object’s Base Table for Team Scoring

Use the following procedure to extend the Opportunity assignment object’s base table for team scoring.

To extend the Opportunity object's base table for team scoring

1. Start Siebel Tools.

2. In the Object Explorer, expand the Table object, and then query for the S_OPTY table.

3. Lock the project for the object by choosing Tools, then Lock Project (or Alt+L).

   The pencil icon appears in the W field to indicate that the project for the object is locked.

4. In the Object Explorer, select Column.

5. In the Columns window, add the records shown in the following table.

   Property	Record 1	Record 2
   Name	X_POS_SCORE	X_ORG_SCORE
   Cascade Clear	Ignore	Ignore
   Physical Type	Data(Public)	Data(Public)
   Precision	22	22
   Scale	7	7
   Text Length	22	22
   Txn Log Code	TRUE	TRUE

   Note: The values and records shown are examples and can be modified, as appropriate, for your deployment.

6. Select each new record and click the Apply button.

7. In the Apply Schema dialog box, enter the appropriate value for database user password, and click Apply.

   The S_OPTY table is now extended with the following columns: X_POS_SCORE and X_ORG_SCORE.