Configuring Siebel Business Applications > About Tables and Columns > About Siebel Tables >

Naming Format for a Siebel Table

A Siebel table in the Siebel database adheres to the following three part naming format:


Table 4 describes the naming format.

Table 4. Parts of the Table Naming Format


A one-letter to three-letter prefix that distinguishes the table from other tables in Siebel CRM. Example prefixes include EIM_, S_, W_, and so forth.


A unique table name that is generally an abbreviation of the name of the entity supertype. For example, the table name for the event supertype is EVT.


The subtype of the entity. For example, the EVT supertype includes the activity subtype, which is represented in the suffix as ACT. For example, S_EVT_ACT.

Table 5 describes some of the prefixes that Siebel CRM commonly uses. Each prefix indicates the part of the Siebel schema to which a table belongs.

Table 5. Table Prefixes That Siebel CRM Commonly Uses


Interface table for Enterprise Integration Manager.


Siebel base table.

In some situations, a table might contain a name of the form S_name_IF. This format indicates an obsolete interface table.


Siebel Business Data Warehouse table.

Table 6 describes some of the suffixes that Siebel CRM commonly uses. Each suffix indicates a table type.

Table 6. Table Suffixes That Siebel CRM Commonly Uses


File attachment table.


A table that supports a many-to-many relationship from an entity back to itself.


A table that stores Siebel-to-Siebel integration information.


A one-to-one extension table, available for you to add custom data to the Siebel database.


A table that stores custom data that is associated with an object class.


A one-to-many extension table, available for you to add custom data to the Siebel database.

Configuring Siebel Business Applications Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.