1. Assignment Manager Administration Guide
  2. Extending an Assignment Object's Base Table 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, then 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 that 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, 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. Create the storage control file from the SIEBSRVR_ROOT/bin directory, with a buffer pool size of either 16 KB or 32 KB. If the Siebel Server is running on UNIX or Linux, then the storage control file generation is command-driven. If the Siebel Server is running on Windows, then 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.