Example of Copying Additional Columns to the Team Table

This topic is part of Configuring Assignment Objects to Copy Additional Columns to the Team Table.

The following procedure gives one example of copying additional columns to the team table. In this example, you copy data from the S_ASGN_GRP_POSTN rule group position table to the S_ORD_CRDT_ASGN team table of the Order (Sales Credit Assignment) assignment object.

You might use this feature differently, depending on your business model.

To configure the Order assignment object to copy the S_ORD_CRDT_ASGN column to the S_ASGN_GRP_POSTN team table

1. Start Siebel Tools.

2. Select the Order assignment object, which is the object for which you want to copy additional columns to the team table.

   1. In the Object Explorer, expand Workflow Policy Object.

   2. In the Workflow Policy Object window, select Order.

   3. In the Object Explorer, expand Assignment Object, and then select Assignment User Prop.

3. In the Assignment User Properties window, choose Edit, then New Record, to define user properties for the assignment object.

   1. In the Name field, type a name for the property, starting with PositionTeamDenorm followed by a digit (for example, PositionTeamDenorm1, PositionTeamDenorm2).

   2. In the Value field, use the following syntax to enter values (for value descriptions, see the following table):

      SrcCol,DestCol,UserKeyBool,DefaultValue

      For this example, SrcCol copies values come from the S_ASGN_GRP_POSTN table. The following table shows some of the valid user properties for the Order (Sales Credit Assignment) assignment object.

Name	Value
PositionTeamDenorm1	DATE1,START_DT,N
PositionTeamDenorm2	CHAR2,SLS_TERR_ID,Y
PositionTeamDenorm3	CHAR1,CRDT_RULE_ID,N
PositionTeamDenorm5	CHAR3,FROM_BTM_NODE_FLG,N
PositionTeamDenorm6	NUM2,ROLLUP_PCT,N
PositionTeamDenorm8	CHAR5,ROLLUP_FRMLA,N
PositionTeamDenorm21	BOOL5,QTA_RLP_ACNTED_FLG,N