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
- Start Siebel Tools.
- In the Object Explorer, expand the Table object, and then select Column.
- 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.
- With the table selected, choose Tools, then Lock Project (or Alt+L), to lock the project.
- In the Columns list, choose Edit, then Add New Record, to add the records as described in the following table.
|
|
|
|
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 |
- 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.
- Complete the fields in the Apply Schema dialog box.
- In the Tables field, click the select button, and choose one of the following:
- All
- Current Query
- Current Row
- In the Table owner password field, enter the appropriate value.
- 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.
|