Bookshelf v8.1/8.2: System Fields of a Business Component

A system field is a business component field that represents the data that Siebel CRM gets from a system column. All business components in Siebel CRM include system fields. You are not required to do 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.

You must not modify a system field. For example, by renaming it. Siebel CRM does not support modifying 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. 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 where an empty value 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 14 describes the relationship that exists between a system field and a system column. Each field is predefined. You do not explicitly define it. You can configure Siebel CRM to reference a system field in the Field property of a control, list column, or other object, even though Siebel Tools does not display the field in the Business Components list.

Table 14. 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 Siebel CRM created the row.
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 Siebel CRM 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 Siebel CRM configures a multi-value link with a primary join. For more information, see Defining the Primary ID Field of a Multi-Value Link.
(varies)	DB_LAST_UPD	Stores the date of the most recent update that Siebel CRM performed on the row in the Siebel database. The system field name varies.

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