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, then Lock Project (or Alt+L), to lock the project.
5. In the Columns list, choose Edit, then Add New Record, to add the records as described in the following table.

   Property	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	Not applicable	Not applicable
   Scale	7	Not applicable	Not applicable
   LOV Type	APPOINTMENT_DURATION	Not applicable	Not applicable
   Cascade Mode	Ignore	Ignore	Ignore
   TxnLog Code	TRUE	TRUE	TRUE

6. After you have created the new records you need in the Table column window, click Apply

   Doing 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:  For IBM DB2 for z/OS or OS/390, 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_ROOT/bin directory and the bufferpool size should be either 16 KB or 32 KB. If the Siebel Server is running on UNIX or Linux, the storage control file generation is command-driven. If the Siebel Server is running on Windows, you generate the storage control file using the GUI.

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