Naming Format for a Siebel Table

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

PREFIX_NAME_SUFFIX

The following table describes the naming format.

Part	Description
PREFIX	A one-letter to three-letter prefix that distinguishes the table from other tables. Example prefixes include EIM_, S_, W_, and so on.
NAME	A unique table name that is typically 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 that the ACT suffix represents. For example, S_EVT_ACT.

The following table describes some of the prefixes that Siebel CRM commonly uses. Each prefix indicates the part of the Siebel schema that contains the table.

Prefix	Description
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.

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

Suffix	Description
_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 that you can use to add custom data to the Siebel database.
_XA	A table that stores custom data that Siebel CRM associates with an object class.
_XM	A one-to-many extension table that you can use to add custom data to the Siebel database.