Type Property of a Table Column
The type property specifies the type of column. Siebel CRM commonly uses the following values for the Type property of a table column:
Data. For more information, see Data Columns of a Siebel Table.
Extension. For more information, see Extension Columns of a Siebel Table.
System. For more information, see System Columns of a Siebel Table.
IFMGR. Occurs in an interface table. The Siebel Enterprise Integration Manager uses it internally. The name of an IFMGR type follows the IFMGR:nn format. For example, IFMGR:ROW_ID.
The following table describes possible values for the Type property of a Siebel table.
| Type | Description |
|---|---|
Data (Public) |
Contains data that Siebel CRM makes available through business components. To configure a public data table, you can use an extension table and extension column. It is among the predefined set of tables. |
Data (Private) |
Similar to a public data table, except it cannot contain an extension column. |
Data (Intersection) |
Defines a many-to-many relationship between two data tables. |
Extension |
Provides more columns that you can use to store data. Contains an implicit one-to-one relationship to the parent base table, which is the table that an extension table logically extends. A table with an implicit one-to-many relationship to a base table is also known as an extension table. The Type property for this type of table is Data (Public), and not Extension. |
Interface |
Siebel Enterprise Integration Manager (EIM) uses the Interface type to enter values in one or more base tables and subsequently to perform periodic batch updates between Siebel CRM and other enterprise applications. The suffix in the name of an interface table is _IF or _XMIF. |
Database View |
Reserved for Oracle internal use. |
Dictionary |
Reserved for Oracle internal use. |
Journal |
Reserved for Oracle internal use. |
Log |
Reserved for Oracle internal use. |
Repository |
Reserved for Oracle internal use. |
Virtual Table |
Reserved for Oracle internal use. |
Warehouse Types |
Reserved for Oracle internal use. |
Extension (Siebel) |
Reserved for Oracle internal use. An Extension (Siebel) table is typically an extension of the S_PARTY table. |