Siebel Assignment Manager Administration Guide > Availability-Based Assignment > Process of Configuring Assignment Objects for Availability-Based Assignment >

Extending an Assignment Object's Base Table for Availability-Based Assignment

Using Siebel Tools, you extend an assignment object's base table for availability-based assignment by performing the following tasks.

This task is a step in Process of Configuring Assignment Objects for Availability-Based Assignment.

To extend an assignment object's base table for availability-based assignment

1. Start Siebel Tools.
2. In the Object Explorer, expand the Table object, and then select Column.
3. In the Tables window, query for the appropriate table.

   For example, if you are extending the Service Request assignment object, query for the S_SRV_REQ table.

4. With the table selected, choose Tools > Lock Project (or Alt+L) to lock the project.
5. In the Columns list, choose Edit > Add New Record to add the records as described in the following table.

   	Record 1 (Required)	Record 2 (Required)	Record 3 (Optional)
   Name	X_DURN_MIN	X_START_TIME	X_EARLY_START_TIME
   Physical Type	Number	UTC Date Time	UTC Date Time
   Length	22	7	7
   Precision	22
   Scale	7
   LOV Type	APPOINTMENT_DURATION
   Cascade Mode	Ignore	Ignore	Ignore
   TxnLog Code	TRUE	TRUE	TRUE

6. In the Table column window and after you have created the new records you need, click Apply.

   This sends the new columns to the appropriate tables in the database.

7. Complete the fields in the Apply Schema dialog box.
   1. In the Tables field, click the select button, and choose one of the following:
      • All
      • Current Query
      • Current Row
   2. In the Table owner password field, enter the appropriate value.
   3. Click Apply.

      The base table is now extended with the following three columns: X_DURN_MIN, X_EARLY_START_TIME, and X_START_TIME.

      NOTE:  If using DB2 390 database, you must create a storage control file to accommodate the table space. You provide the location of the control file in the Apply Schema dialog box accordingly. You must create the storage control file from the siebsrvr/bin directory and the bufferpool size should be either 16k or 32k. If the Siebel Server is running on the UNIX platform, then the storage control file generation is command driven. If the Siebel Server is running on the Windows platform, then you generate the storage control file using the UI.

With the appropriate columns in place, use can now configure availability criteria for the assignment object.