Property
|
Description/Usage
|
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 will be 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 Siebel internal use only.
|
|
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.
|
|
Name (R)
|
The unique name of the table.
|
|
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 eBusiness 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 will not be used in future releases. 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.
|
