Table Naming Conventions

Tables in the Siebel database use a three-part naming convention. The syntax is: PREFIX_NAME_SUFFIX.

PREFIX	Table names in Siebel Business Applications have a one- to three-letter prefix (EIM_, S_, W_, and so on) to distinguish them from other tables in your application.
NAME	A unique table name that is generally an abbreviation of the entity supertype name.
SUFFIX	A supertype name can be followed by the entity subtype. For example, the supertype EVT (event) includes ACT (activity) as one of its subtypes. Thus, the name becomes S_EVT_ACT.

The prefix indicates the part of the Siebel schema to which a table belongs. The following table provides some of the prefixes and their descriptions.

Prefix	Meaning
EIM_	Interface tables for Siebel Enterprise Integration Manager.
S_	Siebel base table. (Exception: Tables with names of the form S_<name>_IF are obsolete interface tables.)
W_	Oracle Business Analytics Warehouse table, described in Oracle Business Analytics Warehouse Data Model Reference. .

The suffix indicates a table type. The following table provides some of the suffixes and their descriptions.

Suffix	Meaning
_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.
_V	A table that represents a database view.
_X	One-to-one extension table, available for customers to add attributes to the Siebel database.
_XA	A table that stores extended attributes associated with an object class.
_XM	One-to-many extension table, available for customers to add attributes to the Siebel database.