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: PREFIX_NAME_SUFFIX
Table 4 describes the naming format.
Table 4. Parts of the Table Naming Format
|
|
PREFIX |
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. |
NAME |
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. |
SUFFIX |
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
|
|
EIM_ |
Interface table for Enterprise Integration Manager. |
S_ |
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. |
W_ |
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
|
|
_ATT |
File attachment table. |
_REL |
A table that supports a many-to-many relationship from an entity back to itself. |
_SS |
A table that stores Siebel-to-Siebel integration information. |
_X |
A one-to-one extension table, available for you to add custom data to the Siebel database. |
_XA |
A table that stores custom data that is associated with an object class. |
_XM |
A one-to-many extension table, available for you to add custom data to the Siebel database. |
|