Bookshelf v8.0: System Fields of a Business Component

A system field is a field in a business component that represents the data from a system column. All business components in Siebel CRM include system fields. You are not required to perform any special configuration to display or manipulate a system field. You do not need to define it as a business component field. For example, you can reference a system field in the Field property of a control, list column, or in another object.

NOTE: Do not change a system field. For example, by renaming it. Siebel CRM does not support changing a system field.

Relationship Between a System Field and a System Column

The Id field that represents the ROW_ID column in a business component is an implicit field, and Siebel Tools does not display it in the Object Explorer as a child field of a business component. However, every business component includes an Id field that represents the ROW_ID column of the base table of the business component, as defined in the Table property of the business component. The Siebel schema references the Id field in various properties throughout Siebel CRM. For example, in the Source Field property of a link in which an empty value also indicates the Id field.

You must not explicitly create a system field for a business component. If you create a business component field that references a system column, then Siebel CRM attempts to write a value to the column twice in the insert statement, which causes a duplicate column SQL error.

Table 13 describes the relationship between a system field and a system column. Because each field is predefined, you do not explicitly define it. You can reference a system field in the Field property of a control, list column, or other object, even though the field does not display in the Business Components list in Siebel Tools.

Table 13. Relationship Between a System Field and a System Column
System Field Name	System Column Name	Description
Id (or empty)	ROW_ID	Stores the primary key for the table.
Created	CREATED	Stores the date and time of when the row was created.
Created By	CREATED_BY	Stores the ROW_ID of the row from the S_USER table that references the person who created the record.
Updated	LAST_UPD	Stores the date of the most recent update that was performed on the row.
Updated By	LAST_UPD_BY	Stores the ROW_ID of the row from the S_USER table that references the person who last updated the record. In some situations, Siebel CRM updates this field even though the user does not actively update the record. For example, if a multi-value link is configured with a primary join. For more information, see Improving Performance by Defining the Primary ID Field of a Multi-Value Link.
(varies)	DB_LAST_UPD	Stores the date of the most recent update that was performed on the row in the Siebel database. The system field name varies.

Configuring Siebel Business Applications		Copyright © 2011, Oracle and/or its affiliates. All rights reserved. Legal Notices.