1. Configuring Siebel Business Applications
  2. Extension Columns of a Siebel Table

Extension Columns of a Siebel Table

An extension column is a column that stores custom data. Siebel CRM supports the following types of extension columns:

  • Predefined extension column. Included in a predefined extension table. Siebel CRM names these columns ATTRIB_nn, where nn is a value between 01 and 47. For example, ATTRIB_13. It is recommended that you do not modify or delete a predefined extension column.

  • Custom extension column in an extension table. Added by a developer to an extension table. Siebel CRM names these with an X_ prefix.

  • Custom extension columns in a base table. Added by a developer to a base table. The relational database system that you use with Siebel CRM determines if this configuration is allowed or not allowed. If the database system supports a custom extension column in a base table, it might be preferable for performance reasons to add it to the base table rather than to add it to an extension table. Performance might be affected if you add an extension column to an extension table because Siebel CRM creates extra SQL to join the extension table.