Bookshelf Home | Contents | Index | PDF |
Configuring Siebel Business Applications > About Tables and Columns > Options to Configure the Data Objects Layer > Options to Use a Predefined One-to-One Extension TableSiebel CRM uses one-to-one predefined extension tables for many of the predefined data tables. The predefined extension table contains columns of various types that possess a predefined one-to-one relationship with a base table. This base table uses more columns in the extension table for new functionality without modifying the base table or database schema. For more information, see Guidelines for Modifying a Predefined One-to-One Extension Table. A one-to-one predefined extension table does not require you to create a new business component because Siebel CRM implicitly defines this type of table as a join. For more information about implicit joins, see How an Extension Table Stores Custom Data. A one-to-one predefined extension table includes an _X suffix, such as S_PROD_INT_X. Siebel CRM names the columns that these tables contain with ATTRIB_nn, where nn is a value from 01 to 47. Table 10 lists the different data types in a Siebel extension table and the number of columns of each data type. Determining Availability of a Predefined Extension ColumnYou must determine whether a predefined Siebel application uses or does not use the table column before you use a predefined extension table. To do this, you search the Siebel repository for fields that Siebel CRM associates with the column. CAUTION: If a predefined field references a column, then do not deactivate the field. To determine availability of a predefined extension column
|
Configuring Siebel Business Applications | Copyright © 2016, Oracle and/or its affiliates. All rights reserved. Legal Notices. | |