Siebel Object Types Reference > Siebel Object Types >


Siebel Object Types > Table

Creates a new table to store additional attributes.

Valid Values/Examples

Abbreviation 1-6 (O)

Specifies up to 6 alternative abbreviations for the table.

The abbreviations are used by the EIM Generator/Wizard in determining how to name interface table-columns used in foreign key mappings and should not be modified by customers.


Alias (O)

Not used.

Not applicable.

Append Data (O)

A TRUE or FALSE value.

Specifies to the database that new rows are to be inserted at the end of the table and cannot be turned on if there is a clustered index on that table.

TRUE — New rows are inserted at the end of the table.

Base Table Name (R)

If the Type property is Ext or Journal, the name of the table this table is extending or journaling.


Dflt Mapping Col Name Prefix (S)

The default name prefix to use when generating interface table column names.

For Oracle use only.


External API Write

Boolean property used to indicate whether or not inserts, updates, or deletes to external tables should be handled by an external API.

If this property is set to TRUE, the BusComp_PreWriteRecord should be scripted to publish the insert, update, or delete to an external API.

File (O)

A TRUE or FALSE value.

TRUE indicates that the table is used to store file attachment information.

Group (O)

Solely used to set table groups for IBM System 390.

Tables are primarily placed into groups that correspond to dock objects, with further differentiation taken into account for table size, access frequency, and so on.


Key Generation Business Service

The Business Service used to generate the primary key (Id field) for the Business Component. If this is not specified, the default row id generator is used for tables that have a configured column corresponding to the "Id" system field.


Key Generation Service Method

The name of the Business Service method to be invoked when generating the primary key of the Business Component.


Name (R)

The unique name of the table.


Owner Organization Specifier

Information not available.


Parent Table Column1 Name (O)

The column that points to the primary parent if this is a child or intersection table.


Parent Table Column2 Name (O)

The column that points to the second parent if this is an intersection table.


Status (O)

The current status of a table.

States whether tables from previous versions of Siebel business applications can be used in the most recent version of the application.

ACTIVE — Can still be used in latest version of the application.

INACTIVE — Discontinued and not supported in the latest release. Extension columns that reside on inactive tables must be moved to alternate tables. Fro example, S_EMPLOYEE should be moved to S_CONTACT, S_USER, or S_EMP_PER.

EOL (End of life) — Not used in the latest release. The table should be deleted because it is no longer used. For example, the old S_*_IF tables.

NOT USED — Not used in latest release by the application, but you may continue to use the table. For example, table can be used as is for docking or EIM.

Type (S)

A description of what the table is used for.


User Name (R)

The name for the table.


Volatile (O)

A TRUE or FALSE value.

TRUE — Specifies to the database not to use the statistics produced by runstats for that table.

See Also

Data Source (H)
User Key

Siebel Object Types Reference Copyright © 2006, Oracle. All rights reserved.